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

[MRatchford]

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;

[Reeza]

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;

---

[MRatchford]

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