Macro Parameters

RamKumar — Wed, 24 Dec 2014 10:13:36 GMT

When I ran this macro code in EG 5.1,encountered by error as follows.SAS is installed in UNIX server and the /data/PPM is directory where SAS resides.

Ideally I want this code to run, when file is not availble on sever and if there are files it should produce a dataset as mentioned in macros.

16 %let appfile =<None>;

18 %macro do_work(infilename);

19 %if "&infilename" ne "<NONE>" %then %do;

21 proc import datafile="/data/PPM/&infilename." out=appfile_cass dbms=CSV replace;

22 guessingrows=30000;

23 run;

25 data want;

26 set appfile_cass;

27 run;

29 %end;

30 %mend;

32 %do_work(&appfile);

MLOGIC(DO_WORK): Beginning execution.

MLOGIC(DO_WORK): Parameter INFILENAME has value <None>

MLOGIC(DO_WORK): %IF condition "&infilename" ne "<NONE>" is TRUE

MPRINT(DO_WORK): proc import datafile="/data/PPM/<None>" out=appfile_cass dbms=CSV replace;

MPRINT(DO_WORK): ADLM;

MPRINT(DO_WORK): guessingrows=30000;

MPRINT(DO_WORK): run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /data/PPM/<None>.

Can someone guide me to achieve this task?

Thanks for any help provided.

Re: Macro Parameters

CTorres — Wed, 24 Dec 2014 15:10:22 GMT

check the case of the parameter:

%let appfile =<None>;

%if "&infilename" ne "<NONE>" %then %do;

CTorres

topic Macro Parameters in SAS Programming

Macro Parameters

Re: Macro Parameters