topic Re: Export data set via data step in SAS Programming

Export data set via data step

Ronein — Tue, 26 Sep 2023 09:41:21 GMT

Hello

I want to export sas data set into TXT file.

I want to use DATA STEP way .

In example 2 I get error

30         file &file_extract dsd dbms=tab;
                                  ____
                                  23
ERROR 23-2: Invalid option name DBMS.

What is the way to solve the error?

I also want to add column headers in example2? What is the way to do it?

data junk;
Set sashelp.class;
if sex='F' then age=.;
label
Name='Client_Name'
Sex='Gender'
Age='Age'
Height='Height'
Weight='Weight'
;
run;

/***Example1---Working well****/
%let file_extract='/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/Example1.txt';
%put &file_extract;
data _null_;
file &file_extract dsd dlm = ';';
set junk;
put (_all_) (~);
run;

/***Example2---Error****/
%let file_extract='/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/Example2.txt';
%put &file_extract;
data _null_;
file &file_extract dsd dbms=tab;
set junk;
put (_all_) (~);
run;

Re: Export data set via data step

andreas_lds — Tue, 26 Sep 2023 10:34:38 GMT

Maybe you should start following Maxim 1

This will save you time.

Re: Export data set via data step

Tom — Tue, 26 Sep 2023 12:27:32 GMT

https://en.wikipedia.org/wiki/One_of_These_Things_(Is_Not_Like_the_Others)

file &file_extract dsd dlm = ';';
file &file_extract dsd dbms=tab;
file &file_extract dsd dlm='09'x;

Re: Export data set via data step

Kurt_Bremser — Tue, 26 Sep 2023 12:42:30 GMT

Maxim 1.

DBMS= is not a valid option for the FILE Statement.

It is an option available in the IMPORT and EXPORT procedures.

To create a tab-delimited file, use

%let file_extract=/usr/local/SAS/SASUsers/LabRet/Adhoc/creditCards/Example2.txt;
file "&file_extract." dsd dlm="09"x;

To add a header line, create a string with CATX and PUT it at the beginning:

if _n_ = 1
then do;
  length header $500; * make it big enough;
  header = catx("09"x,"name1","name2","name3"); * add variable names or labels as needed;
  put header;
end;
put
  name1
  name2
  name3
; * add variables as needed;
run;

Re: Export data set via data step

Kurt_Bremser — Tue, 26 Sep 2023 12:46:33 GMT

PS you can use PROC EXPORT with DBMS=TAB and then read the log to see how the procedure creates a tab-delimited file with the DATA step.