quizzes
Forums
Forums
Global
Art & Literature
Entertainment
General knowledge
High Tech
Nature
Society
Sports et Recreation
Games
Quiz of the day
The Great Test
Tops
Top Quizzes of the month
Top Quizzes
Top Quizers
Top Challengers
Top Players
Top Authors
Top Correctors
News
Latest quizzes & tests
50 last topics
Members activity
The 100 last reactions
Online members
Tests
General knowledge
Entertainment
Sport & Recreation
+
All Quizzes
Art & Literature
Entertainment
General knowledge
IT & Internet
Science & Nature
Society
Sport & Recreation
>
General knowledge
General knowledge
Geography
History
Sciences
All Quizzes
/
Quiz General knowledge
/
Quiz Sciences
Quiz Sciences
Creating list reports
by
Tomowsiak
7 played -
11 yrs ago
Chapter 4 from the book
8 QUESTIONS
45%
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';
Let's GO
All comments (0)
Add in a Facebook
You will love these quizzes
4th Grade Science Test
17 316 players
- Jmathis
5 Kingdoms
14 942 players
- Cppuntadenamer
Science
4 556 players
- Jeffcoop
9th Standard Science
48 581 players
- Iplfreak
Some Science ?
3 983 players
- Good
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
Generated on 19 Aug 22, 6h45