I neaad to crate a macro
with input a sas dataset with dependent binary variable ano one predicted probabilty variable.
output a dataset with the stats by deciles- no:of obs, no.of events, %obs, % events, event rate, lift, cumulative lift, avg predicted prbablity.
any1 help!!
%macro reg(dsname, DV, PV, selecttype );
proc logistic data=&dsname;
model &DV=&PV
/selection = &selecttype;
output out=&out ;
run;
print data=&out;
run;
%mend reg;
is this correct(atleast half part)
%reg()
Looks like you have done it.
The basic process should be:
%macro reg(dsname, DV, PV, selecttype );
proc logistic data=&dsname;
model &DV=&PV
/selection = &selecttype;
output out=out_&dsname ;
run;
title from dataset out_&dsname;
print data=out_&dsname;
run;
title;
%mend reg;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.