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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.