Hello,
I am trying to read in an excel file with 200 rows of data but SAS only shows 100. Am I missing a parameter or something in the code?
Any help is appreciated. Thanks,
Melva
/** Import an xlxs file. **/
PROC IMPORT DATAFILE="/folders/myshortcuts/MySASFolder/HBAT200"
OUT=WORK.HBAT200
DBMS=xlsx
REPLACE;
RUN;
/** Print the results. **/
PROC PRINT DATA=WORK.HBAT200; RUN;
What does the log say?
Please post the full log.
@MRatchford wrote:
Hello,
I am trying to read in an excel file with 200 rows of data but SAS only shows 100. Am I missing a parameter or something in the code?
Any help is appreciated. Thanks,
Melva
/** Import an xlxs file. **/
PROC IMPORT DATAFILE="/folders/myshortcuts/MySASFolder/HBAT200"
OUT=WORK.HBAT200
DBMS=xlsx
REPLACE;
RUN;/** Print the results. **/
PROC PRINT DATA=WORK.HBAT200; RUN;
Thanks Reeza for your prompt reply. I found my mistake. I had not noticed that I was pointing to the first sheet of the excel workbook which has 100 rows! I am now able to load the second sheet which is the one with 200.
Melva
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.