Hi,   I think it can be solved by using proc transpose but not sure. Any ideas are welcome. Many thanks!   Now I have from CSV, Class Student Phy Che Phy Che Phy Che A 1 95 95         A 2     85 90     A 3         80 80 B 1 88 86         B 2     95 100       And what I want is, Class Student Phy Che A 1 95 95 A 2 85 90 A 3 80 80 B 1 88 86 B 2 95 100   I guess first of all, we need to deal with the same-name column issue.   Thanks again for any suggestion! ... View more

Hi,   I get a code and want to turn it into macro. data Apple_price(drop=Age); length key $25 Apple_price_c $10 Factor_c $10; set in.Apple_price; key = compress('Case'||ID||'_'||Group||'_'||put(Unit,z2.),,'kadp'); Apple_price_c = 'Apple_price'; Factor_c = 'Factor'; run; Since I've pear and peach data as well. But my code seems wrong. Could anybody can give some suggestions? %macro fruit(covlist); %if &covlist. ^= none %then %do; %let y = 1; %let cov = %scan(&covlist., &y., ' '); %do %until(&cov. eq %nrstr( )); data &cov._price(drop=Age); length key $25 &cov._price_c $10 Factor_c $10; set in.Apple_price; key = %compress('Case'||ID||'_'||Group||'_'||%put(Unit,z2.),,'kadp'); &cov._price_c = %compress("&cov."||'_price',,'kadp'); Factor_c = 'Factor'; run; %let y = %eval(&y. + 1); %let cov = %scan(&covlist., &y., ' '); %end; %end; %mend fruit; %fruit(covlist = apple pear peach) Many Thanks! ... View more

Hi,   It's kind of Transpose question.   Now I have data, ID UnitNum OwnCar1 OwnCar2 OwnCar3 1 1 2 1 3 1 2 2 1 3 1 3 2 1 3 2 1 2 4   2 3 2 4     I wonder how can I transpose to, ID UnitNum OwnCar 1 1 2 1 2 1 1 3 3 2 1 2 2 3 4 Many thanks! ... View more