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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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