Transpose array question

[art297]

Post the full proc transpose step that you ran. Given the output you got, I'd presume that it includes a BY statement.

[Luffy]

proc transpose data = base out = transposed

  (rename=(Col1=Amount) where=(Amount ne .)) name=Period;

by cust; run;

this is the complete code

[art297]

You would get the result I had posted if you delete the statement:

by cust;