Desktop productivity for business analysts and programmers

Dataset Label Names

Reply
Occasional Contributor
Posts: 18

Dataset Label Names

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!

Valued Guide
Posts: 858

Re: Dataset Label Names

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

Super User
Posts: 11,101

Re: Dataset Label Names

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?

Occasional Contributor
Posts: 18

Re: Dataset Label Names

the names don't show work.whatever.

Super User
Posts: 11,101

Re: Dataset Label Names

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?

Occasional Contributor
Posts: 18

Re: Dataset Label Names

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.

Super User
Posts: 3,233

Re: Dataset Label Names

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.

Ask a Question
Discussion stats
  • 6 replies
  • 533 views
  • 0 likes
  • 4 in conversation