general cert question

[Steelers_In_DC]

Good Afternoon All, It's been a while since I've posted.  I'm studying for the base sas certification and depending on who I talk to it's either very easy or impossible.  I'm doing my best to gather study info from the interwebs, what sas provides seems like a lot of softballs compared to what the practice exams online look like.  I came across the following and don't understand it.  If you can help I'd appreciate it, any additional info regarding preparing for the certification is welcome also.

Thanks,

Why does the following contain 25 observations:

data allobs;

     set sasdata.banks;

          capital=0;

          do year = 2000 to 2020 by 5;

          capital + ((capital+2000) * rate);

          output;

     end;

Mark

[DBailey]

I don't have a sasdata.banks, but I suspect it has 5 observations in it  For each observation, the loop is executed 5 times so 5 * 5=25.

[data_null__]

It is due to the placement of the OUTPUT statement.  5 obs output for each obs in SASDATA.BANKS.

[Linlin · Accepted solution]

the do loop outputs five times and there must be five observations in the dataset sasdata.backs. 5*5=25

data banks;

input rate;

cards;

.05

.06

.07

.08

.09

;

data allobs;

    set banks;

          capital=0;

          do year = 2000 to 2020 by 5;

          capital + ((capital+2000) * rate);

          output;

     end;

run;

proc print;run;

[Steelers_In_DC]

Thanks, spelling it out like that helped a great deal.  Running the program and looking at the log/output always helps.