Cristina, thank you so much for the reply. Please see below:
PROC SQL; CREATE TABLE r.Entries AS SELECT entry_id, entrydate, entrycode FORMAT=$entrycode. FROM data.base WHERE entrydate BETWEEN '01JAN2025'D AND '31AUG2025'D AND entrycode IN ('01', '02', '11'); QUIT;
PROC SORT DATA=r.Entries NODUPS; BY entry_id; RUN;
I'd like my report to show how many entries occurred each week ex: Monday Jan 1st -Sunday Jan 5th, Monday Jan 6th-Sunday Jan12th, ...and so on or whatever increments are available for 7 day period or week long period. Unsure what options are available...my requestor would like to know how many people entered each week.
... View more