The following SAS program is submitted:

data temp; set sasuser.history(keep = 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 2 12 3 15 4 25 Which By statement completes the data step and successfully generates the required output?

Question

The following SAS program is submitted:

data temp; set sasuser.history(keep = 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 2 12 3 15 4 25 Which By statement completes the data step and successfully generates the required output?

Accepted Answer

D. by groupformat date;

Answer

A. by date qtr.;

Answer

B. by notsorted date;

Answer

C. by formatted date;

The following SAS program is submitted: data temp; set sasuser.history(keep = date); format date qtr.; <insert BY statement here> if first.date then total = 0; total + 1; if last.date; run; proc…

Question

Options

How the community answered

Community Discussion