topic Re: export data to txt in SAS Programming

export data to txt

superbug — Mon, 19 Apr 2021 14:33:59 GMT

I want to export the resulted data to be txt, as picture below each variable takes 2 columns, but I want each variable takes 1 column. How should I modify my code? Thank you!

proc export data=try outfile='....\data for simultaneous calibration.txt'
dbms=dlm replace; delimiter=' '; putnames=NO;
run;

Re: export data to txt

Tom — Mon, 19 Apr 2021 14:44:37 GMT

There is no need to use "export" to create a text file. Just write the file directly. Then you can have full control over how the values are written.

So if your data has two identifiers and then a series of fifty one digit numbers your data step might look like:

data _null_;
  set try ;
  file '....\data for simultaneous calibration.txt' ;
  put id1 id2 (var1-var50) (1.);
run;

Re: export data to txt

superbug — Mon, 19 Apr 2021 15:04:39 GMT

@Tom

Thanks much for your response!

Part of my data looks like following before being exported to .txt

as you suggested, I used the following code (a little change of var names as in bold)

data _null_;
set try ;
file '...\data for simultaneous calibration_new.txt' ;
put id1 id2 (JAL000001-JAL000177) (1.);
run;

But the .txt file I got is like the following, which is not desired format,

the highlighted part in the picture above should stay together like following

any other suggestion, please.

Re: export data to txt

Tom — Mon, 19 Apr 2021 15:29:50 GMT

We cannot code to photographs. At a minmum provide TEXT of the desired record. But in reality provide the detail specification of which variables should appear in which column of the output line.

Just learn how to use formats with PUT statement. Or even column mode output with PUT statement.

Re: export data to txt

ballardw — Mon, 19 Apr 2021 15:43:54 GMT

Unfortunately PICTURES do not show "columns" worth beans.

Since you have a blank as a delimiter there is a space between values. If you do not want a space between each value then you are not creating delimited data and as such you don't provide delimiters or use DBMS=dlm.

Re: export data to txt

superbug — Mon, 19 Apr 2021 19:58:53 GMT

@Tom @ballardw

Thanks much for your suggestions!

I very much appreciate your help!