topic Re: views in sas in SAS Programming

views in sas

BrahmanandaRao — Fri, 04 Dec 2020 05:37:26 GMT

how to Create a view from the view.?

how to Create a data set from the view.?

Re: views in sas

Shmuel — Fri, 04 Dec 2020 06:55:32 GMT

Suppose you have a data set named WORK.HAVE.

create a view by - input can be either a data set or a view

        data my_view / view=my_view;
           set have;
                /* add any sas code */
        run;

Create a data set from a view:

              data new;
                 set my_view;
             run;

Re: views in sas

BrahmanandaRao — Fri, 04 Dec 2020 09:07:26 GMT

Can we update (add column ,rename of variables etc.,) view and index in sas

Re: views in sas

Kurt_Bremser — Fri, 04 Dec 2020 11:02:08 GMT

@BrahmanandaRao wrote:
Can we update (add column ,rename of variables etc.,) view and index in sas

Think a little about it:

A view takes one or more datasets, possibly combines the data, and possibly applies logic to the data.

Can you think of a way to reverse-engineer the input data from a change in the end result without a VERY serious programming effort?

So the answer is a plain NO.

But you can describe the view, both data step and SQL, and then use that as a base for changed code:

data class / view=class;
set sashelp.class;
rate = weight / Height;
run;

data view=class;
describe;
run;

proc sql;
create view class as
  select
    *,
    weight / height as rate
  from sashelp.class
;
quit;

proc sql;
describe view class;
quit;