BookmarkSubscribeRSS Feed
Kaley
Calcite | Level 5

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;
1 REPLY 1
PGStats
Opal | Level 21

It looks as if you are using beg_dt before you are giving it a value.

PG

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1221 views
  • 0 likes
  • 2 in conversation