BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dkcundiffMD
Quartz | Level 8

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Shmuel
Garnet | Level 18

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.

View solution in original post

6 REPLIES 6
Shmuel
Garnet | Level 18

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.

dkcundiffMD
Quartz | Level 8

Thanks, your post led me to find the answer. 

David 

Ksharp
Super User

Try to specify SHEET name :

proc import 

.......;

sheet='xxxx';

dkcundiffMD
Quartz | Level 8

Thanks. It's fixed. 

David 

dkcundiffMD
Quartz | Level 8
That led me to the solution. I worked back from the log to the code.
Thanks.
David

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 4390 views
  • 3 likes
  • 4 in conversation