BookmarkSubscribeRSS Feed
Tushh
Calcite | Level 5

How to find SAS Dataset's following details.

 

 1. SAS Programs (in Which SAS programs particular dataset is using)

 2. IN SQL Query

 3. IN stored procedure

 4. IN Views

 

 

 

Thank You

1 REPLY 1
LinusH
Tourmaline | Level 20
  1. PROC SCAPROC
  2. PROC SCAPROC
  3. n/a in SAS. If you don't refer to Stored Process (different thing than a DBMS stored procedure)
  4. DESCRIBE VIEW (and potentially FEEDBACK option)

This will you give more or less structured text output.

If you really need to document your system, data and processes, you should go for a metadata driven environment.

Data never sleeps

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
  • 1 reply
  • 1487 views
  • 0 likes
  • 2 in conversation