Box Cox transformation for multiple variables

jbencina — Wed, 10 Aug 2016 18:32:59 GMT

I'm new to the SAS world and have been trying to figure this problem out. I have a list of variables in my data tables that could change (# included, or the names). I've been trying to make a dynamic code that runs the following code for any number of Variables (A, B, C, etc.)

   proc transreg data=WORK.'MY_DATA'n;
      model boxcox(Var_A Var_B ...) = identity(DEP_VAR);
   run;

I've been researching and found something along these lines. But I can't seem to figure out how to take the variable output below and use it in the function above. Any help would be appreciated!

PROC CONTENTS DATA = WORK.'MY_DATA'n
OUT=VAR_NAMES(KEEP = NAME) NOPRINT;
RUN; 

DATA PARSE;
SET VAR_NAMES;
WHERE (NAME NOT IN ('DEP_VAR','ID_VAR'));
RUN;

Re: Box Cox transformation for multiple variables

Reeza — Wed, 10 Aug 2016 19:35:30 GMT

You need to create a macro variable and then pass that to the code.

http://support.sas.com/documentation/cdl/en/mcrolref/67912/HTML/default/viewer.htm#n1y2jszlvs4hugn14nooftfrxhp3.htm

PROC CONTENTS DATA = WORK.'MY_DATA'n
OUT=VAR_NAMES(KEEP = NAME) NOPRINT;
RUN; 


Proc SQL;
select name into :var_list separated  by " "
from var_names
WHERE (NAME NOT IN ('DEP_VAR','ID_VAR'));
quit;

*Display the variable list in the log for verification;
%put &var_list;

Then apply that to your data:

   proc transreg data=WORK.'MY_DATA'n;
      model boxcox( &var_list. ) = identity(DEP_VAR);
   run;

topic Box Cox transformation for multiple variables in SAS Enterprise Guide

Box Cox transformation for multiple variables

Re: Box Cox transformation for multiple variables