I ran a proc contents with an out= to create a dataset that has all of the variables in a single column. From here I want to be able to perform a handful of transformations based on the middle position of said variables, they look like this: tml021success tml021datainform ...there are approx 100 of these vars, and I only want to transform into new vars those vars that have an '046' or '021' as their substr(name,4,3) the transformation is to make tml021success (1 thru 2=0) (3 thru 4 = 1) 5=sysmis into ra_tml021success. questions is: What proc do I use (or macro) to make the program loop through and identify those vars with a specific substring and recode them into newly created vars? Any help much appreciated. Novice sas user
... View more