get SAS view information(how the view was created)

GeorgeSAS — Mon, 03 Jun 2019 17:02:23 GMT

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!

Re: get SAS view information(how the view was created)

Reeza — Mon, 03 Jun 2019 17:17:04 GMT

If it's a SQL view try the following:

proc sql;
describe view VIEWNAME;
quit;

The code will be in the log.