topic Re: Loading Excel Data in SAS Studio - 200 rows but SAS only shows 100 in SAS Studio

Loading Excel Data in SAS Studio - 200 rows but SAS only shows 100

MRatchford — Tue, 13 Feb 2018 01:38:03 GMT

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;

Re: Loading Excel Data in SAS Studio - 200 rows but SAS only shows 100

Reeza — Tue, 13 Feb 2018 03:28:18 GMT

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;

Re: Loading Excel Data in SAS Studio - 200 rows but SAS only shows 100

MRatchford — Tue, 13 Feb 2018 13:19:38 GMT

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