Hello everyone, In the SAS code below,the third one has a problem ,please advise. Thanks Mike %macro test(a); %put a: &a; %mend test; %test(a=aa); %test(a=njhl5IJK44t95y7u45n64); %test(a=njhl5u#$%^&*(IJK44t95y7u45n64);/*This one has a problem*/ ... View more

Hello everyone, Is that possible to close a data step window automatically by sas code? Thanks Mike    data _null_;     window test irow=35 icolumn=3 rows=10 columns=60        #3 "This window will be closed in 10 seconds automaticaly!"         ;     display test blank;     stop;   run; ... View more

Hello everyone, I want to know whether a macro  variable is a pure numeric or it include some characters, how to do this? For example:the macro  variable &notpure is NOT a pure numeric, it includes some characters('aqw').how to know this? %let notpure=123aqw4567; %let pure=12345; Thanks Mike ... View more

Hello everyone, I will get an error if I run the SAS code below. Please give me some advise. Thanks Mike %let time1=%sysfunc(time()); %put &time1;     data _null_;       wait=sleep(5);     run; %let time2=%sysfunc(time()); %put &time2; %let diff=%eval(&time2-&time1); *ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required; ... View more

Hello everyone, I have a time variable denotes 3662 seconds(3600+60+2), I wonder how to convert the 3662 seconds to 1hour and 1minutes and 2 second (01:01:02) format. Thanks Mike data have; second=3662; run; data need;/*this need modification*/ set have; time= input(second,hh:mm:ss.); run; ... View more

Hello everyone, I want to use an alternative method to simplify "%if (&a=1 or &a=2 or &a=3)" in macro  %test  in the SAS code below The %test macro works but the %test2 will cause error, the error parts caused by "%if &a in (1,2,3) %then....." Please advise. Thanks! Mike %macro test(a); %if (&a=1 or &a=2 or &a=3) %then %do;%put a=1/2/3;%end; %else %do;%put a=other;%end; %mend test; %test(a=2); %test(a=5); %macro test2(a); %if &a in (1,2,3) %then %do;%put a=1/2/3;%end; %else %do;%put a=other;%end; %mend test2; %test2(a=2); %test2(a=5); ... View more

Hello everyone, It seems in the SAS code below ,%goto statement doesn't work properly in a data step. please advise. Thanks!. Mike %macro testgoto(aaa); data one; x=symget('aaa'); put x=; if x='ok' then do; put ''x=ok; %goto exit; end; else do; put 'x ^=ok'; end; run; %put Before exit; %exit: %put after exit; %mend testgoto; %testgoto(aaa=ok); ... View more