Exam Code: A00-201
Exam Name: SAS base programming exam
Updated: Nov 13, 2024
Q&As: 140
At Passcerty.com, we pride ourselves on the comprehensive nature of our A00-201 exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.
Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your SASInstitute A00-201 exam.
Instant download
Latest update demo according to real exam
The contents of the raw data file PRODUCT are listed below:
----I----10---I----20---I----30
24613 $25.31
The following SAS program is submitted:
data inventory; infile `product; input idnum 5. @10 price; run;
Which one of the following is the value of the PRICE variable?
A. 25.31
B. $25.31
C. . (missing numeric value)
D. No value is stored as the program fails to execute due to errors.
The following SAS program is submitted;
data work.test;
First = `lpswich, England';
City = substr(First,1,7);
City_Country = City!!' , `!!`England';
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
A. lpswich!!
B. lpswich, England
C. lpswich, `England'
D. lpswich , England
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".
Which one of the following SAS programs temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
A. proc print data = sasuser.houses; label 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 = "Sale Price"; run;
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
A. proc print data = sasuser.houses; where price It 60000; where price gt 100000; run;
B. proc print data = sasuser.houses; where price It 60000 or price gt 100000; run;
C. proc print data = sasuser.houses; where price It 60000 and price gt 100000; run;
D. proc print data = sasuser.houses; where price It 60000 or where price gt 100000; run;
A raw data file is listed below:
RANCH,1250,2,1 ,Sheppard Avenue,"$64.000"
SPLIT,1,190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,18104,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615A,3,West Drive,"94,A50"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile `file-specification' dsd;
input style $ @;
if style = `CONDO' or style = `RANCH';
input sqfeet bedrooms baths street $ price : dollar10.; run;
How many observations will the output data set contain?
A.
B.
C.
D.
Viewing Page 1 of 3 pages. Download PDF or Software version with 140 questions