proc transpose data = base out = transposed (rename=(Col1=Amount) where=(Amount ne .)) name=Period; by cust; run; this is the complete code
... View more
Thanks guys Then what about this.. proc transpose data = base out = transposed (rename=(Col1=Amount) where=(Amount ne .)) name=Period; shouldn't col2 be amount?? (In the transposed table Col1 is period and col2 is amount) and what is name = Period in this? Message was edited by: Abhinav Shori
... View more
Hello: Could someone please explain what Q: is? what is ne . ? thanks Much appreciated data transposed;set base; array Qtr{3} Q:; do i = 1 to 3;Period = cat('Qtr',i);Amount = Qtr{i} ;output;end; drop Q1:Q3; if Amount ne .; run;
... View more