https://communities.sas.com/t5/SAS-Enterprise-Guide/Tabulate-large-quantity-of-data/m-p/1040#M303 Hi, i am newbies to SAS software. I have a question on whether how to do the dataset procedures for below?<BR /> <BR /> A/c month year amt<BR /> 123 1 2006 100<BR /> 123 2 2006 100 <BR /> 123 3 2006 100<BR /> 123 4 2006 100<BR /> 456 2 2006 100<BR /> 456 5 2006 100<BR /> <BR /> How to tabulate the data above into such a way as below?<BR /> <BR /> Year 2006<BR /> A/c 1 2 3 4 5 (Month)<BR /> 123 100 100 100 100<BR /> 456 100 100 Sat, 15 Jul 2006 15:13:57 GMT deleted_user 2006-07-15T15:13:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Tabulate-large-quantity-of-data/m-p/1040#M303 Hi, i am newbies to SAS software. I have a question on whether how to do the dataset procedures for below?<BR /> <BR /> A/c month year amt<BR /> 123 1 2006 100<BR /> 123 2 2006 100 <BR /> 123 3 2006 100<BR /> 123 4 2006 100<BR /> 456 2 2006 100<BR /> 456 5 2006 100<BR /> <BR /> How to tabulate the data above into such a way as below?<BR /> <BR /> Year 2006<BR /> A/c 1 2 3 4 5 (Month)<BR /> 123 100 100 100 100<BR /> 456 100 100 Sat, 15 Jul 2006 15:13:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Tabulate-large-quantity-of-data/m-p/1040#M303 deleted_user 2006-07-15T15:13:57Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Tabulate-large-quantity-of-data/m-p/1041#M304 I would recommend going on a basic SAS course. See SAS training web site. Tue, 18 Jul 2006 11:32:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Tabulate-large-quantity-of-data/m-p/1041#M304 deleted_user 2006-07-18T11:32:03Z