topic Re: Proc Export - .txt being excluded from file name in SAS Programming

Proc Export - .txt being excluded from file name

Krysia24 — Fri, 22 May 2020 23:41:39 GMT

Hello SAS Users! I am using a proc export step to export a txt file; however, the output keeps exporting without the ".txt" file extension.

PROC EXPORT DATA= survey
OUTFILE= "\\fakepath\survey_&today.txt"
DBMS= tab
REPLACE;
PUTNAMES=YES;
RUN ;

Output file looks like this: "survey_22May2020" without the ".txt" extension. So I have to open it in Notepad and save as a .txt as a manual workaround... Thoughts?

Re: Proc Export - .txt being excluded from file name

r_behata — Sat, 23 May 2020 00:00:05 GMT

You need to have a '.' after the macro variable.

PROC EXPORT DATA= survey
OUTFILE= "\\fakepath\survey_&today..txt"
DBMS= tab
REPLACE;
PUTNAMES=YES;
RUN ;

Re: Proc Export - .txt being excluded from file name

ballardw — Sat, 23 May 2020 19:17:47 GMT

SAS uses a period to denote the end of a macro variable in code.

Example if you want to append an _ to the end of a macro variable you use something like:

%let base = abc;
%let new = &base._;

%put &new.

If you do not have the period the above example statement

%let new =&base_;

will generate an error because the macro variable Base is not terminated and you have told SAS to use a macro variable named base_.

So when you need to have a period as part of the resolved value after a macro variable you use two.

The same thing is needed when using any of The of the SAS syntax elements like Library.dataset. If both your library and data set names are stored in macro variables the proper reference would be &library..&dataset.

Re: Proc Export - .txt being excluded from file name

Krysia24 — Tue, 26 May 2020 20:00:39 GMT

Oh wow! Such a silly mistake on my part. Thank you!