https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615268#M179955 After transposing , the variables changes , therefore i can't apply the format Mon, 06 Jan 2020 09:17:13 GMT TANMOY05 2020-01-06T09:17:13Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615266#M179953 <P>The numbers like&nbsp; 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?</P> Mon, 06 Jan 2020 09:11:38 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615266#M179953 TANMOY05 2020-01-06T09:11:38Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615267#M179954 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/304794">@TANMOY05</a>&nbsp;</P> <P>You need to apply a format for display.</P> <TABLE class="table table-bordered"> <TBODY> <TR> <TD class="ts"><STRONG>n.p</STRONG></TD> <TD> <P>Maximum "n" number of columns with "p" decimal points.</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>e.g. 4.3</P> Mon, 06 Jan 2020 09:13:43 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615267#M179954 ed_sas_member 2020-01-06T09:13:43Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615268#M179955 After transposing , the variables changes , therefore i can't apply the format Mon, 06 Jan 2020 09:17:13 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615268#M179955 TANMOY05 2020-01-06T09:17:13Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615269#M179956 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/304794">@TANMOY05</a>&nbsp;</P> <P>You need to apply the format after transposing to the new variables that have been created.</P> Mon, 06 Jan 2020 09:18:21 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615269#M179956 ed_sas_member 2020-01-06T09:18:21Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615270#M179957 No, that is creating problem, isn't there anyway of retaining the format while transposing only? Mon, 06 Jan 2020 09:26:08 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615270#M179957 TANMOY05 2020-01-06T09:26:08Z https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615271#M179958 <P>Please provide a sample of your data and the desired output...</P> Mon, 06 Jan 2020 09:27:14 GMT https://communities.sas.com/t5/SAS-Programming/Proc-transpose/m-p/615271#M179958 ed_sas_member 2020-01-06T09:27:14Z