A00-211 Exam Questions

The following SAS program is submitted: libname temp 'SAS-data-library'; data work.new; set temp.jobs; format newdate mmddyy10.; qdate = qtr(newdate); ddate = weekday(newdate); run...

The following SAS program is submitted: data work.report; set work.sales_info; if qtr(sales_date) ge 3; run; The SAS data set WORK.SALES_INFO has one observation for each month in...

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?

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?

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_D...

The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted: proc print data = pets; var type breed; sum number; run; What is the result...

The following SAS program is submitted: data work.passengers; if OrigPassengers = then OrigPassengers = 100; TransPassengers = 100; OrigPassengers = TotalPassengers = sum (OrigPass...

Given the SAS data set PRICES: PRICES Prodid priceproducttypesalesreturns K1255.10NETWORK152 B132S 2.34HARDWARE30010 R18KY2 1.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARD...

The following SAS program is submitted: How many observations are written to the WORK.SALES data set?

The following SAS program is submitted: The program fails execution due to syntax errors. What is the cause of the syntax error?

Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY -------- ------------ Innis 60000 Jolli 50000 Ellis 55000 Liu 45000 The following SAS program is submitted: proc print data...

Given the SAS data set ONE: ONE ObsDte ------------- 109JAN2005 212JAN2005 The following SAS program is submitted: data two; set one; day = <insert expression here>; format dte dat...

Read the table: Given the SAS data set SASUSER.HOUSES: Obsstylebedroomsbathspricesqteetstreet 1CONDO21.5800501200MAIN 2CONDO32.5793501300ELM 3CONDO42.51271501400OAK 4CONDO22.011070...

Given the SAS data set WORKAWARDS: WORK.AWARDS FNAMEPOINTSMONTH ---------------------------------- Amy24 Amy17 Gerard33 Wang33 Wang112 Wang18 The following SAS program is submitted...

The following SAS program is submitted: libname temp `SAS data library'; data work.new; set temp.jobs; format newdate mmddw10.; mdate = month(newdate); ddate = weekday(newdate); ru...

The contents of the raw data file PRODUCT are listed below: --------10-------20-------30 24613 $25.31 The following SAS program is submitted: data inventory; infile 'product'; inpu...

The following SAS program is submitted: proc contents data = sashelp.class varnum; quit; What does the VARNUM option print?

The following SAS program is submitted: data test; set chemists; itjobcode = `Chem2' then description = `Senior Chemist'; else description = `Unknown'; run; The value for the varia...

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted: What is the value o...

The SAS data set WORK STAFF has three variables: - Name is character with a length of 8 - DOB is numeric with a length of 8 - Start_Date is numeric with a length of 8 The following...

This question will ask you to provide a line of missing code. Given the following data set WORK.SALES: The following program is submitted: Which statement should be inserted to pro...

Given the SAS data set WORK.ONE: The following SAS program is submitted: What value will SAS assign to Total?

Given the SAS data set WORK.ORDERS: Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that repr...

The following SAS program is submitted: What new value would be assigned to X if its original value was a missing value?

This question will ask you to provide a segment of missing code. Given the SAS data set WORK.ONE: The following SAS program is submitted: The data set WORK.TWO is created, where Da...

The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted: What are the forma...

Given the following IF/THEN statement: If Age NE 16 and Age NE 15 then Group-1; Which assignment statement for variable Group is functionally equivalent to the original statement u...

The following SAS program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Product Code descending Date Cost; run; Which of the following is true concerning the submitte...

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?

Given the data sets below: WORK.EMP with variables: WORK.NEWHIRE with variables: The following SAS program is submitted: The SAS data set WORK.EMP has 50 observations, and the data...

Given the raw data file EMPLOYEE.TXT: The following SAS program is submitted: What value does the variable idnum contain when the name of the employee is "Ruth"?

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

The Excel workbook REGIONS.XLSX contains the following four worksheets: EAST WEST NORTH SOUTH The following program is submitted: libname MYXLS pcfiles path='c:\regions.xlsx'; Whic...

Given the following raw data records: The following SAS program is submitted: What is the value of the price variable?

The following SAS program is submitted: What is the value of the variable Diff?

How many of the following SAS data set names are valid?

The following SAS program is submitted: What is the value of the variable var1?

This question will ask you to provide a line of missing code. The following SAS program is submitted: proc freq data = WORK.SALES; <insert code here> run; The following output is c...

Given the following SAS data set WORK.EMPDATA: Which WERE statement would display observations wit Job_Title containing the word "Manager"?

By default, which variables and data values are used to calculate statistics in the MEANS procedure?

A user-defined format has been created using the FORMAT procedure. How is it stored?

This question will ask you to provide a missing option. Given the following SAS program: Which option needs to be added to wrap the labels to the next line whenever it encounters a...

The following SAS program is submitted once: Which procedure output will appear in test.html?

Given the following SAS log entry: What caused the error?

The following SAS program is submitted: If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted: What will be the value of NewVar when SAS writes the last observation?

After a SAS program is submitted, the following is written to the SAS log: What issue generated the error in the log?

Given the SAS data set WORK. PRODUCTS: The following SAS program is submitted: data WORK. REVENUE (drop=Sales Returns); set WORK. PRODUCTS (keep=ProdId Price Sales Returns); Revenu...

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char: The following SAS program is submitted: proc print data=WORK.ONE; where Num=con...

When SAS encounters a data when reading from a raw data file, which action will occur?