%SYSFUNC(INTCK("Second",&t1,&t2) generates error but INTCK in a data step works fine.    %let t1=%SYSFUNC(DateTime()); %let t2=%SYSFUNC(DateTime()); %let t=%SYSFUNC(INTCK("Second",&t1,&t2)); WARNING: An argument to the function INTCK referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value.   %put &=t1 &=t2 &=t; LOG: /*T1=1963997617.86803 T2=1963999438.99399 T=.*/   data a; t=INTCK("Second",&t1,&t2); run;   /* dataset a */ /*t                */ /*1821        */         ... View more

This simple program does not produce Pearson dataset:  data a;   a=1; b=3; output;   a=4; b=5; output; run; proc SQL noprint; select MAX(A) into :a trimmed from a; %put &=a; ODS output PearsonCorr=Pearson; proc CORR data=a;   var a;   with b; run; WARNING: Output 'PearsonCorr' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used.   The reason for this is absence of quit; in  proc SQL code.  Using  proc SQL noprint; select MAX(A) into :a trimmed from a; quit; %put &=a; produces the expected output: NOTE: The data set WORK.PEARSON has 1 observations and 3 variables. I've noticed that some seasoned programmers do not put quit; in this type proc SQL code. This trick works fine in most cases but not every time. Or may be I'm wrong?  ... View more

Suppose we have a case with low event rate, say 1%. In 1:1 oversample we select all events 1% and 1% of non-events. Then there are two important questions: How can we guarantee that this 1% of non-events is a representative sample of the rest 98% of non-events? What procedures can be used to test that distributions of predictors are the same in 1% and 98% non-event samples? ... View more

I have the following code that works fine. What I need is to replace commas in a=A.B,C string with asterisks to get s="A" "B" "C" string. The data step version of the code works fine: %let a=A,B,C; data a; s='"'||TRANSTRN("&a",",",'" "')||'"'; run; /* dataset a:  */ /* s           */ /*"A" "B" "C"  */   However, using %SYSFUNC(TRANSTR(...)) fails or produces wrong result:   %let s=%SYSFUNC(TRANSTRN(&a,",",'" "')); %put s=&s; /*ERROR: The function TRANSTRN referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments.*/ %let s=%SYSFUNC(TRANSTRN("&a",",",'" "')); %put s=&s; /*s="A,B,C"*/ %let s=%QSYSFUNC(TRANSTRN(&a,",",'" "')); %put s=&s; /*ERROR: The function TRANSTRN referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments.*/ Any help? ... View more