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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.