Dear all, Here's the code. 1. proc logistic data=slide.sb_vm_training outmodel=slide.model; CLASS N2  N3  N4  N5  N6  N7  N10  N11  N12  N13 /param=ref; model dv = Prin1 Prin2 Prin3  factor1 factor2 factor3 factor4 factor5 factor6 factor7 factor8 /selection=stepwise ; run; 2. proc logistic data=slide.sb_vm_training outmodel=slide.model; CLASS N2  N3  N4  N5  N6  N7  N10  N11  N12  N13 /param=effect; model dv = Prin1 Prin2 Prin3  factor1 factor2 factor3 factor4 factor5 factor6 factor7 factor8 /selection=stepwise ; run; 3. proc logistic data=slide.sb_vm_training outmodel=slide.model; CLASS N2  N3  N4  N5  N6  N7  N10  N11  N12  N13 /param=ref; model dv = Prin1 Prin2 Prin3  factor1 factor2 factor3 factor4 factor5 factor6 factor7 factor8 /selection=stepwise ; unit Prin1=Prin1  =50000 Prin2  =50000 Prin3  =50000 run; I tried the 3 different coding as above, but all failed to get a N variable into the model Where variables with prefix "N" are ordinal variables like nationality,sex,most of them with the scope (0,9) Prin1-prin3 are variables extracted from principal analysis,the scope for this variable is between (-Million,+Million) factor1-factor8 are variables extracted from factor analysis,the scope for this variable is between (-2,+2) both of them are summary of continous variables in some way, dv is the dependent variable , with 1 shows the customer will leave, and 0 shows he will stay. The question is when using stepwise, only prin1 and some factor variables remains, not even one N variable remains. while judge from the real business, at least nationality is very useful to determine whether a customer will leave, WHY not even one N variable remains? what's wrong with my coding for Proc Logistic? Thanks in Advance. Dawn ... View more

Hi,can any one help to explain the following code within a macro; %let Cond=; %do i=1 %to &Nvars; *Nvars means how many variables within a dataset;       %if (&i>1) %then %let Cond=&Cond and ;        %if &&V&i=0 %then %do;           %if &&T&i=C %then   *Ti helps to identify the variable's type, c or n;               %let Cond=&Cond &&Var&i = '';   /* String C */           %if &&T&i=N %then                   %let Cond=&Cond &&Var&i=. ;     /* Numeric N */                          %end;        %else %do;           %if &&T&i=C %then                 %let Cond=&Cond &&Var&i ne '' ;  /* String C */           %if &&T&i=N %then                   %let Cond=&Cond &&Var&i ne . ;   /* Numeric N */              %end;      %end; Pls give a hand. You need not explain sentance by sentance, what I don't understand is the changing of Cond, what happened to the variable cond(condition)? what's the value for cond after %let Cond=&Cond &&Var&i ne '' ;(say) Very thanks. Dawn ... View more

%macro makeVarMap(dsact); proc transpose data=&dsform out=tempform  (keep =_name_); var c1--no; run; %mend; %macro makeVarMap(thesis.sb_v_12); doesn't work while following codes works proc transpose data=thesis.sb_v_12 out=tempform  (keep =_name_); var c1--no; run; thesis.sb_v_12 has several variables like c1,c2,c3,n1,n2,n3 and end with no. and the error codes seems point to the irregular format of dataset name :thesis.sb_v_12,but this kind of naming method works with my other macros. Can anyone give a thought? Thanks. ... View more

%let macrodir=\\133.3.3.3\a\a\DataPre\Macro; %include "&macrodir\allmacros.sas"; I wrote the above ,trying to include all macros under the directory, but failed. How to modifiy those code? Thanks. ... View more

I have a variable called birthday in datatime format like "12NOV1935:00:00:00", How can I just pick out month and day and add year 2012 to form "12NOV2012:00:00:00" (in sas datetime format) or ""12NOV2012" (in sas date format)? Thanks. ... View more