topic Problem with macro in SAS Programming https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180113#M34425 <HTML><HEAD></HEAD><BODY><P>please find attached script.</P><P></P><P>My goal is to create all states excel report files along with all related msa's . i[in one excel , on excel for state and other sheets for all related msa area's].</P><P></P><P>my issue. when i am running this scripts all together its creating separate sheets for each area with the name of state i.e. AK , AK1 , AK2 , AK3 ...</P><P></P><P>at the same time when i run the script in two part , like first time to create consolidate data and second time to create report files , in that time it works fine as i want.</P><P></P><P>First part is till created data set test7, and after that is second part.. </P><P></P><P>its not showing any error. </P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please suggest me the solution.</SPAN></P></BODY></HTML> Fri, 10 Oct 2014 10:56:08 GMT Aman4SAS 2014-10-10T10:56:08Z Problem with macro https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180113#M34425 <HTML><HEAD></HEAD><BODY><P>please find attached script.</P><P></P><P>My goal is to create all states excel report files along with all related msa's . i[in one excel , on excel for state and other sheets for all related msa area's].</P><P></P><P>my issue. when i am running this scripts all together its creating separate sheets for each area with the name of state i.e. AK , AK1 , AK2 , AK3 ...</P><P></P><P>at the same time when i run the script in two part , like first time to create consolidate data and second time to create report files , in that time it works fine as i want.</P><P></P><P>First part is till created data set test7, and after that is second part.. </P><P></P><P>its not showing any error. </P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please suggest me the solution.</SPAN></P></BODY></HTML> Fri, 10 Oct 2014 10:56:08 GMT https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180113#M34425 Aman4SAS 2014-10-10T10:56:08Z Re: Problem with macro https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180114#M34426 <HTML><HEAD></HEAD><BODY><P>can anyone help me on this??</P></BODY></HTML> Mon, 13 Oct 2014 06:25:06 GMT https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180114#M34426 Aman4SAS 2014-10-13T06:25:06Z Re: Problem with macro https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180115#M34427 <HTML><HEAD></HEAD><BODY><P>Would like to help you.</P><P>At the moment not able as missing my pc</P></BODY></HTML> Mon, 13 Oct 2014 07:35:40 GMT https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180115#M34427 jakarman 2014-10-13T07:35:40Z Re: Problem with macro https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180116#M34428 <HTML><HEAD></HEAD><BODY><P>Thanks for response. </P></BODY></HTML> Mon, 13 Oct 2014 07:37:58 GMT https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180116#M34428 Aman4SAS 2014-10-13T07:37:58Z Re: Problem with macro https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180117#M34429 <HTML><HEAD></HEAD><BODY><P>You throw a big junk of code at us in a "development" state and without any comments in the code. You don't provide any data so that the code is actually executable for us and we can replicate what you describe - and then test what we eventually would suggest.</P><P></P><P>You need to provide some test data (best as a data step creating this data) and then strip down your Proc Report with the ODS to the bare minimum so that it shows the challenge you're facing with the minimum code required. And then you tell us what you would want to get.</P><P></P><P>If you help us to help you then I'm sure someone will be able to provide a solution.</P></BODY></HTML> Mon, 13 Oct 2014 09:45:54 GMT https://communities.sas.com/t5/SAS-Programming/Problem-with-macro/m-p/180117#M34429 Patrick 2014-10-13T09:45:54Z