Given the SAS data set WORK.ORDERS:The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".Which of the following statement will correctly create the value and assign it to ship_note?
After a SAS program is submitted, the following is written to the SAS log:105 data WORK.JANUARY;106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);107 if Month='JAN' then output WORK.JANUARY;108 Sales=Cost * Quantity;109 drop=Month Quantity Cost;-----ERROR 22-322: Syntax error, expecting one of the following: !,!!, , *, **, +, -,, <=, <>, =, >, >=,AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,NOTIN, OR, ^=, |, ||, ~=.110 run;What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?
Read the table:Given the SAS data set SASUSER.HOUSES:Obs style bedrooms baths price sqteet street1 CONDO 2 1.5 80050 1200 MAIN2 CONDO 3 2.5 79350 1300 ELM3 CONDO 4 2.5 127150 1400 OAK4 CONDO 2 2.0 110700 1100 FIFTH5 TWOSTORY 4 3.0 107250 2100 SECOND6 TWOSTORY 2 1.0 55650 1600 WEST7 TWOSTORY 2 1.0 69250 1450 NORTH6 TWOSTORY 4 2.5 102950 2000 SOUTHThe following SAS program is submitted:proc report data = sasuser.houses nowd headline;column style price;where price It 100000;<insert DEFINE statement here>define price / mean width = 9 format = dollar12.;title;run;The following output is desired:style price------- ------CONDO $79,700 -TWOSTORY $62550 -Which DEFINE statement completes the program and produces the desired output?
Consider the following data step:The computed variables City and State have their values assigned using two different methods, aRETAIN statement and an Assignment statement. Which statement regarding this program is true?
Given the SAS data set WORKAWARDS:WORK.AWARDS -FNAME POINTS MONTH ------------ ------------ -----------Amy 2 4 -Amy 1 7 -Gerard 3 3 -Wang 3 3 -Wang 1 12 -Wang 1 8 -The following SAS program is submitted:proc sort data = work.awards;by descending fname points;run;How are the observations sorted?
The following SAS program is submitted:data WORK.COMPRESS;ID = "˜1968 05-10 567';NewID = compress (ID, "-");run;What will the value of NewID be in the WORK.COMPRESS data set?
