BookmarkSubscribeRSS Feed
richardmgb
Fluorite | Level 6

We just installed SAS 9.4 from 9.3. We are having issues with label names of the datasets created in the Work directory. They are being named as "WORK.DATASET" instead of just "DATASET". This is having an effect on existing programs that are being migrated.

Does anyone know how to fix this? This would help A LOT!

Thank you so much!

6 REPLIES 6
Steelers_In_DC
Barite | Level 11

What issues are you having?  work. is implied for all temporary datasets, whether you name then work.dataset or just dataset shouldn't matter.

ballardw
Super User

If you run this code:

proc datasets library=work details;run; quit;

do the output names of the sets show as work.whatever?

Or is there a label associated with the set?

richardmgb
Fluorite | Level 6

the names don't show work.whatever.

ballardw
Super User

It would appear then that the dataset names aren't being affected.

When you say

This is having an effect on existing programs that are being migrated.

what type of effects are you actually seeing?

richardmgb
Fluorite | Level 6

It is creating virtually a separate dataset from the flow when I rerun the program. This only happens when query builder is being used. Not code.

SASKiwi
PROC Star

Are you refering to the datasets that the Query Builder creates? They are usually called QUERY_FOR_YourTableName and are stored in the WORK library.

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

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 6 replies
  • 2869 views
  • 0 likes
  • 4 in conversation