please find attached script.
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].
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 ...
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.
First part is till created data set test7, and after that is second part..
its not showing any error.
Please suggest me the solution.
can anyone help me on this??
Would like to help you.
At the moment not able as missing my pc
Thanks for response.
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.
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.
If you help us to help you then I'm sure someone will be able to provide a solution.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.