Hi,
I'm having a little bit of problem with some mapping ,and I'm hoping someone can help me.
Below are 2 example data sets. what I'd like to do is select columns from data2 that appear as datalines for the variable var in data1 (ie var0, var1, var2) from data2, deleting the rest (in this case var44). So far I've been playing around with Symput, but I can't seem to figure anything out.
Thanks,
Jason
data data1;
length var $ 32;
length var_SB $ 32;
input
var $ var_SB $
;
FORMAT var $32.;
INFORMAT var $32.;
FORMAT var_SB $32.;
INFORMAT var_SB $32.;
datalines;
var0 asfasfg
var1 var1_SB
var2 var2_SB
;
run;
data data2;
input
var0 var1 var2 var44;
datalines;
1 2 3 4
2 4 6 8
1 1 1 1
2 3 4 3
1 1 1 1
;
run;