Hello, I have two datasets - data1 and data2. Data1 has 10000 observations and data2 has 50000. Both of them consist of two variables - ID and score. Both of the datasets have unique IDs, no duplicates. I want to match IDs from data1 with IDs from data2, in 1:2 ratio, and such that the difference between the two scores is less than 0.01. Could you please suggest an efficient approach. Merging or proc sql is unfortunately not helping much. Thanks! ... View more

Hello, The data I have is as follows: ID Score Grade A 9 A A 5 B B 8 A B 3 C I want to transpose it as follows: ID Score1 Score2 Grade1 Grade2 A 9 5 A B B 8 3 A C However, I'm not able to transpose two variables at the same time -- prefix doesn't take two variables. I'm transposing one variable at a time and then merging the two datasets. Could this be done in one step? Thanks, P ... View more

Hello, The data I have is as follows: ID Score1 Score2 Score3 A 5 2 8 B 4 3 7 C 9 6 1 I want to convert it as follows: ID Score A 5 B 4 C 9 A 2 B 3 C 6 A 8 B 7 C 1 The way I'm doing it pretty crude: data want;      set have (keep = id score1 rename=(score1=score)           have (keep = id score2 rename=(score2=score)           have (keep = id score3 rename=(score3=score); run; This could be tedious with say 50 variables. Is there any sophisticated way? Can proc transpose handle this? Thanks, P ... View more

Hello, Following is the typical call symput procedure: data a2; set a1; call symput("mvar",xyz); run; I want to do the following: %macro abcd (data=,mvar=); data a2; set &data; call symput("&mvar",xyz) %mend; %abcd (data=a0, mvar=mvar0) %abcd (data=a1, mvar=mvar1); However, I'm getting error. Can I assign macro variable name within call symput through a local macro? Is there any efficient way to do this? Thanks, P ... View more