Question 24: The contents of the raw data file SIZE are listed below:

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 24: The contents of the raw data file SIZE are listed below:

——–10——-20——-30
72 95
The following SAS program is submitted:
data test;
infile ‘size’;
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?
1.   2

2.  72

3.   95

4.  . (missing numeric value)
Correct Answers: 2
Exp :  Since there is no period after weight2(weight2.) the pointer will move to column 2
Since the 2. is not specified correctly, it considers 2 as column input and moves the pointer to column 2.
also remember, if you just specified @4 weight;
it would still be ok and it will give the correct value 95.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 23: When creating a format with the VALUE statement, the new format’s name

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 23: When creating a format with the VALUE statement, the new format’s name
–  cannot end with a number
–  cannot end with a period
– cannot be the name of a SAS format, and…

1.  cannot be the name of a data set variable.

2.  must be at least two characters long.

3.  must be at least eight characters long.

4.  must begin with a dollar sign ($) if used with a character variable

Correct Answer : 4

The name of a format that is created with a VALUE statement must begin with a dollar sign ($) if it applies to a character variable.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 22: Which of the following FORMAT procedures is written correctly?

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 22:  Which of the following FORMAT procedures is written correctly?

1.   proc format lib=library
value colorfmt;
1=’R’
2=’G’
3=’B’
run;
2. proc format lib=library;
value colorfmt
1=’R’
2=’G’
3=’B’;
run;
3.  proc format lib=library;
value colorfmt;
1=’R’
2=’G’
3=’B’
run;
4.  proc format lib=library;
value colorfmt
1=’R’;
2=’G’;
3=’B’;
run;

Correct Answer : 2

Exp : A semicolon is needed after the PROC FORMAT statement. The VALUE statement begins with the keyword VALUE and ends with a semicolon after all the labels have been defined.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 21 : Which of these is false? Ranges in the VALUE statement can specify…

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 21 : Which of these is false? Ranges in the VALUE statement can specify…

1. a single value, such as 24 or ‘S’
2. a range of numeric values, such as 0-1500.
3.  a range of character values, such as ‘A’-‘M’.
4. a list of numeric and character values separated by commas, such as 90,’B’,180,’D’,270.

Correct  Answer : 4

Exp : You can list values separated by commas, but the list must contain either all numeric values or all character values. Data set variables are either numeric or character.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 20: How many characters can be used in a label?

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 20: How many characters can be used in a label?

1.     40
2.     96
3.     200
4.    256

Correct Answer : 4

Exp : When specifying a label, enclose it in quotation marks and limit the label to 256 characters.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 19 : Which keyword can be used to label missing numeric values as well as any values that are not specified in a range?

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 19 : Which keyword can be used to label missing numeric values as well as any values that are not specified in a range?

1.     LOW
2.     MISS
3.     MISSING
4.     OTHER
Correct Answer : 4

Exp : MISS and MISSING are invalid keywords, and LOW does not include missing numeric values. The keyword OTHER can be used in the VALUE statement to label missing values as well as any values that are not specifically included in a range.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

Question 18 : You can place the FORMAT statement in either a DATA step or a PROC step. What happens when you place it in a DATA step?

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

Question 18 : You can place the FORMAT statement in either a DATA step or a PROC step. What happens when you place it in a DATA step?

1.     You temporarily associate the formats with variables

2.     You permanently associate the formats with variables.

3.     You replace the original data with the format labels.

4.    You make the formats available to other data sets.

Correct Answer : 2

Exp : By placing the FORMAT statement in a DATA step, you permanently associate the defined format with variables.

SAS BASE Certification 490 Questions | SAS Certification Practice Questions | A00-211 Certification Sample Questions

490 SAS Base Certificarion Practice Questions for A00-211  | 356+ SAS Advanced Certification Practice Questions for A00-212

SAS Combo offer