topic Re: I want to convert a SAS file to a csv file. in New SAS User

I want to convert a SAS file to a csv file.

fuka-japan — Sun, 26 Sep 2021 03:57:10 GMT

Hello, this is Fuka-japan.

I need to convert the SAS file attached to this post to a csv file for use with R, but it says "You do not have permissions".

What should I do?

my code:

PROC EXPORT DATA= DEF.sas
OUTFILE= "/home/u59515621/元データ"
DBMS=CSV REPLACE;
RUN;

Re: I want to convert a SAS file to a csv file.

Kurt_Bremser — Sun, 26 Sep 2021 06:40:48 GMT

Never use special characters in path and file names, only use the 26 letters (upper and lower case), digits and underlines.
.sas files are program files, containing plain text, which can be opened with any text editor without exporting.
PROC EXPORT is used for exporting data from datasets or views, not for programs. Your PROC EXPORT would search for a dataset called SAS in library DEF.

Re: I want to convert a SAS file to a csv file.

Patrick — Sun, 26 Sep 2021 06:47:53 GMT

You can convert a SAS table (data) to a .csv using Proc Export.

What you're trying to use is a SAS program with Proc Export. That simply doesn't make any sense and just can't work.

Re: I want to convert a SAS file to a csv file.

Ksharp — Sun, 26 Sep 2021 12:47:40 GMT

You need to specify a LIBNAME for that sas dataset and ".CSV" for csv filename:

libname X "/home/u59515621/"
PROC EXPORT DATA= X.DEF
OUTFILE= "/home/u59515621/元データ.CSV"
DBMS=CSV REPLACE;
RUN;