topic Re: Proc Export adding extra quotation marks in SAS Procedures

Proc Export adding extra quotation marks

lsirakos — Fri, 10 Aug 2012 17:12:48 GMT

I am trying to export a SAS dataset to a text file but when I use proc export it is adding extra quotation marks. I need the output file to look just like the dataset. An example of what the dataset looks like and what the text file looks like after it has been exported are as follows:

Dataset example (each line is a different observation):

"Text stuff

Other text;

More text

Some more text"

Output file example after using proc export:

"""Text stuff"

Other text stuff;

More text

"Some more text"""

Example of proc export code:

proc export data=test dbms=DLM outfile="textfile.txt" replace;

delimiter='0a'x;

run;

As you can see it inserts extra quotation marks at the beginning on line 1, adds a quotation mark at the end of line 1, adds a quotation mark at the beginning of line 4, and extra quotation marks at the end of line 4.

Is there anyway to prevent this?

Re: Proc Export adding extra quotation marks

lsirakos — Fri, 10 Aug 2012 17:17:23 GMT

Nevermind, found a way to get this to work without using proc export. Solution is as follows:

libname ssd '[drive]:\[your_folder]\proj\' ;
data _null_ ;         /* No SAS data set is created */
    set ssd.income ;
    FILE '[drive]:\[your_folder]\rawfile.txt' ;    /* Output Text File */
    PUT var1 ;
run ;

via:

http://www.ciser.cornell.edu/FAQ/SAS/write_delimited_file.shtml

Re: Proc Export adding extra quotation marks

art297 — Fri, 10 Aug 2012 17:41:14 GMT

However, if you want to take advantage of proc export's obtaining and outputting the variable name(s) on the first row, it is easy to do.

After running proc export, press function key F4.

That will retrieve the statement that was submitted. If your variable was called text, there will be a line towards to bottom of the program that shows:

put text $;

if you change that to, say:

put text char30.;

you will get the desired output file.