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?   Answer is 100, why not 200?? Please help, thanks!!! ... View more

data brothers.three; set brothers.one; set brothers.two; run;   After researching, still don't quite understand why var X in Brother Three is only 2 & 4 and data 5,Karl is gone as well, new to SAS, please help!thanks ... View more

The following SAS program is submitted: libname temp ‘SAS data library’; data temp.sales; merge temp.sales work.receipt; by names; run; The input data files are sorted by the NAMES variable:   Happen to see this question, so is it okay to have same name for SAS data set that is referenced for both read and write operations?? ... View more

How many observations are in data set WORK.ALL after submitting the program?   Why is the answer 2 and not 3? I thought the only observation omitted is the empid=1864 and empid=3567? Please help, thanks!!!! ... View more

Given the SAS data set SASDATA TWO: SASDATA TWO XY ---- 52 31 56 The following SAS program is submitted: data sasuser.one two sasdata.three; set sasdata two; if x = 5 then output sasuser.one; else output sasdata two; run; What is the result?   Not sure why the answer is  A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations   Thanks! ... View more

Given the contents of the raw data file TYPECOLOR.DAT: Why is the Ans is Type=daisy, Color=      Please help, thanks! ... View more

Given the SAS data set WORKAWARDS: WORK.AWARDS FNAMEPOINTSMONTH ---------------------------------- Amy24 Amy17 Gerard33 Wang33 Wang112 Wang18 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run; How are the observations sorted?   Ans is  ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24 Just want to check by descending var1 var2 var3, does it mean only put var 1 in descening order then var2 and var 3 remain as ascending or it means descending var1, within that descend var2, within that descend var3 again? Thanks!! ... View more