Which By statement completes the data step and successfully generates the required output?

The following SAS program is submitted:

data temp;

set sasuser.history(kep=date);

format date qtr

<insert BY statement here>

if first.date then total=0;

total+1;

if last.date;

run;

proc print data=temp;

run

SASUSER.HISTORY is sorted by the SAS date variable DATE.

The following output is required:

Date Total

1 13

3 15

4 25

Which By statement completes the data step and successfully generates the required output?
A . by groupformat date;
B . by formateed date;
C . by notsorted date;
D . by date qtr

View Answer

Answer: A