Help using Base SAS procedures

Read existing View created by someone else

Reply
Contributor
Posts: 61

Read existing View created by someone else

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.
Super Contributor
Super Contributor
Posts: 365

Re: Read existing View created by someone else

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
Contributor
Posts: 61

Re: Read existing View created by someone else

Thanks, SPR, for your quick response. I will proceed with my data step code, as is.
Ask a Question
Discussion stats
  • 2 replies
  • 100 views
  • 0 likes
  • 2 in conversation