topic Re: Datafile imported successfully then showed no data in SAS Studio

Datafile imported successfully then showed no data

dkcundiffMD — Tue, 03 Dec 2019 05:10:13 GMT

Using SAS Studio University Edition, I imported a datafile in Excel worksheet, which had 3.1 mb. When printing the datafile the error was "no columns and no rows." The code and log files are attached.

Thanks.

Re: Datafile imported successfully then showed no data

Shmuel — Tue, 03 Dec 2019 05:59:05 GMT

1) You are not printing the data created by import.

The text attached as pdf files relate to different datasets.

2) Use the {i} icon to enter log and the running men icon to enter code, using copy-paste,

instead attaching pdf files.

Re: Datafile imported successfully then showed no data

Ksharp — Tue, 03 Dec 2019 11:41:59 GMT

Try to specify SHEET name :

proc import

.......;

sheet='xxxx';

Re: Datafile imported successfully then showed no data

Kurt_Bremser — Tue, 03 Dec 2019 12:00:47 GMT

The log is from a different code that obviously worked (NOTE: The import data set has 7886 observations and 82 variables.).

Re: Datafile imported successfully then showed no data

dkcundiffMD — Tue, 03 Dec 2019 23:28:12 GMT

Thanks, your post led me to find the answer.

David

Re: Datafile imported successfully then showed no data

dkcundiffMD — Tue, 03 Dec 2019 23:31:55 GMT

Thanks. It's fixed.

David

Re: Datafile imported successfully then showed no data

dkcundiffMD — Tue, 03 Dec 2019 23:33:32 GMT

That led me to the solution. I worked back from the log to the code.
Thanks.
David