data WORK.ALL;
infile datalines dsd truncover;
input Subject:$8. Visit:$15. Image:$8. Site:$15. Area:$7.;
datalines;
1102 Visit1 233B 14 NA
1102 Visit2 435A 14 NA
1103 Visit1 463A 14 NA
1103 Visit1 345B 14 NA
1104 Visit1 345A 14 COL
1104 Visit1 345B 14 NA
1106 Visit1 567A 14 IL
1106 Visit1 866A 14 COL
1107 Visit1 461A 14 IL
1107 Visit2 356A 14 NA
;;;;
NOTE: There were 10 observations read from the data set WORK.ALL.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
I think I over complicated this in everyone's mind. I only want to assign LOCATION based on the AREA variable. So for Subject 1102, the first AREA is "NA", so this would be Location=1. Then the same subject has another record where the AREA is still NA, so this would still be Location=1 (because they are the same area, therefore same location) For Subject 1107, they contain two different AREAS (IL and NA), I would want the first AREA to be assigned Location=1 and the second AREA to be Location=2, because they are different. I have already sorted based on SUBJECT and VISIT, so the AREA variable is already in the order that I want it, now I just need to assign Location 1 and 2, so I can differentiate the Image IDs later. Does that make more sense?
... View more