I'm trying to create a flag variable and it isn't working.
The piece I'm having issues with is the Perf='Y' flag (performance flag)
%let start='01Oct2016'd;
data NewGroups;
set groups;
thrudate=today()-45;
if (thrudate gt beg_dt) and (beg_dt >='01Oct2016'd) then Perf='Y'; else Perf='N';
/*if &today. >=&start. then Perf='Y'; else perf='N';*/
/*format thrudate date9.;*/
startdate=&Start.;
/*format startdate date9.;*/
PerfMonths=intck('month',startdate,thrudate);
beg_dt=input(begin_date,anydtdte19.);
/*format beg_dt date9.;*/
where beg_month >='01Oct2016'd;
run;
proc contents data=newgroups;
run;
proc print data=newgroups(obs=20);
run;
It looks as if you are using beg_dt before you are giving it a value.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.