topic Re: If Then Run PROC in SAS Programming

If Then Run PROC

Ujjawal — Thu, 28 May 2015 19:04:39 GMT

I want PROC REG to be run if a condition satisfies. For example, I have a table that stores variable names and variance (VIF). If any variable has variance value greater than 5, i want PROC REG to be run on different dataset (input data set), else exit (out of the macro).

Variable	Variance
A	3.75
B	4.5
C	10
D	11
E	13

Re: If Then Run PROC

ballardw — Thu, 28 May 2015 20:54:46 GMT

Since you mention exit a macro then we assume all of this is within a defined macro.

First get a flag value that says you have a variance in the range you are concerned with:

proc sql noprint;

select (max(variance)>5) into : varflag

from have;

quit;

/*The macro variable varflag will be 1 if true. OR you could select the maximum value but you'll need to play some games with %sysevalf in comparisons and this is a tad cleaner;*/

%if &varflag =1 %then %goto leave; /* NOTE there is no % for leave here but is used for the line label to skip to*/

<the code to execute when you aren't going to leave the macro>;

%leave: <any code you might want to execute before leaving the macro could go here such as

cleaning up data sets>

%mend;

Re: If Then Run PROC

Ujjawal — Thu, 28 May 2015 21:23:09 GMT

Thanks a ton. Very Helpful!

Re: If Then Run PROC

Ron_MacroMaven — Fri, 29 May 2015 22:17:48 GMT