Proc transpose

[TANMOY05]

The numbers like  1.000 , 22.00 etc. after transposing gets converted to 1 , 22 respectively. What should i do so that even after transposing, the numbers should come out as 1.000 ,22.00?

[ed_sas_member]

Hi @TANMOY05 

You need to apply a format for display.

n.p	Maximum "n" number of columns with "p" decimal points.

e.g. 4.3

[TANMOY05]

After transposing , the variables changes , therefore i can't apply the format

[ed_sas_member]

Hi @TANMOY05 

You need to apply the format after transposing to the new variables that have been created.

[TANMOY05]

No, that is creating problem, isn't there anyway of retaining the format while transposing only?

[ed_sas_member]

Please provide a sample of your data and the desired output...