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

 

Hi there,

 

I have a question. I am a new user and just wanting to start working with my data, but I'm getting stuck on the first step. Although I can import the data from my desktop to SAS "Server Files and Folders", it doesn't recognize the dataset "test", and does not create a new table in the "WORK" Library despite specifying that it should be put there. What is the issue? Could it be the folder on my personal computer? Or is it the folder in "Server Files and Folders"? It doesn't look like there's an issue with the code (see below). Any help would be phenomenal.

 

options linesize = 80 pagesize = 56 nodate;
FILENAME REFFILE '/home/xshinbrot0/sasuser.v94/test.csv';
PROC IMPORT DATAFILE=REFFILE
    DBMS=CSV
    OUT=WORK.test;
    GETNAMES=YES;
RUN;
PROC CONTENTS DATA=WORK.test;
Run;

 

This is the error code it produced, basically saying it doesn't exist.

    OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 59         
 60         options linesize = 80 pagesize = 56 nodate;
 61         FILENAME REFFILE '/home/xshinbrot0/sasuser.v94/test.csv';
 62         PROC IMPORT DATAFILE=REFFILE
 63         DBMS=CSV;
 ERROR: Output SAS data set must be provided.
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              36.65k
       OS Memory           33444.00k
       Timestamp           06/14/2017 04:53:04 PM
       Step Count                        196  Switch Count  24
       Page Faults                       0
       Page Reclaims                     9
       Page Swaps                        0
       Voluntary Context Switches        40
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           0
       
 64         OUT=WORK.test;
 65         GETNAMES=YES;
 66         RUN;
 
 
 67         PROC CONTENTS DATA=WORK.test;
 ERROR: File WORK.TEST.DATA does not exist.
 68         Run;
 
 NOTE: Statements not processed because of errors noted above.
 NOTE: PROCEDURE CONTENTS used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              324.28k
       OS Memory           33704.00k
       Timestamp           06/14/2017 04:53:04 PM
       Step Count                        197  Switch Count  26
       Page Faults                       0
       Page Reclaims                     12
       Page Swaps                        0
       Voluntary Context Switches        48
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           8
       
 NOTE: The SAS System stopped processing this step because of errors.
 69         
 70         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 82         

 
User: xshinbrot0
Option Values
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

It is not the same error. It is completely different:

 

Please read the highlighted text below:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update
mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
Unable to sample external file, no data in first 5 records.

 

Proc import, since it is a GUESSING procedure quits when there is not data in the first five rows unless told otherwise.

You can specify a DATAROW statement to specify which line in the file the actual data starts. You will have to open the file and determine that.

 

You may have issues with your variable names with that many blank rows.

View solution in original post

5 REPLIES 5
ballardw
Super User

Please the log result including the submitted statements starting with the filename statement and any messages. Paste Log results into a codebox opened with the forum {i} menu icon to preserve formatting. The main window will reformat the results and sometimes the diagnositics present in the log are positionally important.

ballardw
Super User

ERROR: Output SAS data set must be provided.

 

You have ; in the middle of the proc statement. There cannot be a ; before the OUT part of proc import.

Which means the code you sumitted is not the same as the code in your question.

You submitted:

FILENAME REFFILE '/home/xshinbrot0/sasuser.v94/test.csv';
 62         PROC IMPORT DATAFILE=REFFILE
 63         DBMS=CSV;

remove the ; after  dbms=csv.

 

xshinbrot0
Calcite | Level 5

Thank you for your response. Unfortunately it provides the same results.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 59         
 60         options linesize = 80 pagesize = 56 nodate;
 61         FILENAME REFFILE '/home/xshinbrot0/sasuser.v94/test.csv';
 62         PROC IMPORT DATAFILE=REFFILE
 63         DBMS=CSV
 64         OUT=WORK.test;
 65         GETNAMES=YES;
 66         RUN;
 
 NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update 
 mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
 Unable to sample external file, no data in first 5 records.
 ERROR: Import unsuccessful.  See SAS Log for details.
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           0.03 seconds
       user cpu time       0.02 seconds
       system cpu time     0.01 seconds
       memory              9467.25k
       OS Memory           33820.00k
       Timestamp           06/14/2017 07:05:43 PM
       Step Count                        4  Switch Count  46
       Page Faults                       0
       Page Reclaims                     2950
       Page Swaps                        0
       Voluntary Context Switches        159
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           72
       
 
 
 67         PROC CONTENTS DATA=WORK.test;
 ERROR: File WORK.TEST.DATA does not exist.
 68         Run;
 
 NOTE: Statements not processed because of errors noted above.
 NOTE: PROCEDURE CONTENTS used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              330.43k
       OS Memory           29096.00k
       Timestamp           06/14/2017 07:05:43 PM
       Step Count                        5  Switch Count  26
       Page Faults                       0
       Page Reclaims                     59
       Page Swaps                        0
       Voluntary Context Switches        48
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           8
       
 NOTE: The SAS System stopped processing this step because of errors.
 69         
 70         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 82         
ballardw
Super User

It is not the same error. It is completely different:

 

Please read the highlighted text below:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update
mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
Unable to sample external file, no data in first 5 records.

 

Proc import, since it is a GUESSING procedure quits when there is not data in the first five rows unless told otherwise.

You can specify a DATAROW statement to specify which line in the file the actual data starts. You will have to open the file and determine that.

 

You may have issues with your variable names with that many blank rows.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2253 views
  • 0 likes
  • 2 in conversation