A00_211 questions • Exam prepare

sas_institute A00_211

Exam contains 232 questions

Page 31 of 39

Question 181 🔥

The following SAS program is submitted:data revenue;set year_1;var1 = mdy(1,15,1960);run;Which one of the following values does the variable named VAR1 contain?

Which database solution meets these requirements?

A. 14

B. 15

C. 1151960

D. '1/15/1960'

Discussion of the question

Question 182 🔥

The following SAS program is submitted:data work.new;mon = 3;day = 23;year = 2000;date = mdy(mon,day,year);run;Which one of the following is the value of the DATE variable?

Which database solution meets these requirements?

A. a character string with the value '23mar2000'

B. a character string with the value '03/23/2000'

C. a numeric value of 14692, which represents the SAS date value for March 23, 2000

D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000

Discussion of the question

Question 183 🔥

The following SAS DATA step executes on Monday, April 25, 2000: data newstaff; set staff; start_date = today(); run;Which one of the following is the value of the variable START_DATE in the output data set?

Which database solution meets these requirements?

A. a character string with the value '04/25/2000'

B. a character string with the value 'Monday, April 25, 2000'

C. the numeric value 14725, representing the SAS date for April 25, 2000

D. the numeric value 04252000, representing the SAS date for April 25, 2000

Discussion of the question

Question 184 🔥

The following SAS DATA step is submitted:data sasdata.atlantasasdata.bostonwork.portlandwork.phoenix;set company.prdsales;if region = 'NE' then output boston;if region = 'SE' then output atlanta;if region = 'SW' then output phoenix;if region = 'NW' then output portland;run;Which one of the following is true regarding the output data sets?

Which database solution meets these requirements?

A. No library references are required.

B. The data sets listed on all the IF statements require a library reference.

C. The data sets listed in the last two IF statements require a library reference.

D. The data sets listed in the first two IF statements require a library reference.

Discussion of the question

Question 185 🔥

Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

Which database solution meets these requirements?

A. libname sasdata 'SAS-data-library'; data sasdata.mydata; copy mydata; run;

B. libname sasdata 'SAS-data-library'; data sasdata.mydata; keep mydata; run;

C. libname sasdata 'SAS-data-library'; data sasdata.mydata; save mydata; run;

D. libname sasdata 'SAS-data-library'; data sasdata.mydata; set mydata;

Discussion of the question

Question 186 🔥

The following SAS DATA step is submitted:libname temp 'SAS-data-library';data temp.report;set sasuser.houses;newvar = price * 1.04;run;Which one of the following statements is true regarding the program above?

Which database solution meets these requirements?

A. The program is reading from a temporary data set and writing to a temporary data set.

B. The program is reading from a temporary data set and writing to a permanent data set.

C. The program is reading from a permanent data set and writing to a temporary data set.

D. The program is reading from a permanent data set and writing to a permanent data set.

Discussion of the question

Ready to Pass Your Certification Test

sas_institute A00_211

Exam contains 232 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us