topic Re: SAS MACRO in SAS Programming

SAS MACRO

supersonic — Thu, 13 Jun 2013 07:03:56 GMT

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.

supersonic — Thu, 13 Jun 2013 07:18:47 GMT

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()

Tom — Thu, 13 Jun 2013 14:07:58 GMT

Looks like you have done it.

The basic process should be:

Figure out what code you want to run. Looks like you want to run PROC LOGISTIC.
Then identify the parts that you want to vary and turn them into macro variable references and use %LET statements above the code to set the values of the macro variables.
Once you have that working you can then convert the macro variables to parameters in a %MACRO statement.

Linlin — Thu, 13 Jun 2013 14:46:19 GMT

%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;