Given the following raw data records in DATAFILE.TXT:Given the following raw data records in DATAFILE.TXT: Given the above raw data records in DATAFILE.TXT: The following is the ouput of the data. Why is 'track' being cut off?Is it because there is no @ at input step to suppress it from reading the next data into same line?Thanks! ... View more

The following SAS program is submitted: footnote1 ‘Sales Report for Last Month’; footnote2 ‘Selected Products Only’; footnote3 ‘All Regions’; footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’; run;   Which footnote(s) is/are displayed in the report? A. All Products B. Sales Report for Last Month All Products C. All Products All Regions All Figures in Thousands of Dollars D. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars Answer: B Why footnote 3 and 4 disappear whereas footnote 1 stays? Thanks! ... View more

The following SAS program is submitted: data work.new; length word $7; amount = 4; it amount = 4 then word = ‘FOUR’; else if amount = 7 then word = ‘SEVEN’; else word = ‘NONE!!!’; amount = 7; run; What are the values of the AMOUNT and WORD variables in SAS dataset work.new?   A. amount word 4 FOUR B. amount word 4 NONE!!! C. amount word 7 FOUR D. amount word 7 SEVEN   The answer is C, I do not quite understand why. ... View more

The following SAS program is submitted:   Data WORK.SALES; do Year=1 to 5; do Month=1 to 12; X+1; end; end; run;   How many obersevations are written to the WORK.SALES data set?   Answer is 1. Is it because there is no 'output' stated in the code thats why it did not give individual value for each month, the 1 observation is the sum of individual months up to 5 years? Please help, thanks! ... View more

Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY -------- ------------ Innis60000 Jolli50000 Ellis55000 Liu45000 The following SAS program is submitted: proc print data = employees; where name like ‘_i%’; run; What is contained in the output? A. Liu only B. Innis and Ellis only C. Innis, Ellis, and Liu only D. Innis, Jolli, Ellis, and Liu   Why is the answer "A"?? I do not actually understand the condition name like '_i%'. Thanks! ... View more

Given the raw data file EMPLOYEE: ----I----1 0---I----20---I----30 Ruth 39 11 Jose 32 22 Sue 30 33 John 40 44 The following SAS program is submitted: data test; infile ‘employee’; input employee_name $ 1-4; if employee_name = ‘Ruth’ then input idnum 10-11; else input age 7-8; run; What value does the variable IDNUM contain when the name of the employee is “Ruth”?   Ans is 22? I do not understand why. Thanks ... View more

Given the SAS data set PRICES: PRICES Prodid priceproducttypesalesreturns K1255.10NETWORK152 B132S 2.34HARDWARE30010 R18KY2 1.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455 DGTY23 4.55HARDWARE672 The following SAS program is submitted: data hware inter cheap; set prices(keep = productype price); if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output inter; if price le 5.00; run;   How many observations does the HWARE data set contain? Ans is 4.    I know there are 4 obs with Hardware, but will the "if price le 5.00" affects the answer? causing only those hardware with price le 5.00 get selected and change the answer to 2 observations. Please help, thanks!!! ... View more

  data temp; test = 'X'; select(test); when('Y') Name = 'Ste'; when('X') Name = 'Steve'; when('Z') Name = ' '; end; run; What is the output? A) Steve; B) Ste C) Missing (character missing value) D) SYNTAX ERROR The answer is B which I do not understand, Isn't only X fulfiled the criteria so it should output "Steve"? Thanks so much for helping! ... View more