BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GeorgeSAS
Lapis Lazuli | Level 10

Hello everyone,

 

I want to know which SAS dataset was linked from a SAS view.(the view was created by proc sql; create view....)

I can't get it from proc contents prodecure.

 

Please help!

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
If it's a SQL view try the following:

proc sql;
describe view VIEWNAME;
quit;

The code will be in the log.

View solution in original post

1 REPLY 1
Reeza
Super User
If it's a SQL view try the following:

proc sql;
describe view VIEWNAME;
quit;

The code will be in the log.
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 750 views
  • 1 like
  • 2 in conversation