Quiz
Quiz
Scenario:
This project will use data setcert.input04. At any time, you may save your program
asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.
In this program, complete the following mathematical actions, in the following order:
Round VAR1 and VAR2 to the nearest integer values.
Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.
Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.
For observation 16, what is the value ofVAR3? Enter your numeric answer in the space below:
data results.output04;
set cert.input04;
var3=round(var1,1)*round(var2,1);
var20=sum(of var12-var19);
run;
proc print data=results.output04 (obs=16 firstobs=16);
var var3 var20;
run;
The 'obs' option controls the last observation SAS processes. If you set obs=16, SAS would read and
process only up to the 16th observation in the data set.
The 'firstobs' option controls the starting observation. If you set firstobs=16, SAS would start reading
and processing from the 16th observation.
Quiz
Scenario:
This project will use data setcert.input04. At any time, you may save your program
asprogram04incert\programs. Write a SAS program that will create the data setresults.output04.
In this program, complete the following mathematical actions, in the following order:
Round VAR1 and VAR2 to the nearest integer values.
Multiply the rounded VAR1b y the rounded VAR2 and assign the new value to VAR3.
Add VAR12 through VAR19 (8 variables) together, ignoring missing values. Assign the sum to VAR20.
For observation 16, what is the value ofVAR20? Enter your numeric answer in the space below.
Round your answer to the nearest whole number. Save your program
asprogram04.sasincert\programs before continuing with the next project
data results.output04;
set cert.input04;
var3=round(var1,1)*round(var2,1);
var20=sum(of var12-var19);
run;
proc print data=results.output04 (obs=16 firstobs=16);
var var3 var20;
run;
If you got this question wrong because you didn't round to the nearest whole number, please know
that the actual exam will restrict you to entering only a whole number to prevent this from occurring.
The correct answer is: 3175
Quiz
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
o Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
o Write only observations that are in both data sets to a
new data set named results.match08.
o Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
o Exclude all variables that begin with
"ex" from results.nomatch08.
How many observations (rows) are inresults.match08?
Enter your numeric answer in the space below:
proc sort data=cert.input08a out=work.input08a;
by ID;
run;
proc sort data=cert.input08b out=work.input08b;
by ID;
run;
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run:
proc contents data=results.nomatch08;
run;
The correct answer is: 1200
Quiz
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
o Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
o Write only observations that are in both data sets to a
new data set named results.match08.
o Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
o Exclude all variables that begin with
"ex" from results.nomatch08.
How many variables (columns) are in results.match08
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
SAS code that could be used to solve this project:
proc
sort data=cert.input08a out=work.input08a;
by ID;
run:
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 117
Quiz
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
o Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
o Write only observations that are in both data sets to a
new data set named results.match08.
o Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
o Exclude all variables that begin with
"ex" from results.nomatch08.
How many observations (rows) are inresults.nomatch08?
by ID;
run:
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a;
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 2
Quiz
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
o Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
o Write only observations that are in both data sets to a
new data set named results.match08.
o Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
o Exclude all variables that begin with
"ex" from results.nomatch08.
How many variables (columns) are in ______________ results.nomatch08
Enter your numeric answer in the space below:
Save your program as program08.sas in folder cert programs
before continuing with the next project.
Proc
sort data=cert.input08a out=work.input08a;
by ID;
run;
proc sort data=cert.input08b out=work.input08b;
by ID;
run;
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 5
Quiz
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:
o salary
o year
Write a SAS program that will:
o Create an output data set results.output12.
o Read cert.input12 as input.
o Increase the salary variable by 5.65% annually until it is
greater than $500,000.
o Increment the year variable by 1 with each annual
increase.
o 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)
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;
Quiz
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:
o salary
o year
Write a SAS program that will:
o Create an output data set results.output12.
o Read cert.input12 as input.
o Increase the salary variable by 5.65% annually until it is
greater than $500,000.
o Increment the year variable by 1 with each annual
increase.
o 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 value of year when the above salary occurs? Enter your numeric answer in the space
below.
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;
Quiz
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:
o Date1, a numeric variable representing an unformatted
SAS date value. Example: 12001.
o Charnum, a character variable representing a monetary
amount. Example: $50,000.
Write a SAS program that will:
o Save the new data set as results.output13.
o Create a new variable Chdate that converts
the datel variable to a character variable that is in the
format ddmonyyyy, such as 11NOV1992.
o Create a new variable num1 that converts
the Charnum variable to a numeric variable.
What is the value ofChdatefor observation 52?
set cert.input13;
Chdate=put(date 1,date9.);
num 1=input(Charnum,dollar7.);
run;
proc print data=results.output13 (firstobs=52 obs=52);
run;
A00-231: SAS 9.4 Base Programming - Performance-Based Practice test unlocks all online simulator questions
Thank you for choosing the free version of the A00-231: SAS 9.4 Base Programming - Performance-Based practice test! Further deepen your knowledge on SAS Simulator; by unlocking the full version of our A00-231: SAS 9.4 Base Programming - Performance-Based Simulator you will be able to take tests with over 36 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 36 questions.
BUY NOWWhat to expect from our A00-231: SAS 9.4 Base Programming - Performance-Based practice tests and how to prepare for any exam?
The A00-231: SAS 9.4 Base Programming - Performance-Based Simulator Practice Tests are part of the SAS Database and are the best way to prepare for any A00-231: SAS 9.4 Base Programming - Performance-Based exam. The A00-231: SAS 9.4 Base Programming - Performance-Based practice tests consist of 36 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The A00-231: SAS 9.4 Base Programming - Performance-Based database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with A00-231: SAS 9.4 Base Programming - Performance-Based Simulator will also give you an idea of the time it will take to complete each section of the A00-231: SAS 9.4 Base Programming - Performance-Based practice test . It is important to note that the A00-231: SAS 9.4 Base Programming - Performance-Based Simulator does not replace the classic A00-231: SAS 9.4 Base Programming - Performance-Based study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the A00-231: SAS 9.4 Base Programming - Performance-Based exam.
BUY NOWA00-231: SAS 9.4 Base Programming - Performance-Based Practice test therefore represents an excellent tool to prepare for the actual exam together with our SAS practice test . Our A00-231: SAS 9.4 Base Programming - Performance-Based Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our A00-231: SAS 9.4 Base Programming - Performance-Based Simulator and how our unique A00-231: SAS 9.4 Base Programming - Performance-Based Database made up of real questions:
Info quiz:
- Quiz name:A00-231: SAS 9.4 Base Programming - Performance-Based
- Total number of questions:36
- Number of questions for the test:50
- Pass score:80%
You can prepare for the A00-231: SAS 9.4 Base Programming - Performance-Based exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our A00-231: SAS 9.4 Base Programming - Performance-Based Simulator.
Use our Mobile App, available for both Android and iOS devices, with our A00-231: SAS 9.4 Base Programming - Performance-Based Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.
Our Mobile App contains all A00-231: SAS 9.4 Base Programming - Performance-Based practice tests which consist of 36 questions and also provide study material to pass the final A00-231: SAS 9.4 Base Programming - Performance-Based exam with guaranteed success. Our A00-231: SAS 9.4 Base Programming - Performance-Based database contain hundreds of questions and SAS Tests related to A00-231: SAS 9.4 Base Programming - Performance-Based Exam. This way you can practice anywhere you want, even offline without the internet.
BUY NOW