01-25-2018 03:14 AM
I am running below code to import excel file in sas university edition, but I can only see running status and not getting output. Sas also not showing any error. Please solve this problem and suggest solutions. Thanks
proc import datafile= "/folders/myfolders/Gift.xls"
dbms=xls out = Gift replace;
getnames = yes;
01-25-2018 03:27 AM
I moved your question to the proper community.
"Community Matters" is reserved for questions concerning the working/using of the SAS communities as such.
Are you sure that your file is an old-style Excel file (2003 or earlier) and not in fact a .xlsx with the wrong filename extension?
Try to open it with WinZip or 7-zip. If that is possible, use dbms=xlsx. And store such files as .xlsx in the future.
01-25-2018 03:47 AM