OK, Last question
data school; input day:$upcase12. (start end)(:date9.); format start end date9.; shift = whichc(day,'SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY'); i = intck(cats('week.',shift),start,end); do c = 0 to i; classDay = intnx(cats('week.',shift),start,c,'B'); output; end; format classDay weekdate.; cards; FRIDAY 11JAN2016 01MAY2016 MONDAY 11JAN2016 01MAY2016 SATURDAY 11JAN2016 01MAY2016 THURSDAY 11JAN2016 02MAR2016 THURSDAY 11JAN2016 01MAY2016 THURSDAY 15FEB2016 01MAY2016 THURSDAY 03MAR2016 01MAY2016 TUESDAY 11JAN2016 02MAR2016 TUESDAY 11JAN2016 01MAY2016 TUESDAY 03MAR2016 01MAY2016 WEDNESDAY 11JAN2016 01MAY2016 ;;;; run;
proc print; run;
i keep gettin this error:
ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid.
thank you so much,appreciate your help.
... View more