You should talk to tech support, there are too many things to check.
ie.
Does the macro run without using tagsets?
Do you have the latest version of tagsets?
What version of SAS?
Is the code running and then crashing as the file tries to open the XML file?
The macro runs fine and produces the multisheet excel file no problem. It's only when i run something else in sas that it takes ages to do anything and I have to close out of it.
I use the Base version.
How many records are you printing? SAS be default tries to open you output and it may be taking a long time to render. Also if you exceeded the number of rows of the program that may be trying to display the data (Excel anyone?) that process is hanging.
The superfluous quit; shouldn't be causing an issue.
Have you run this without the macros as 2 proc print calls within the tagsets.excelxp?
Or with file='\\Netapp4\Sasdata\Risk Modelling\CL Fleet\ROI\2014\00 - Main DWH\Enhanced DWH\Claims_dists.xml'
instead of Path and file?
I know why it is happening now but I don't know how to stop it. Loads of script is being generated in the Reviewer and even once the xms files are created the Reviewer keeps being populated with code.
In terms of size, the files have 6000 rows and 4/5 columns.
Is there some code I can use to stop the Reviewer generating script.
My intention, once the XML files are created is to convert them to xlsx.
I am a bit confused by your post. What is the "Reviewer"? As for your intention, XLSX files are merely a ZIP of XML files in Open Office format. Also, you can achieve a multi-sheet output by using:
SHEET_INTERVAL | Table | Interval to divide the output between worksheets. Values are Table, Page, Bygroup, Proc, or None |
So you may not need to generate the code, set all your data together with a title column, then do a proc report by.
Go into options and turn off the setting that states - View results as generated.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.