topic Re: Import csv into sas in SAS Programming

Import csv into sas

SungPing — Fri, 27 Mar 2020 08:01:28 GMT

Hello,

i have two SAS Viya modules which are SAS® Visual Data Mining and Machine Learning and SAS® Visual Analytics and my storage is at 'my folder'. I unable to import csv file from my local disk and i checked that the csv file that i want to import is in the path that i write in the code. I able to upload it in SAS University Edition but i enable to upload it with the use of SAS Viya. Here is the log,

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

78 /** FOR CSV Files uploaded from Windows **/

80 FILENAME CSV "C:\Users\user\Desktop\SASUniversityEdition\myfolders\Testing2.csv" TERMSTR=CRLF;

82 /** Import the CSV file. **/

84 PROC IMPORT DATAFILE=CSV

85 OUT=WORK.MYCSV

86 DBMS=CSV

87 REPLACE;

88 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.

WARNING: Physical file does not exist,

/opt/sas/viya/config/var/run/compsrv/default/a06c76f7-1bec-4f6e-aa80-12f984a485f1/C:\Users\user\Desktop\SASUniversityEdition\myfolde

rs\Testing2.csv.

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.05 seconds

cpu time 0.09 seconds

90 /** Print the results. **/

92 PROC PRINT DATA=WORK.MYCSV; RUN;

ERROR: File WORK.MYCSV.DATA does not exist.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

94 /** Unassign the file reference. **/

96 FILENAME CSV;

NOTE: Fileref CSV has been deassigned.

99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

112

Re: Import csv into sas

ChrisNZ — Fri, 27 Mar 2020 09:08:07 GMT

One thing is certain:

The file

/opt/sas/viya/config/var/run/compsrv/default/a06c76f7-1bec-4f6e-aa80-12f984a485f1/C:\Users\user\Desktop\SASUniversityEdition\myfolders\Testing2.csv.

does not exist.

You are mixing a unix path (in blue) and a windows path (in red).

Where is your file?

Note that this evidence is also what the log reads unambiguously:

WARNING: Physical file does not exist

Re: Import csv into sas

Kurt_Bremser — Fri, 27 Mar 2020 10:17:25 GMT

Your Viya runs on a UNIX system, using Windows names will not work.

You need to upload your file to the Viya system first, so the SAS process running there has access to it.

Doesn't the interface provide a means for uploading?

Re: Import csv into sas

SungPing — Fri, 27 Mar 2020 11:23:27 GMT

Yes, there is an upload button between the three dots and the delete button. I uploaded the file and insert the file path into the codes below

FILENAME CSV "/Users/MY035/My Folder/Testing1.csv" TERMSTR=LF;

/** Import the CSV file. **/

PROC IMPORT DATAFILE=CSV
OUT=WORK.MYCSV
DBMS=CSV
REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.MYCSV; RUN;

/** Unassign the file reference. **/

FILENAME CSV;

and

FILENAME CSV "/Users/MY035/My Folder/Testing1.csv" TERMSTR=CRLF;

PROC IMPORT DATAFILE=CSV
OUT=WORK.MYCSV
DBMS=CSV
REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.MYCSV; RUN;

/** Unassign the file reference. **/

FILENAME CSV;

But both codes showed the same results, it still cannot.

Re: Import csv into sas

Kurt_Bremser — Fri, 27 Mar 2020 11:33:07 GMT

Please post the log from one of these import steps; use the </> button for posting log text.

Re: Import csv into sas

SungPing — Fri, 27 Mar 2020 11:37:07 GMT

1     OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
75    
76    FILENAME CSV "/Users/MY035/My Folder/Testing1.csv" TERMSTR=CRLF;
77    
78    
79    PROC IMPORT DATAFILE=CSV
80        OUT=WORK.MYCSV
81        DBMS=CSV
82        REPLACE;
83    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.
WARNING: Physical file does not exist, /Users/MY035/My Folder/Testing1.csv. 
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.06 seconds
      cpu time            0.10 seconds
      
84    
85    /** Print the results. **/
86    
87    PROC PRINT DATA=WORK.MYCSV; RUN;
ERROR: File WORK.MYCSV.DATA does not exist.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
88    
89    /** Unassign the file reference.  **/
90    
91    FILENAME CSV;
NOTE: Fileref CSV has been deassigned.
92    
93    
94    OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
107

Re: Import csv into sas

Tom — Fri, 27 Mar 2020 13:50:24 GMT

With VIYA you need to define a filename using their special filename engine to be able to find the file. I don't remember the syntax since I don't use VIYA, but this question has been asked and answered on this forum before.

Re: Import csv into sas

Kurt_Bremser — Fri, 27 Mar 2020 16:08:29 GMT

@Tom's answer made me go searching, and I found this: https://documentation.sas.com/?docsetId=lestmtsglobal&docsetTarget=p0qapul7pyz9hmn0zfoefj0c278a.htm&docsetVersion=9.4&locale=en

Re: Import csv into sas

ChrisNZ — Sat, 28 Mar 2020 04:17:39 GMT

@ChrisHemedinger Should there be a Viya programming community? The SAS language is different.

Re: Import csv into sas

ChrisHemedinger — Sun, 29 Mar 2020 20:03:19 GMT

Hi @ChrisNZ - it's true that there are new elements in SAS Viya (especially with CAS actions and specific procedures in CAS). But most existing SAS code (including PROC IMPORT) can work in a SAS Viya environment. This is especially true in SAS Viya 3.5 and later.

So, I'm not opposed to a SAS Viya (or CAS) board...but I don't want to fragment discussions if we don't need to. New users who are working in SAS Viya can benefit from the expertise of all of those contributing general SAS programming solutions.