DATA Step, Macro, Functions and more

XML not loading until sas application is closed

Accepted Solution Solved
Reply
Regular Contributor
Posts: 157
Accepted Solution

XML not loading until sas application is closed

I am creating an xml file it's about 40mb.The file shows 0mb until i close the sas application.

 

The next step is i am running a code to convert the xml file to excel file.The xml file is not available for this code until i close sas application

 

Please let me know i fi need to use any options


Accepted Solutions
Solution
‎04-13-2017 09:55 PM
Super User
Posts: 7,854

Re: XML not loading until sas application is closed

Did you use ods tagsets.... close?

If you did, try this:

(just a shot from the hip)

 

- assign a file reference to the xml file with filename

- use that reference instead of a physical name

- after the ods close statement, use filename clear to delete the fileref

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎04-13-2017 09:55 PM
Super User
Posts: 7,854

Re: XML not loading until sas application is closed

Did you use ods tagsets.... close?

If you did, try this:

(just a shot from the hip)

 

- assign a file reference to the xml file with filename

- use that reference instead of a physical name

- after the ods close statement, use filename clear to delete the fileref

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation