topic Re: Proc export if then in SAS Programming

Proc export if then

Coding4you — Sat, 19 Nov 2022 20:22:36 GMT

Hi All,

I was wondering is there a way to proc export a data if the data set name = this (as a pipe delimited txt file) else export as a CSV.

thank you!

Re: Proc export if then

SASKiwi — Sat, 19 Nov 2022 21:44:04 GMT

An easy way is to set a default parameter on a macro then no conditional logic is required:

%macro MyExport (dataset =
                ,filename =  
                ,DLM = ','
               );
proc export data = &dataset
            file = "\MyFolder\&filename"
            DLM = &DLM
;
run;
%mend MyExport;
%MyExport (dataset = MyCSV, filename = \Myfolder\MyCSV.csv);
%MyExport (dataset = MyPipe, filename = \Myfolder\MyPipe.csv, DLM = '|');

Re: Proc export if then

Kurt_Bremser — Sun, 20 Nov 2022 08:44:27 GMT

proc export
  data=&ds.
  dbms=dlm
  file="&outfile."
;
delimiter =
%if &ds. = A
%then %do;
","
%end;
%else %do;
"|"
%end;
;
run;

Re: Proc export if then

Coding4you — Sun, 20 Nov 2022 21:00:25 GMT

Thank you

Re: Proc export if then

Coding4you — Sun, 20 Nov 2022 21:00:56 GMT

Thank you

Re: Proc export if then

Coding4you — Mon, 16 Jan 2023 15:28:25 GMT

Hi Kurt,

Can I also ask is there a way to output the file in a txt file if its’s pipe delimited and csv if it’s in comma in that same piece of codes you provided below?

thank you,

kelvin.

Re: Proc export if then

Kurt_Bremser — Mon, 16 Jan 2023 15:42:23 GMT

Clearly define

the dataset names
the filenames
the delimiters
and the rules for combining the

Re: Proc export if then

SASKiwi — Mon, 16 Jan 2023 19:10:50 GMT

@Coding4you - Look at the macro code I posted.