thank you ... View more

Thank you. I was under impression that a function should be macro function within macro. Now I understand where to use macro function. ... View more

2 options mlogic mprint symbolgen; 3 data sample_name; 4 input id name $; 5 cards ; NOTE: The data set WORK.SAMPLE_NAME has 3 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 9 ; 10 run; 11 12 13 %macro mcr_test(dst_term); 14 /*%local nm;*/ 15 proc sql; 16 select DISTINCT name 17 into :nm 18 from sample_name 19 where %upcase(name)=%upcase("&dst_term"); 20 quit; 21 %put &nm; 22 data _null_; 23 %if &dst_term=&nm %then %do; 24 %put "step1"; 25 %end; 26 %else %do; 27 %put "step2"; 28 %end; 29 run; 30 %mend; 31 %mcr_test(DAVID); MLOGIC(MCR_TEST): Beginning execution. MLOGIC(MCR_TEST): Parameter DST_TERM has value DAVID MPRINT(MCR_TEST): proc sql; SYMBOLGEN: Macro variable DST_TERM resolves to DAVID MPRINT(MCR_TEST): select DISTINCT name into :nm from sample_name where NAME="DAVID"; NOTE: Writing HTML Body file: sashtml.htm MPRINT(MCR_TEST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.71 seconds cpu time 0.46 seconds MLOGIC(MCR_TEST): %PUT &nm SYMBOLGEN: Macro variable NM resolves to DAVID DAVID MPRINT(MCR_TEST): data _null_; SYMBOLGEN: Macro variable DST_TERM resolves to DAVID SYMBOLGEN: Macro variable NM resolves to DAVID MLOGIC(MCR_TEST): %IF condition &dst_term=&nm is TRUE MLOGIC(MCR_TEST): %PUT "step1" "step1" MPRINT(MCR_TEST): run; NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds MLOGIC(MCR_TEST): Ending execution. 32 %mcr_test(ANDY); MLOGIC(MCR_TEST): Beginning execution. MLOGIC(MCR_TEST): Parameter DST_TERM has value ANDY MPRINT(MCR_TEST): proc sql; SYMBOLGEN: Macro variable DST_TERM resolves to ANDY MPRINT(MCR_TEST): select DISTINCT name into :nm from sample_name where NAME="ANDY"; NOTE: No rows were selected. MPRINT(MCR_TEST): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MLOGIC(MCR_TEST): %PUT &nm WARNING: Apparent symbolic reference NM not resolved. &nm MPRINT(MCR_TEST): data _null_; SYMBOLGEN: Macro variable DST_TERM resolves to ANDY WARNING: Apparent symbolic reference NM not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &dst_term=&nm ERROR: The macro MCR_TEST will stop executing. MLOGIC(MCR_TEST): Ending execution. hi Paige Miller,     log inserted. ... View more

Thank you. It works. I never knew there is a informat like trailsgn. ... View more

The -sysparm in you question should work,  you can pass multiple parameters in -sysparm option and parse it using scan function in sas file. To redirect your log and lst result to particular file you can use -log and -print options.   Modifying your code as below: sas /<path>/<program>.sas -sysparm "value1,value2" -log anypath/anyname.log -print anypath/anyname.lst    in your code you can parse -sysparm using scan function.   data _null; _value1=scan(sysparm(),1,', '); _value2=scan(sysparm(),2,',');  call symput("value1", "_value1");  call symput("value2", "_value2"); run;   ... View more