I have an Excel File and i used art's code from last time. It worked for a different requirement, but the requirement has changed. I have put up a model of how the final data should look like. But it is only for one station. I am looking to do it for 7 stations, but this is the code i used last time. If it can be tweaked, please explain it to me. The final data will have 311 variable and 24 observations. Libname Thomas "C:\Users\tgeorge\Documents\Rulan_Nephrology"; %Macro Import(Sheet); PROC IMPORT OUT=STATION&Sheet DATAFILE= "C:\Users\tgeorge\Documents\Rulan_Nephrology\OSCE_NEPHRO_01_27_2012.xls" DBMS=EXCEL REPLACE; RANGE="'Station &Sheet.$'"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %Mend Import; %Import(1) %Import(2) %Import(3) %Import(4) %Import(5) %Import(6) %Import(7) data station1; set station1; rename Response_=Response; run; data station1final (keep=st1rot: st1can: st1stan: id_:); set station1; array st1rotation(9); array st1canmed(7); array st1standardized(6); retain st1rotation: st1canmed: st1standardized:; select (mod(_n_,22)); when (0) do; st1standardized(6)=response; output; end; when (1) do; call missing(of st1rotation(*)); call missing(of st1canmed(*)); call missing(of st1standardized(*)); st1rotation(1)=response; end; when (2,3,4,5,6,7,8,9) st1rotation(mod(_n_,22))=response; when (10,11,12,13,14,15,16) do; st1canmed(mod(_n_,22)-9)=response; end; otherwise st1standardized(mod(_n_,22)-16)=response; end; run; Thanks, Thomas
... View more