topic Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv) in SAS Programming

How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Helle42 — Wed, 03 Oct 2018 12:11:10 GMT

Hi,

I try to export my sasdata to the filetype: CSV UTF-8 (comma separated) (*.csv).

This is my code:

filename exp 'myoutlib\Testdata.csv' encoding="UTF-8";

Proc export Data=sashelp.class outfile= exp DBMS=dlm replace; DELIMITER=";";

run;

Best regards, Helle

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Kurt_Bremser — Wed, 03 Oct 2018 11:14:45 GMT

filename output '/path/filename.csv' encoding="utf-8";

proc export data=mylib.mydata out=output dbms=csv;
run;

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

RW9 — Wed, 03 Oct 2018 11:20:23 GMT

CSV is not an Excel filetype. CSV = text file with comma separated variables, with possible header row. Just because Excel has a module which can read and parse CSV files, does not make them Excel files.

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Helle42 — Wed, 03 Oct 2018 12:31:16 GMT

Thanks

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Helle42 — Wed, 03 Oct 2018 11:32:07 GMT

Yes, correct, I just use EXCEL to check the filetype 🙂 Do you know how to export a SAS-file to the filetype: CSV UTF-8 (comma separated) (*.csv)?

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

RW9 — Wed, 03 Oct 2018 11:45:45 GMT

Forget Excel. Please show what code you are running to create the file (and use sashelp.class or something so that we can run it also).

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

VDD — Wed, 03 Oct 2018 11:53:01 GMT

have you tried using the export wizard? there is only one csv type to choice from during the exporting. You can save to export code created via the wizard and then edit that SAS export code to meet your needs.

CSV is not an Excel file nor an Excel dataset. Excel is not a database, while many managers use the tool in that manner it is not a database.

Know your data, know your operating system.

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Kurt_Bremser — Wed, 03 Oct 2018 11:55:54 GMT

@Helle42 wrote:

Thanks, but I have already tried that. Unfortunately, the file format is unicode.txt...

unicode.txt is not a file format, it's a filename. Filenames are irrelevant with respect to contents, I can easily save a SAS program as garbage.frumpyfurious, the content would still be a SAS program. It's just that programs like the Windows Explorer would have a hard time finding the right software to open it.

Therefore it is correct to save a CSV file with a .csv extension. And those correct extensions also work better with current Excel versions, as Excel will complain if you let it open a file with a wrong extension (eg a .xls extension for a XML file created by ods tagsets.excelxp).

On top of that, MS Office will assign the .csv extension to MS Excel, so double-clicking works (which it does not do for .txt, as that is assigned to the default Editor)

Re: How to export sasdata as a filetype: CSV UTF-8 (comma separated) (*.csv)

Kurt_Bremser — Wed, 03 Oct 2018 11:57:23 GMT

@VDD wrote:

Know your data, know your operating system.

AKA Maxim 3 and Maxim 15 😉