10-02-2014 04:24 PM
how can convert excel file into sas dataset using infile statement.....I was using proc import but values are getting truncated........my excel has 1st row as variable names and every collumn in excel corresponds to variable name...can someone help infile statement for this kind of excel....
10-06-2014 11:44 AM
Reading Excel via a DATA step is painful and Excel version dependent. You might have a chance with .xlsx files as they are stored as .xml files.
When I have that problem, there are a couple of approaches to take.
-- look at the SCANTEXT and TEXTSIZE options in PROC IMPORT. They may need to be changed to control truncation.
-- use SAS Enterprise Guide to read the data. I fined it a bit more flexible than IMPORT for messy data.
10-06-2014 01:21 PM
LIBNAME gives you the most flexibility. Yet, in Excel data type is defined at the cell level and you are trying to import the data into a (database) structure where data type is defined on a column basis.
Sometimes, when possible, the simplest way to successful importation is to modify the Excel sheet. Sometimes, you must read cell values as character and accept the incurring loss of precision. No solution is optimal in all cases.
Please post an example of your data to get more specific advice.