https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-with-Stack-task/m-p/4668#M1499 Hi:<BR /> I think this previous posting is still relevant:<BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=6968ᬸ" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=6968ᬸ</A><BR /> <BR /> The Stack Task (PROC TRANSPOSE) is not a reporting procedure. It is meant to create an output data set on which you could then run PROC PRINT or PROC REPORT or PROC TABULATE.<BR /> <BR /> In the previous posting, I recommended that you contact Tech Support. If you are turning this code into a Stored Process, then PROC TRANSPOSE might not be the best solution. If you used a DATA step program, you could control what happened in the "no data" situation. I still think it's a good idea to contact Tech Support, especially since you're working with stored processes as well as PROC TRANSPOSE.<BR /> <BR /> cynthia Thu, 13 Sep 2007 04:00:19 GMT Cynthia_sas 2007-09-13T04:00:19Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-with-Stack-task/m-p/4667#M1498 Hi<BR /> I am using a Stack Task to generate a report in EG.<BR /> Since i Have column sundry code which has 10 occurence in Oracle table,so i have to use Stack task to get it in one task.<BR /> I am able to get it in one column when data is there.<BR /> But when there is no data in my table the stack task doesnt craete a new column for me and bcoz of that what ever Stored Process i am trying to run it gives an error that this new column is missing.<BR /> Any other solution for this. Wed, 12 Sep 2007 17:10:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-with-Stack-task/m-p/4667#M1498 deleted_user 2007-09-12T17:10:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-with-Stack-task/m-p/4668#M1499 Hi:<BR /> I think this previous posting is still relevant:<BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=6968ᬸ" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=6968ᬸ</A><BR /> <BR /> The Stack Task (PROC TRANSPOSE) is not a reporting procedure. It is meant to create an output data set on which you could then run PROC PRINT or PROC REPORT or PROC TABULATE.<BR /> <BR /> In the previous posting, I recommended that you contact Tech Support. If you are turning this code into a Stored Process, then PROC TRANSPOSE might not be the best solution. If you used a DATA step program, you could control what happened in the "no data" situation. I still think it's a good idea to contact Tech Support, especially since you're working with stored processes as well as PROC TRANSPOSE.<BR /> <BR /> cynthia Thu, 13 Sep 2007 04:00:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-with-Stack-task/m-p/4668#M1499 Cynthia_sas 2007-09-13T04:00:19Z