BookmarkSubscribeRSS Feed
manya92
Fluorite | Level 6

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;

2 REPLIES 2
ballardw
Super User

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;
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 952 views
  • 2 likes
  • 3 in conversation