topic Put a record in a dataset if another dataset exists. in SAS Programming

Put a record in a dataset if another dataset exists.

scb — Mon, 13 Nov 2017 12:13:09 GMT

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.

Re: SAS query

Shmuel — Mon, 13 Nov 2017 11:44:26 GMT

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)

Re: Put a record in a dataset if another dataset exists.

RW9 — Mon, 13 Nov 2017 12:18:13 GMT

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.