topic Re: SAS Views in SAS Programming

SAS Views

BrahmanandaRao — Tue, 07 Dec 2021 06:06:57 GMT

Hi Guys

what is SAS Views how to create and drop and uses like SAS Indexes

Re: SAS Views

Kurt_Bremser — Tue, 07 Dec 2021 07:02:43 GMT

See here: Definitions for SAS Views

Re: SAS Views

ChrisNZ — Tue, 07 Dec 2021 07:06:38 GMT

A view is a virtual table. It contains no data but is a view port to data, it points to data. As such it cannot be indexed. The underlying table(s) can be indexed.

They can be created just like tables. Here's the syntax:

data MYTABLE MYVIEW / view=MYVIEW;

proc sql; create view MYVIEW as select ...