Proc export if then

[Coding4you]

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!

[SASKiwi]

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 = '|');

[Coding4you]

Thank you

[Kurt_Bremser]

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

[Coding4you]

Thank you

[Coding4you]

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.

[Kurt_Bremser]

Clearly define

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

[SASKiwi]

@Coding4you  - Look at the macro code I posted.