Hi I'm trying to use an array to transform my dataset and character variables. Currently my data looks has the following column titles: Drug Name. Reason. Onset. End. Status. This data has approximately 13,000 rows and I want it to look like this Drug Name. Reason1. Onset1. End1. Status1. Reason2. Onset2. End2. Status3. Reason3. Onset3. End3. Status3. This way the data will be long and each drug may have a different row length. Currently, my code is as follows: data want; set want1; by Name; retain reas1 reas2 reas3 reas4 reas5 reas6 reas7 reas8 reas9 reas10 on1 on2 on3 on4 on5 on6 on7 on8 on9 on10 endd1 endd2 endd3 endd4 endd5 endd6 endd7 endd8 endd9 endd10 stat1 stat2 stat3 stat4 stat5 stat6 stat7 stat8 stat9 stat10; array reas(10) reas1 reas2 reas3 reas4 reas5 reas6 reas7 reas8 reas9 reas10; array on(10) on1 on2 on3 on4 on5 on6 on7 on8 on9 on10; array endd(10) endd1 endd2 endd3 endd4 endd5 endd6 endd7 endd8 endd9 endd10; array stat(10) stat1 stat2 stat3 stat4 stat5 stat6 stat7 stat8 stat9 stat100; if first.name then count=1; else count+1; do i=1 to 10; if first.name then do; reas(i)='.'; on(i)='.'; endd(i)='.'; stat(i)='.'; end; end; reas(count)=Reason; on(count)=Onset; endd(count)=End; stat(count)=Status; if last.name; run; However, this isn't working for me. Any suggestions or feedback would be really appreciated!!
... View more