topic Re: Read existing View created by someone else in SAS Procedures

Read existing View created by someone else

chandler — Wed, 11 May 2011 17:14:54 GMT

I see a lot of SAS documentation on how to create a view, and efficiency and etc. etc., but nothing on syntax to just read the view to create a subset dataset for a report.

I have access to a library of data from another department. In that library is a view, already created, and updated each month. I just need data from that view to create a subset that will be used for reporting purposes. I don't want to create the reports directly from that view, for safety and data integrity purposes and to prevent errors or overrwriting data.

I want to write a data step to place the data from that view into a dataset in another library as follows:

data mylib.acls_curr ;
set loan.Month_end_data ; /** NOTE: "month_end_data" is an existing view **/
run;

Someone, please help me with the syntax.

Re: Read existing View created by someone else

SPR — Wed, 11 May 2011 17:22:37 GMT

Hello Chandler,

I do not see any problems with your code. Views are used the same way as datasets. The difference is in creation of a view (namely in the data stetement):
[pre]
data a/view=a;
x=1;
output;
run;
[/pre]
Sincerely,
SPR

Re: Read existing View created by someone else

chandler — Wed, 11 May 2011 17:42:21 GMT

Thanks, SPR, for your quick response. I will proceed with my data step code, as is.