Creating list reports

by Tomowsiak

7 played - 11 yrs ago

Chapter 4 from the book

8 QUESTIONS

45%

If I want to assign a label to 3 fields, (on, changed, flight ), print a date, and print records only where flight number is 219, which is correct?

Var on changed flight; where on>=219;

Var date on changed flight; where changed>3;

Var boarded transferred flight; label boarded='on' transferred='changed'; where flight=219;

Var date on changed flight; where flight=219;

If labels are NOT stored with the data, which can be used to make the field names prettier?

Proc print data=mylib. crap label;label field1='Field1' field2='Field2';

Roc print data=mylib. crap;label field1='Field1' field2='Field2';

Roc print data=mylib. crap label;run;

Roc print data mylib. crap label;label field1='Field1' field2='Field2';

Which selects ONLY those that have style equal to ranch, split or twostory?

Where style='ranch' or 'split' or 'twostory';

Where style in 'ranch' or 'split' or 'twostory';

Where style in (Ranch, Split, Twostory);

Where style in('ranch', 'split', 'twostory');

Which would output a new, temp file called calc?

Proc sort data=work. calc out=finance. dividend; run;

Proc sort dividend out=calc;run;

Proc sort data=finance. dividend out=work. calc; by account; run;

Proc sort from finance out work. calc;

If you want to create a table, summing the instructors, aerobicclass, walkjogrun, and swim fields, which is correct?

Var month instructors; sum instructors aerobicclass walkjogrun swim;

Var month; sum instructors aerobicclass walkjogrun swim;

Var month instructors aerobicclass; sum instructors aerobicclass walkjogrun swim;

All of the above

If you run this, what happens? proc sort data=clinic. diabetes; run; proc print data=clinic. diabetes; var age height weight pulse; where sex="F";run;

Proc print step runs, printing observations in SORTED order

Proc sort runs, permanently sorting the data in the file

Proc sort is missing by, so it stops, but proc print runs as usual

Proc sort runs, but proc print generates errors

Proc sort is used to sort by months amount. . then proc print is used as : proc print data=work. loans noobs; var months; sum amount payment; run; which pops out as the output? (dollar formats on fields)

Months(sorted), amount(summed, dollar format), payment(summed, no dollar format)

Months(not sorted), amount(summed), payment(summed)

Months(not sorted), amount(summed)

Months(sorted), amount(summed, dollar format), payment(summed, dollar format)

Which is correct to choose an amount less than or equal to 5000 AND the account is 101-1092 or the rate is 0. 095?

Where amount<= 5000 and account='101-1092' or rate='0. 095';

Where (amount le 5000 and account='101-1092') or rate ='0. 095';

Where amount <=5000 and (account='101-1092' or rate='0. 095');

Where amount <=5000 and account='101-1092' or rate='0. 095';

Let's GO

All comments (0)