SQL Views

zdeb15 — Mon, 21 Oct 2019 18:05:48 GMT

Hi guys, Quick question.

When creating a PROC SQL view in SAS then storing the view in a library on SAS Server...will the underlying data update each time I use the view? or will I need to put the program on a scheduler?

EX:

Proc sql;
connect to odbc (datasrc=mydatasrc);
create view mylib.test as
select
*
from connection to odbc (select * from [db].[dbo].[tablename]);
disconnect from odbc;
quit;

then I use that view in a different program...

data test; set mylib.test; run;

will the data be updated?

Re: SQL Views

PGStats — Mon, 21 Oct 2019 18:28:43 GMT

A view does not contain data. It is simply the recipe to generate the data. So, yes, the data retrieved when calling the view is always up to date.

topic Re: SQL Views in SAS Programming

SQL Views

Re: SQL Views