DATA Step, Macro, Functions and more

rename

Reply
Contributor
Posts: 47

rename

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;

Super User
Posts: 13,498

Re: rename

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;
Super User
Super User
Posts: 9,599

Re: rename

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.

Ask a Question
Discussion stats
  • 2 replies
  • 72 views
  • 2 likes
  • 3 in conversation