SASInstitute A00-231 Dumps Updated Aug 08, 2024 WIith 298 Questions
View All A00-231 Actual Free Exam Questions Aug 08, 2024 Updated
NEW QUESTION # 155
The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1;
end;
run;
Which one of the following is the value of the variable N in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 156
Given the following raw data records:
The following output data set is desired:
Which SAS program correctly reads in the raw data?
- A. data employees; infile 'file specification' dLM='*' dsd; input employee $ bdata: mmddyy10.years; run;
- B. data employees; infile 'file specification'dsd='*'; input employee $ bdata mmddyy10.years; run;
- C. data employees; infile 'file specification'DLM dsd; input employee $ bdata mmddyy10.years; run;
- D. data employees; infile 'file specification'dlm='*'; input employee $ bdata: mmddyy10.years; run;
Answer: A
NEW QUESTION # 157
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A. Pass
- B. Fail
- C. 50.5
- D. .(missing numeric value)
Answer: C
NEW QUESTION # 158
The following SAS program is submitted:
data WORK.ONE;
Text='Australia, US, Denmark';
Pos=find (Text,'US','i',5);
run;
What value will SAS assign to Pos?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 159
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".
Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
- A. proc print data = sasuser.houses; price = "Sale Price"; run;
- B. proc print data = sasuser.houses label; label price = "Sale Price"; run;
- C. proc print data = sasuser.houses label; label price "Sale Price"; run;
- D. proc print data = sasuser.houses; label price = "Sale Price"; run;
Answer: B
NEW QUESTION # 160
Which statement is true concerning the SAS automatic variable _ERROR_?
- A. It can be put into a keep statement or keep= option.
- B. It cannot be used in an if/then condition.
- C. It cannot be used in an assignment statement.
- D. It is automatically dropped.
Answer: D
NEW QUESTION # 161
A raw data file is listed below:
How many observations will the WORK.HOMEWORK data set contain?
- A. 0
- B. No data set is created as the program fails to execute due to errors.
- C. 1
- D. 2
Answer: C
NEW QUESTION # 162
The following SAS program is submitted:
data test;
infile 'file specification';
input name $ amount@@;
run;
Which of the following is true?
- A. Two @@ are invalid syntax and will cause the program to fail to execute.
- B. Two @@ together are the same as one c.
- C. Two @@ hold the data records until the bottom of the DATA step.
- D. Two @@ hold the raw data record across iterations of the DATA step.
Answer: D
NEW QUESTION # 163
Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- A. where Age not between 15 and 16 then Group=1; else Group=2;
- B. both A or C will work.
- C. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
- D. if Age not in(15,16) then Group=1; else Group=2;
Answer: D
NEW QUESTION # 164
This question will ask you to provide a missing format:
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS information correctly completes the program?
- A. mmddyy10
- B. ddmmyy10
- C. date10
- D. date9
Answer: A
NEW QUESTION # 165
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 166
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
- A. libname sasdata 'SAS-data-library';data sasdata.mydata;copy mydata;run;
- B. libname sasdata 'SAS-data-library';data sasdata.mydata;set mydata;run;
- C. libname sasdata 'SAS-data-library';data sasdata.mydata;save mydata;run;
- D. libname sasdata 'SAS-data-library';data sasdata.mydata;keep mydata;run;
Answer: B
NEW QUESTION # 167
Scenario:
This project will use data set cert.input12. At any time, you may
save your program as program12 in cert\programs.
cert.input12 contains a single observation with two variables:
* salary
* year
Write a SAS program that will:
* Create an output data set results.output12.
* Read cert.input12 as input.
* Increase the salary variable by 5.65% annually until it is
greater than $500,000.
* Increment the year variable by 1 with each annual
increase.
* Create an output data set results.output12 that has one
observation for each value of year. Each observation
should have a year and salary variable.
What is the maximum salary hat is less than $500,000? Enter your numeric answer in the space below (Round your answer to the nearest integer)
Answer:
Explanation:
498737
Explanation:
data results.output12;
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;
NEW QUESTION # 168
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
What is output?
- A. Option C
- B. Option B
- C. Option A
- D. Option D
Answer: D
NEW QUESTION # 169
The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists (keep = job_code);
if job_code = 'chem3'
then description = 'Senior Chemist';
run;
The variable JOB_CODE is a character variable with a length of 6 bytes.
Which one of the following is the length of the variable DESCRIPTION in the output data set?
- A. 8 bytes
- B. 14 bytes
- C. 6 bytes
- D. 200 bytes
Answer: B
NEW QUESTION # 170
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?
- A. a list of variable names
- B. a list of the variables in alphabetic order
- C. the total number of variables
- D. a list of the variables in the order they were created
Answer: D
NEW QUESTION # 171
Scenario:
This project will use data set cert.input13. At any time, you may
save your program as program13 in cert\programs.
This data set contains 1001 observations and 2 variables:
* Date1, a numeric variable representing an unformatted
SAS date value. Example: 12001.
* Charnum, a character variable representing a monetary
amount. Example: $50,000.
Write a SAS program that will:
* Save the new data set as results.output13.
* Create a new variable Chdate that converts
the datel variable to a character variable that is in the
format ddmonyyyy, such as 11NOV1992.
* Create a new variable num1 that converts
the Charnum variable to a numeric variable.
What is the value ofChdatefor observation 52?
Answer:
Explanation:
30DEC1992
Explanation:
data results.output13;
set cert.input13;
Chdate=put(date 1,date9.);
num 1=input(Charnum,dollar7.);
run;
proc print data=results.output13 (firstobs=52 obs=52);
run;
NEW QUESTION # 172
Given the following SAS log entry:
What caused the error?
- A. A semi-colon is missing on the DATALINES statement.
- B. Character data must be specified in quotes.
- C. The CANCEL option is required with DATALINES.
- D. The INPUT statement should be after the DATALINES statement.
Answer: A
NEW QUESTION # 173
Which one of the following is true of the SUM statement in a SAS DATA step program?
- A. It is only valid in conjunction with a SUM function.
- B. It adds the value of an expression to an accumulator variable and ignores missing values.
- C. It is not valid with the SET, MERGE and UPDATE statements.
- D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
Answer: B
NEW QUESTION # 174
Which of the following programs correctly invokes the DATA Step Debugger?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION # 175
......
New A00-231 Exam Questions Real SASInstitute Dumps: https://actual4test.practicetorrent.com/A00-231-practice-exam-torrent.html