topic Re: Reading CSV - SAS studio in SAS Programming

Reading CSV - SAS studio

Ndiritu — Thu, 28 Aug 2014 15:33:06 GMT

Hello,

Could someone guide me on how to read CSV file into SAS STUDIO. I uploaded the file (which was originally excel file) in the navigation panel of SAS. My issue is, cannot get the file location in the infile statement. When I check under properties of the file to get the file path, I see "/folders/myfolders" but do not know the drive where it is saved.

Thanks,

Sim

Re: Reading CSV - SAS studio

slg — Thu, 28 Aug 2014 16:17:25 GMT

Try moving the CSV to a metadata accessible location/folder

Re: Reading CSV - SAS studio

Cynthia_sas — Thu, 28 Aug 2014 17:00:21 GMT

Hi:

Let's assume that you have set up this structure of folders on your C: drive:

c:\SASUniversityEdition\myfolders

AND, let's assume that you have set that up as your shared folder location. Then under that structure, you have a subfolder called "mydata" and your CSV file (shown here as STUFF.CSV):

c:\SASUniversityEdition\myfolders\mydata\stuff.csv

This is the Windows path to your shared folders location. You cannot use an INFILE statement that points to the C: drive path. That's because your SAS University Edition vApp is on a Linux Machine and it doesn't know about Windows locations. So you have to use a Unix/Linux path location:

INFILE '/folders/myfolders/mydata/stuff.csv' dlm=',' dsd;

Note how the c:\SASUniversityEdition portion of the Windows path turns into /folders in the Unix path. Then notice how the slashes are Unix slashes, not Windows slashes in the rest of the path specification.

If you do not know how to set up shared folders please read the documentation for your virtual machine software.

cynthia

Re: Reading CSV - SAS studio

Ndiritu — Thu, 28 Aug 2014 18:42:39 GMT

Thanks for your time Cynthia, below is the error I keep getting

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 proc import datafile='folders/myfolders/Partial_1.csv'

44 out=value_1

45 dbms=csv

46 replace;

47 getnames=no;

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

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/folders/myfolders/Partial_1.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.35 seconds

cpu time 0.41 seconds

50 proc print data=value_1;

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

51 run;

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

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.02 seconds

cpu time 0.04 seconds

52 ;

53 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Reading CSV - SAS studio

jakarman — Thu, 28 Aug 2014 19:01:26 GMT

You are just missing a /. just before folders... proc import datafile='/folders/myfolders/Partial_1.csv'

What happens: it did not find the file there

- The error on the /opt/sasinside/SASConfig/Lev1/SASApp/folders/myfolders/Partial_1.csv. is not logical. It is tryind to find the file in your current directory. This location is not nicely friendly set.

- It did try to update something in the SASUSER for some reason also that one is locked.

Getting more errors on the wrong location .