How do I put the dsn info and message from below program into a dataset A? For example;
DSN Message
d:\test\test.xlsx TEST_B
%macro checkds(dsn);
%if %sysfunc(fileexist(&dsn)) %then %do;
%put TEST_A;
%end;
%else %do;
%put test_B;
%end;
%mend checkds;
%checkds(d:\test\test.xlsx)
Thanks.
Do you mean :
%macro checkds(dsn);
%if %sysfunc(fileexist(&dsn)) %then %do;
data test_a;
dsn = "&dsn";
output;
end;
%put TEST_A;
%end;
%else %do;
%put &dsn Does not exit;
%end;
%mend checkds;
%checkds(d:\test\test.xlsx)
So why have you jumped straight into macro? You can do this very simply in a datastep:
%let dsn=sashelp.bmt; data want; dsn="&dsn."; message=%sysfunc(exist(&dsn.)); run;
If you really need to then wrap the datastep in a macro call, but obviously only do this if needed. No point adding macro for no purpose.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.