that
i wrote the above syntax but that doesnt cut it.
please help
thanx
Ok. There is a number of things wring with your code. First and foremost, your inequality signs are in the wring direction. No date value can be smaller than 01jan2010 and larger than 31dec2015...
I have written this template from the sashelp.stocks data set. Should give you what you want.
data test;
set sashelp.stocks;
prevalence = (('01jan1998'd <= date <= '31dec2000'd) and (stock='IBM'));
run;
So, you want prevalance to be a dummy variable, correct? Do you get errors in the log?
Ok. There is a number of things wring with your code. First and foremost, your inequality signs are in the wring direction. No date value can be smaller than 01jan2010 and larger than 31dec2015...
I have written this template from the sashelp.stocks data set. Should give you what you want.
data test;
set sashelp.stocks;
prevalence = (('01jan1998'd <= date <= '31dec2000'd) and (stock='IBM'));
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.