Play
hundreds of
trivia quizzes
and
create
your own for free
quizzes
Forums
we will not publish anything on your wall
Stay logged in
Forgotten?
Connection
Create my account
log in
+ Create a Quiz
Tests
News
Tops
Games
Forums
General knowledge
Entertainment
Sport & Recreation
+
General knowledge
Geography
History
Sciences
All Quizzes
/
Quiz General knowledge
/
Quiz Sciences
Creating list reports
created by
tomowsiak
on 30 Mar 12
Sciences
Medium level
(45% of success)
8 questions - 7 players
Chapter 4 from the book
1
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;
2
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';
3
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');
4
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;
5
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
6
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
7
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)
8
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';
Quiz.biz does not certify the quizzes to be reliable, contact Tomowsiak !
Let's GO
Comment this Quiz
If you want to rank and comment this quizz,
login in
or
create an account
!
You will love these quizzes
4th Grade Science Test
17 276 players
- Jmathis
5 Kingdoms
14 214 players
- Cppuntadenamer
9th Standard Science
48 357 players
- Iplfreak
Some Science ?
3 967 players
- Good
Science
4 523 players
- Jeffcoop
created
9 yrs ago
by
Tomowsiak
Medium level
45%
Average on
7 players
(
0
this month )
all results
Autres quizz de Tomowsiak
Arrays in SAS
2 players
- Tomowsiak
Sas Programming 1
54 players
- Tomowsiak
Reading date and time values
16 players
- Tomowsiak
Design Of Experiments
25 players
- Tomowsiak
User defined formats chapter 7
7 players
- Tomowsiak
all results
