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;
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.