Prev: Chow test with categorical vars
Next: Import Error
From: Phil Spence on 25 Feb 2010 15:38
I have a macro that reads the filenames from a director (all Excel files)
and then loops through, using SAS/Access to PC file formats to read the
Excel file, and then after the file is read into a SAS dataset, I use proc
sql to insert them into one table.

Everything works fine, however, some of the datatypes are different for a
particular field, depending on the file. In Oracle, I would just to_char
everything. But if I try to INPUT these fields as character, I get an error
stating that the character format requires a character value. Is there a
function to just import everything as character. TIA.
 | 
Pages: 1
Prev: Chow test with categorical vars
Next: Import Error