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....
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.
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.
PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.