BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I am in process of upgrading to SAS 9.2 (M2) on z/OS. One of the job writes to an Open ODS HTML successfully on SAS9.1.3 but can't on SAS9.2. The error i am getting is
"ERROR: AT LEAST ONE FILE ASSOCIATED WITH FILEREF OUTHTML IS STILL IN USE.
ERROR: ERROR IN THE FILENAME STATEMENT."

I have sorted out the problem by closing it off and reinitialising it. But i don't understand why i have to do this, given that i can't find any reference of making these changes in the first place. My only worry is that are there any more changes like this that i need to look at.

Thanks
2 REPLIES 2
Robert_Bardos
Fluorite | Level 6
Not sure whether I exactly understand what you want.
Does the following help? (Watch especially for the second FILENAME statement).

x 'umask 002' ;

filename outhtml '/var/rzb/sas/tmp/ods_html_92.html' ;

ods listing close ;

ods html body=outhtml (no_bottom_matter) ;
proc print data=sashelp.class(where=(age<15)) ;
run ;
ods html close ;

filename outhtml "%sysfunc(pathname(outhtml))" mod ;

ods html body=outhtml (no_top_matter) ;
proc print data=sashelp.class(where=(age>14)) ;
run ;
ods html close ;


Kind regards
Robert Bardos
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Need to see your SASLOG output when the error occurred. Also, ensure that you are current on SAS HOTFIX maintenance. It's quite possible that SAS tightened up open FILENAME allocations, but your SAS-generated log (with all SAS code revealed) will help explain more about the situation.

Also, check your FILELOCKS OPTIONS setting, new with SAS 9.2.

Scott Barry
SBBWorks, Inc. Message was edited by: sbb

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 859 views
  • 0 likes
  • 3 in conversation