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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1465 views
  • 0 likes
  • 2 in conversation