topic Re: rename in SAS Programming

rename

manya92 — Fri, 29 Jun 2018 14:32:51 GMT

how can i rename proc1 to code in this code ?

data derived._01_hcpcs_o (keep = enrolid proc1) ;
set dmk_scan.co_2011- dmk_scan.co_2014 dmk_scan.ro_2011-dmk_scan.ro_2014 ;
run;

Re: rename

ballardw — Fri, 29 Jun 2018 14:52:53 GMT

A number of ways. My choice would be:

data derived._01_hcpcs_o (keep = enrolid code) ;
   set dmk_scan.co_2011- dmk_scan.co_2014 dmk_scan.ro_2011-dmk_scan.ro_2014 ;
   rename proc1=code;
run;

Re: rename

RW9 — Fri, 29 Jun 2018 14:59:14 GMT

Or:

data derived._01_hcpcs_o (keep=enrolid code rename=(proc1=code)) ;
  set dmk_scan.co_2011 
      dmk_scan.co_2014 
      dmk_scan.ro_2011 
      dmk_scan.ro_2014;
run;

Not sure what the - was in the set statements ,is it for a list. Note the use of the code window, its the {i} above post area.