I have generated files ref1_1 and ref1_2 where the first number refers to the subject while the second is the repetition. An example ref file is below and will have multiple columns depending upon the number of reps. The posted has 3 since &j=3. What I would like to do is keep an1, Col&j, and treat where the column that is retained matches the &j (eg, for AREF1._1 an1,col1, and treat) whereas for AREF1._2 it would be an1,col2, and treat. I need to know how to create a macrovariable out of the columns so that the desired one can be put into the keep statement.
Example ref file.
an1
COL1
COL2
COL3
Treat
ka1
4.4E+08
0.649438
-0.22775
BREF
ka2
2E+09
1.004508
-0.17851
BREF
cl
8.35E+08
7.486796
6.484179
BREF
vf
5.19E+08
8.70274
7.372281
BREF
D1
92912286
2.528415
0.134371
BREF
lag
1.88E+08
1.673499
1.299389
BREF
logit
-1883756
0.333883
-0.71054
BREF
%MACRO bootR;
%do i=1% to 34;
%DO j=1% to 3;
DATA AREF&i._&j;
set ref&i._&j;
Treat='BREF';
run;
DATA BTES&i._&j;
set TES&i._&j;
Treat='ATES';
run;
PROC EXPORT DATA=aref1_1
OUTFILE= '/folders/myfolders/IMLSUBGEN/ref1_1.csv'
DBMS=CSV REPLACE;
PROC EXPORT DATA=aref2_2
OUTFILE= '/folders/myfolders/IMLSUBGEN/ref2_2.csv'
DBMS=CSV REPLACE;
RUN;
%end;
%end;
%mend bootR;
%bootR;
run;
... View more