@Reeza Sorry, but I'm not clear on the DATA step below.
data data_04b;
set data_04a;
varName = scan(_name_, 1, "_");
TimePoint = scan(_name_, 2, "_");
*fake data;
col1 = 25;
run;
What am I putting in the place of "varName"? One of the dependent variables?
What am I putting in the place of "TimePoint"?
Also, is this what you are referring to as the input code? If so, it does work for me.
data WORK.DATA_04;
infile datalines dsd truncover;
input Participant_ID:$3. Group:$1. Sex:$2. Age:BEST12. Efflux_V1:BEST12. Efflux_V2:BEST12. Efflux_V3:BEST12. ApoA1_V1:BEST12. ApoA1_V2:BEST12. ApoA1_V3:BEST12. ApoC1_V1:BEST12. ApoC1_V2:BEST12. ApoC1_V3:BEST12.;
format Age BEST12. Efflux_V1 BEST12. Efflux_V2 BEST12. Efflux_V3 BEST12. ApoA1_V1 BEST12. ApoA1_V2 BEST12. ApoA1_V3 BEST12. ApoC1_V1 BEST12. ApoC1_V2 BEST12. ApoC1_V3 BEST12.;
datalines;
1 A M 52 11.68 12.59 11.21 238.65 279.72 171.58 41.22 62.36 36.07
10 B M 68 9.58 9.18 10.78 215.79 214.9 253.98 47.33 38 50.52
11 A F 71 12.26 9.17 9.94 282.3 227.08 282.3 44.13 44.21 44.13
12 B M 71 5.88 9.45 10.55 173.07 230.49 174.09 47.8 51.28 37.81
13 A F 71 13.17 12.69 11.33 259.03 265.83 255.03 61.34 67.46 73.5
14 B M 54 10.51 7.96 8.28 211.39 192.76 192.17 41.14 36.83 34.86
15 A F 66 7.34 6.74 8.69 240.58 160.97 205.72 35.8 25.89 44.28
16 B F 69 11.07 13.44 10.08 236.45 242.66 214.03 54.07 55.34 37.61
17 A F 58 8.1 7.62 8.03 188.51 159.8 164.22 36.04 32.35 30.78
18 B F 63 10.14 10.06 10.78 229.05 252.06 228.63 57.49 63.17 50.44
;;;;
Run;
Finally, is this the desired format of the data set?
Thank you.
... View more