topic Re: Converting SAS files to CSV files in SAS OnDemand for Academics in New SAS User

Converting SAS files to CSV files in SAS OnDemand for Academics

fikel — Thu, 07 Jan 2021 23:16:33 GMT

Hello, I started working with SAS this week. I have a SAS file, I would like to convert to a CSV file. I have seen similar questions in regard to SAS University edition, but those answers have not helped which I think is related to the OnDemand version storing data in the cloud instead of on my mac. I have uploaded the file (foodcodes_and_desc) to SAS studio and created a permanent library called phenbase. I have tried this snippet:

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

%let _DATAOUT_MIME_TYPE=text/csv;
%let _DATAOUT_NAME=foodcodes_and_desc;

but I get an empty file and these errors:

I then tried this, but got the same errors:

proc export data=phenbase.foodcodes_and_desc
         outfile='/home/u50451669/Polyphenol_baseline_databases/foodcodes.csv'
         dbms=csv replace;
run;

In the examples, I have seen for University edition, people export to their myfolders folder that was shared with SAS, but that isn't a part of OnDemand, so I'm not sure how to go about actually getting a csv version of the document. I would greatly appreciate the help, thank you!

Re: Converting SAS files to CSV files in SAS OnDemand for Academics

Kurt_Bremser — Thu, 07 Jan 2021 23:32:04 GMT

Check the exact spelling of the folder

Polyphenol_baseline_databases

in your home directory. Keep in mind that the UNIX system where On Demand runs is case sensitive.

Re: Converting SAS files to CSV files in SAS OnDemand for Academics

Kurt_Bremser — Thu, 07 Jan 2021 23:34:08 GMT

And how was dataset

phenbase.foodcodes_and_desc

created?

Re: Converting SAS files to CSV files in SAS OnDemand for Academics

fikel — Thu, 07 Jan 2021 23:39:22 GMT

It is the exact spelling, I copied the path from the properties of that folder and just doubled checked the spelling.

I was given the file from a research group as a .sas7bdat file and uploaded it to SAS studio.

Re: Converting SAS files to CSV files in SAS OnDemand for Academics

Kurt_Bremser — Thu, 07 Jan 2021 23:48:33 GMT

@fikel wrote:

It is the exact spelling, I copied the path from the properties of that folder and just doubled checked the spelling.

I was given the file from a research group as a .sas7bdat file and uploaded it to SAS studio.

Then (most probably) somewhere along the way one of the tools changed the spelling of the filename. The physical filename of a .sas7bdat file MUST be all lowercase.