topic Re: Converting SAS files to CSV in university Edition - CSV showing up blank in New SAS User

Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 18:24:12 GMT

Hi,

So I'm very unfamiliar with SAS but have been working with the University Edition. I have a CD file of .sas7bdat files that I need to convert into CSV files. My issue is that when the CSV file is generated, I'm getting an error in the SAS log and my CSV file (which opens in excel) does not have anything in it. Data is the name of the library I created to hold my data (but I'm not even sure if I did that correctly) and this is the code I'm running (donor is the name of my data file I'm trying to convert):

proc export data=data.donor
            outfile=_dataout
            dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=donor.csv;

This is the error I'm getting:

ERROR: File DATA.DONOR.DATA does not exist.

ERROR: Export unsuccessful. See SAS Log for details.

Again, I know almost nothing about SAS and how it works so I apologize if I'm missing any information needed to help answer this question, but any help would very much be appreciated.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 18:30:46 GMT

What is the value for _dataout?

Show your full code please.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 18:31:27 GMT

You can also just use the export task and it will generate the code for you, assuming you've assigned a libname correctly and can see your data sets. You can also just right click the file and select export and it will export the file.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 18:35:33 GMT

Hi,

That is my full code. I went to the "snippets" section and chose "generate CSV file" which gives me this:

proc export data=sashelp.cars
outfile=_dataout
dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=cars.csv;

what I posted in my original question is what i changed it to so I could try and convert my file. Again, I seriously don't know anything about SAS and I'm trying to do this for a professor who also does not know SAS so thank you for your help!!!

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 18:39:20 GMT

Where did you create the library? Did you put the files in the myfolder you created?

What you need to do:

1. Place SAS files in myfolders (created at setup)
2. Assign a libname to that location, right click myfolders on the Servers FIles and FOlders pane to get the list of files
3. Then right click one of the files in the LIbrary pane and select Export. That will give you the code you need. Or use a snippet at that point. I suspect your other issues are affecting your export.

Have you verified that you can even see the data sets and that they're valid?

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 18:53:00 GMT

So yes, my data is in the "myfolders" folder I created at set up. Should I be able to expand the library when I'm in the library tab to see my data? Even when i try to recreate the library I'm not able to open the files or expand under the library I created. I'm able to open the files in SAS so i can see that they're valid and contain data, so I know thats ok. I just think I'm setting up my library wrong or something.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 18:55:39 GMT

Show your full code - ie the libname statement and the log in this case that would have created the library with your data.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 18:56:54 GMT

libname mydata '/folders/myfolders/';


proc export data=myData.data1 outfile = "/folders/myfolders/data1.csv" dbms=csv replace;
run;

That's usually all you need then run the PROC EXPORT for each file.

Change the DATA = to be your data set name and the name in the outfile portion as well.

@bhanl004 wrote:

So yes, my data is in the "myfolders" folder I created at set up. Should I be able to expand the library when I'm in the library tab to see my data? Even when i try to recreate the library I'm not able to open the files or expand under the library I created. I'm able to open the files in SAS so i can see that they're valid and contain data, so I know thats ok. I just think I'm setting up my library wrong or something.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 19:00:09 GMT

libname data "/folders/myfolders";

run;

proc export data=donor.sas7bdat
            outfile='_donor.csv'
            dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=donor.csv;

The lib statement runs successfully, but I still cannot expand it out when I'm under libraries so I cant select the export option.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 19:02:59 GMT

Show the log.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 19:05:16 GMT

this is my log: (sorry, I know this is all probably very simple but having never worked with SAS I just have no idea whats going on, I appreciate your help!!)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 libname data "/folders/myfolders";

NOTE: Libref DATA refers to the same physical library as MYDATA.

NOTE: Libref DATA was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders

75 run;

77 proc export data=donor.sas7bdat

78 outfile='_donor.csv'

79 dbms=csv replace;

80 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: Libref DONOR is not assigned.

ERROR: Export unsuccessful. See SAS Log for details.

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

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

82 %let _DATAOUT_MIME_TYPE=text/csv;

83 %let _DATAOUT_NAME=donor.csv;

87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Tom — Wed, 16 Oct 2019 19:09:28 GMT

@bhanl004 wrote:
libname data "/folders/myfolders";

run;

proc export data=donor.sas7bdat
            outfile='_donor.csv'
            dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=donor.csv;
The lib statement runs successfully, but I still cannot expand it out when I'm under libraries so I cant select the export option.

You created a libref of DATA, but you don't use it.

Instead you told PROC EXPORT to read the dataset named SAS7BAT from the libref named DONOR.

If you have a file named donor.sas7bdat in the folder you pointer DATA at then you can use either

data=data.donor

in your PROC EXPORT statement.

Or just skip the libname statement and use:

data='/folders/myfolders/donor'

data='/folders/myfolders/donor.sas7bdat'

Note that if the file is actually named DONOR.sas7bdat or Donor.sas7bdat then SAS will not be able to see it. The name of the file must be in all lowercase because SAS University Edition is running on a Unix machine (virtual) and Unix treats the case of the letters in filenames as significant.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 19:17:55 GMT

So when I run that, I'm still getting the same error.

Code:

libname data "/folders/myfolders";

run;

proc export data=DATA.donor
outfile='_donor.csv'
dbms=csv replace;
run;

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=donor.csv;

Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 libname data "/folders/myfolders";

NOTE: Libref DATA refers to the same physical library as MYDATA.

NOTE: Libref DATA was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders

75 run;

77 proc export data=DATA.donor

78 outfile='_donor.csv'

79 dbms=csv replace;

80 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: File DATA.DONOR.DATA does not exist.

ERROR: Export unsuccessful. See SAS Log for details.

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

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.03 seconds

cpu time 0.03 seconds

82 %let _DATAOUT_MIME_TYPE=text/csv;

83 %let _DATAOUT_NAME=donor.csv;

87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Tom — Wed, 16 Oct 2019 19:23:36 GMT

You do not have a file in that folder named donor.sas7bdat.

If you think you have such a file double check the location (is it really in the directory you used?) and the file name (perhaps it is donors.sas7bdat? Perhaps the filename a blank in the beginning or end that you are no seeing).

The filename (donor.sas7bdat) must be in all lowercase letters or SAS will not see it.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 19:29:07 GMT

Okay, so you helped me figure out the issue with my name/library. and now my code is running without issue, but my CSV file is still showing up blank with no values when I open it. I know there is data in the files I'm converting, so I'm not sure why this is happening.

p.s. - thank you for the help!!!

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Reeza — Wed, 16 Oct 2019 19:36:11 GMT

Please try the code I posted instead of the code you're running and post the log.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Tom — Wed, 16 Oct 2019 19:36:18 GMT

Make sure you don't have the same issue with locating the output file as you had with finding the input dataset. Perhaps you are looking at some older version instead of the one made the last time. Also make sure you are not overwriting it with some other code that runs later.

Note that the code you posted was using a filename without any path. That is probably not going to work in SAS UE as the normal current working directory will be pointing to a location where you will not have write access. But you should get an error in that case.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

bhanl004 — Wed, 16 Oct 2019 19:40:28 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 libname mydata '/folders/myfolders/';

NOTE: Libref MYDATA refers to the same physical library as MYFOLDER.

NOTE: Libref MYDATA was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders

76 proc export data=mydata.donor outfile = "/folders/myfolders/data1.csv" dbms=csv replace;

77 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: File MYDATA.DONOR.DATA does not exist.

ERROR: Export unsuccessful. See SAS Log for details.

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

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Tom — Wed, 16 Oct 2019 19:41:28 GMT

That is the same error as before. There is no data to export.

Re: Converting SAS files to CSV in university Edition - CSV showing up blank

Kurt_Bremser — Wed, 16 Oct 2019 20:00:07 GMT

Make sure that the physical filename of the dataset file is all lowercase, or SAS won't recognize it.