topic Can sas view be dynamic in SAS Programming

Can sas view be dynamic

RahulG — Thu, 07 Jul 2016 05:38:46 GMT

I have following sas view with where condition. First time I pass the value of User_date as 1Jan2016 and view become fixed.

Now if I change the user date to 2Jan2016, it shows me 1Jan data. I tried it with diferent session but view is resulting in 1 Jan records.

I want to have view with flexibility to show me different record if I change the value of User_date.

proc sql;

create view temp_view as

select *

from table1 where RUN_DATE = &USER_DATE;

quit;

Re: Can sas view be dynamic

LinusH — Thu, 07 Jul 2016 06:16:30 GMT

I don't have SAS at my fingertips right to test, bet perhaps symget() could work?
If not, store you dynamic value in a table and use it in a inner join/sub query in the view.

Re: Can sas view be dynamic

Ksharp — Thu, 07 Jul 2016 06:53:33 GMT

proc sql;
create view temp_view as
select *
from sashelp.class where sex=symget('USER_DATE');
quit;


%let USER_DATE=F;
proc print data=temp_view ;run;





%let USER_DATE=M;
proc print data=temp_view ;run;