Hi. I have a dataset (dataset1) as follow (variable name and age). Name Age Mike_1 5.0 Sar_2 6.5 Ste_3 8.0 I want to create a dataset that would take values from age as the following:” from above dataset and modify my another dataset (dataset2): Data dataset2_mod; Set dataset2; If var_name=1 (if variable name’s value has 1 as in Mike_1) then val=5.0; If var_name=2 (sar_2 has 2) then val=6.5; Etc. Run; I want to modify dataset2 by sas macro parameter that would have …_1, …_2 first identify those (always would have 9 names from 1 to 9) but important the age variables’ values would change so that those should be a macro parameters. How can I do that? Thank you. ... View more

I have multiple variables as var1, var2,…var78, num1,num2 etc. They all have labels. I want to change the labels by adding 3 strings : for example, for all variables with start var then add VAR at the beginning of the labels if num1 etc all variables with start num then add NUM at the beginning of the all labels. How can I do that? Thank you. ... View more