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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.