BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
CTC_DAVE_M
Fluorite | Level 6

I need to control the space allocation of dynamically allocated data sets. Does anyone know if there is an option somewhere. Any help would be greatly appreciated, as this is affecting a production jobflow. The SAS program is in the middle of a PROC SQL and allocated temporary data sets, one of record length 29312. I'd also like to know if that is controllable as it is wasting almost half of the 3390 track.

Thank you for any help and your patience, as I am new to the SAS forums.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Patrick
Opal | Level 21

Oh, then I'm out of my depth here. Using SAS under z/OS is now well more than a decade ago for me.

 

The following is just some guessing really: I assume what you're talking about is the UTILLOC area where SAS processes create intermediate temporary SAS files during sort operations and the like. Doing some Googling may-be below two docu links might be of help: 

UTILLOC= System Option: z/OS

BLKALLOC System Option: z/OS

 

SAS under z/OS is nowadays a rather rare skill set. If above doesn't help you then likely your best option is to contact SAS Tech Support directly.

View solution in original post

4 REPLIES 4
Patrick
Opal | Level 21

If you're not talking memory but physical storage (which includes tables in WORK) then use compress=yes - either as session level setting or then as SAS data set option for the specific WORK table.

CTC_DAVE_M
Fluorite | Level 6
Patrick, I don't think I phrased my question/issue correctly. The batch SAS job dynamically allocates temporary datasets during PROC SQL statement. I need to know how to control the space allocations and/or the LRECL of the datasets (29312), which is just over half of a 3390 track, wasting considerable space. It is also under allocating the space requirement, causing constant SB37 abends. I thought specifying DYNALLOC in the options and pre-allocating SORTWKnn DD statements would do it, but it didn't. Any help you or anyone else in the forum can provide would be greatly appreciated. Thanks.
Dave Manning
Patrick
Opal | Level 21

Oh, then I'm out of my depth here. Using SAS under z/OS is now well more than a decade ago for me.

 

The following is just some guessing really: I assume what you're talking about is the UTILLOC area where SAS processes create intermediate temporary SAS files during sort operations and the like. Doing some Googling may-be below two docu links might be of help: 

UTILLOC= System Option: z/OS

BLKALLOC System Option: z/OS

 

SAS under z/OS is nowadays a rather rare skill set. If above doesn't help you then likely your best option is to contact SAS Tech Support directly.

CTC_DAVE_M
Fluorite | Level 6
Thanks Patrick, I took your advice and contacted SAS technical support. They pointed me to the same links and my problem is resolved. Thank you.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1252 views
  • 2 likes
  • 2 in conversation