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 (OrigPassengers, TransPassengers) +0;run;What is the value of the TOTALPASSENGERS variable in the output data set?
Consider the data step:Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
Given the SAS data set PRICES:Prodid price producttype sales returnsK125 5.10 NETWORK 15 2B132S 2.34 HARDWARE 300 10R18KY2 1.29 SOFTWARE 25 53KL8BY 6.37 HARDWARE 125 15DY65DW 5.60 HARDWARE 45 5DGTY23 4.55 HARDWARE 67 2The 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; 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?
The following SAS program is submitted:data WORK.ACCOUNTING;set WORK.DEPARTMENT;length EmpId $6;CharEmpid=EmpId;run;If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?
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?
