SQL Views

[zdeb15]

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?

[PGStats]

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.