https://communities.sas.com/t5/SAS-Procedures/How-to-do-make-report-data-line-up-properly-after-running-PROC/m-p/328063#M62452 <P>It sounds very possible, with two small steps.</P> <P>&nbsp;</P> <P>Get rid of the ID statement entirely.</P> <P>&nbsp;</P> <P>Add to the PROC TRANSPOSE statement: &nbsp;prefix=POS_</P> Fri, 27 Jan 2017 16:56:45 GMT Astounding 2017-01-27T16:56:45Z https://communities.sas.com/t5/SAS-Procedures/How-to-do-make-report-data-line-up-properly-after-running-PROC/m-p/328059#M62451 <P>Please see attached file for my problem description.</P><P>&nbsp;</P><P>Thank you very much for your help and advice!</P><P>&nbsp;</P><P>Paul Feng</P> Fri, 27 Jan 2017 16:29:53 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-do-make-report-data-line-up-properly-after-running-PROC/m-p/328059#M62451 h209571 2017-01-27T16:29:53Z https://communities.sas.com/t5/SAS-Procedures/How-to-do-make-report-data-line-up-properly-after-running-PROC/m-p/328063#M62452 <P>It sounds very possible, with two small steps.</P> <P>&nbsp;</P> <P>Get rid of the ID statement entirely.</P> <P>&nbsp;</P> <P>Add to the PROC TRANSPOSE statement: &nbsp;prefix=POS_</P> Fri, 27 Jan 2017 16:56:45 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-do-make-report-data-line-up-properly-after-running-PROC/m-p/328063#M62452 Astounding 2017-01-27T16:56:45Z