topic Re: IMPORT XLS IN SAS STUDIO in SAS Studio

IMPORT XLS IN SAS STUDIO

mona4u — Mon, 07 May 2018 13:47:26 GMT

Hi,

I'm trying to import xls dataset to SAS Studio. I just realized that it only importing the first 100 obs. The xls dataset contains 1100 obs

this is the code I'm using

proc import out=Oricq
datafile="llllll.xls"
dbms=xls replace;

Kurt_Bremser — Mon, 07 May 2018 13:53:16 GMT

It could be that you have system option obs=100 set (for testing in a previous code).

Ksharp — Tue, 08 May 2018 13:56:27 GMT

Try to save XLS as CSV and run PROC IMPORT .