SASbase考試必備70真題

1、tted:Y;r;ll=0;ate;de_;run;The SAS data setrr: AILE.TXT:|10-|20-|30ntTina,MAR,29,1nted:$13$25$14$27 .nt$26$17$29$11$23$15$18$12$13.nt$29$14$19$27$20t?A.RS; s $ 7;ILE.TXT dsd;$;s $;s $;s $;s $;s $;s $;- r6.;run;RS;run;B.RS;s $ 7; ver;$;=FEB- r6.;run;RS;run;C.RS;hs $ 7;ILE.TXT dlm=,;$ ;f - r6.;run;RS;r

2、un;D.RS;s $ 7;ILE.TXT dsd ;$;s $;s $;Week- r6.; run;RS;run;r: CwoEASTWESTtted:ns.xls;heet?;run;$;run; e;run; $n;run;r: Dtted:INFO;Day=01 ;Yr=1960 ;X=mdy(Day,01,Yr) ;run;ble X?0960ng vsion.r: Agh 10 are to be read from the mer.txt?mer.txt 1-10;mer.txt stop10;mer.txt obs=10;mer.txt stop=10;r: Ca Sen t

3、o the SAS log:RY;old Cost);RY;old;122wing: !,!, &, *, *, +=, , =, , =,AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG , OR, =, |, |, =.106 run;s in the LOG?);ct Sar: DXPLr: Dtted:data WORK.);ll=0; *12);run;ment is true?A. Ttmen Y data set.Y data set.r: Cam is sub tted:L;Cost=$20,000; unt=.10*Cost;run;

4、t?en to the SAS log.ng.en to the SAS log.ic data.en to the SAS log.r: C 因為有一個 $符號am:t;age plow-12 =Pre-Teen13-high = Teen;run;t;Sex Age;p.;run;tots:tNum MeanFPre-Teen351.359.8Teen656.566.5MPre-Teen457.364.8Teen662.572.055.863.059.766.8c=1; c=1 ;datc=1;c=1;r: CJANFEBMARstta qtr1.xls; s=3;me jan feb m

5、ar qtr1.xls;ook?=(jan,feb,mar);r: Atted:data WORK.TEST;);- unt3;run;ed?unt3nts3r: Ager:A.S;tate,2, );al; run;B.data WORK.TES ger;S;tate,2, );al; run;C.S;tate,2, );al;run;D.ger;S;tate,2, );al; run;r: cR_?n.tion. ment.lly dro ed.r: Dtted:INFO;2005d;=day(x);(x);Year=year(x);run;r, and Year?cter.ic.cter

6、.s.ofDr: Bwing data step:data WORK.GEO;ines;City $20.;=OK;thenal;es then=CA;rn;ines;es rrun;in?A. CnrnrnrnB.nrnrnrC.n alrnrnD.City nal rnr: Aatics in aR_?DATA step.ed.s in the DATA step.C. The _Er: Ci Char:WORK.ONENum Char1 233 231 77tted:data=WORK.ONE;Num=1;run;t?A.Num Char1 23B.Num Char1 231 77C.N

7、um Char1 233 231 77ated.r: Dt of 7.;tted:run;URE;Fee Cnt7.2;STAT;Fee/100;/100;et?t of 9. at of 7.nt7.2 nt7.2 t for Lo Fee.r: CCTS:ns15ORrun;MENT255OR12515OR4553MENT672tted:ING 300 10CTS;GT 30;OR;in?A. 1B. 2C. 3D. 6r: Bry?nts lib=WORK run; nts lib=WORK.all;run; run; ; run;r: cment?n_;n_;n_;n_r: Cds:|

8、10-|20-|30 * 12/29/1970*10el*6dated:4015 10el . 6 in the raw data?A.yees;run;ion dlm=*;run;B.yees;ion dsd=*;datC.yees;run;ion dlm dsd;run;D.yees;ion dlm=* dsd;r:Dwing code:obs=5 obs=15);Sex=M;run;A. 11B. 15r: DA. proc sort out=Erun;B.run;C.run;D. proc sortrun;r: BTemp1 May7515 May70ayed?rary SAS dat

9、a set?RT;RT;RT;RT;15June803June762July8514July89tted:Day;run;run;ct?A.Temp12July85214July8933June76415June8051May75615May7B.ObsDayTemp11May7522July8533June76414July89515May70615June80C.Temp11May75215May7033June76415June8052July85614July89D.Temp115May7021May75315June8043June76514July8962July85r: Cthe

10、 SAS data set WO00156208ed:nes the data?A.)re;(in=_b);if _a and _b;run;- 00;B.re;)tted:if _a and _b;- 00; run;C.re;WORK.P(in=_b);if _a and _b;- 00; run;D.re;(in=_b);if _a and _b;- 00; run;r: C data WORK.INFO;ILE.TXT;ny $20. 25 St30 Year;30 City Year;es;run;tion of the DATA step?A. 1B. 2C. 3D. 4r: Aa

11、yed in the SAS Log:y in line 4 15-23.RULE:+1-+2+3+4+5-1954 33R_=1_N_=4h was 33.yees.dat.h was 33.bles.What does it mean?B. An ey.y.n.y.r: BILE.TXT:|10-|20-|30alltted:O;-3 $ 10;ILE.TXT dlm=,;3 $; run;data=WORK.SPOR O; run;am?A.3sallrB.3sallC.Spor 3srD.3s2 Bil allr: Cwing data step:data WORK.NEW; set

12、WORK.OLD;+1;run;ble is true?ment. Whtion. tion. le time.le time.r: Ctted:data WORK.TEST;S;wn; run;n?2wn)r: Bd?ogB. in a mery ryr: AogTA.TWO:5 23 15 6tted:TA.TWO;if X eq 5 thenER.ONE;ER.TWO;t;run;t?A.nsnsnsB.nsnsnsC.nsnsdata set WORK.OT nss.r: AYEE.TXT:+10-+20-+30-Xing2 19 2004 ACCTBob5 22 2004 MKTG3

13、 14 2004 EDUCtted:YEE;YEE.TXT;Name $Date$;run;am?y10.y10.r: Bhasy t?A.ing Date;run;B.ing Date;run;C.data=SASU S;ing Date;run;D.S;ing Date;run;r: Bthe SAS data set WORK.ONE:X Y Z1 A 271 A 331 B 452 A 522 B 693 B 704 A 824 C 91 tted:data WORK.TWO;set WORK.ONE;by X Y;.Y;run;run;ced?A.X Y Z1 B452 A522 B

14、693 B704A824 C91B.X Y Z1A271B452A522B693 B704 A824 C91XC.YZ1A331B452A522B693 B704 A82ed in4C91dure f the DATA step.r: Brun;r: Btted:RS; ites3 $ 8gwaygwa)bles are ed.tted:frey);RS?CTS;Prod=1;(Prod LE 6);Prod + 1;end;run;oft data set?A. 6B. 7C. 8ic)r: B.txt:|10-|20-|30-|304-923-3721 14tted:S;sion;.txt

15、;de_run;ame?ame);ame);a ame;ame;r: Atted: data WORK.ONE;rk;Pos=find(Text,US,i,5);run;n to Pos?A. 0B. 1C. 2D. 12r: DS:Sed200920092009t.note, mer name.n.note?notmer);mer);wr mer);mer);r: Dam i tted:ER.TWOrun;ER.ONE;ed?B. 3 teededededr: Dtted:l file=c:test.cvs; data=WORK.ONE;ber;run;t?test.cvs that can

16、r: Cr.r.d by SAS.the SAS data set WORK.ONE:1.2 1.6tted:02.0data WORK.TWO;set WORK.ONE; =mean(of Rev:);run;A. 3B. 1.6C. 4.8s.r: Bdure:dureof reg ctctency| nt |Row Pct |+EAST| 2| 1| 1|4| 22.22 |11.11 |11.11 |44.44| 50.00 |25.00 |25.00 | 50.00 |33.33 |50.00 |+| 2| 2| 1|5| 22.22 |22.22 |11.11 |55.56| 40

17、.00 |40.00 |20.00 | 50.00 |66.67 |50.00 |+432944.4433.3322.22100.00nate the row ants?ntntstted:r: C48.The fdata WORK.TEST;drop City;ines;Name $ 1-14 / ss $ 1-14 / City $ 1-12 ;$2.;ines;y123 Main St.WInAve.New YorkNYoaCAin?A.Name Addy123 Main St.Ave.NYB.Ave.New YorkNYaC.Ave. NYin the data step.r: A 4

18、9.The fol tted:12); );12;do i=1 to 12;end;drop i;run;s. ?n. *).12.C. The kr: Athe SAS data set WORK.ONE:Id111 A158 B329 C644 Dand the SAS data set WORK.TWO:111 E538 F644 Gtted:data WORK.BOTH;set WORK.ONE WORK.TWO;by Id;run;n in SAS data set WORK.BOTH?111 AB.111EC.111AED.644DGr: Atted:run;am?ry.nts o

19、f the SAS data sets that arery.ry.r: Ddata sets.AME:Jill1864Jack2121Joan4698John5463EPT:cetingtted:data WORK.ALL;AME );run;A. 1B. 2);am?C. 3D. 5r: Btted:RY;Y;.De=0;ate);run;A. 0 ng ate t br: Bwing data step:data WORK.TEST;(obs=5);run;am is true?A.ated to 8ed.newieateded. ned one time, Sr: Dtted:INFO

20、;1960 D ;run;01960960te.r: D 注意 D 前面 有空格dure:durectctency| nt |Row Pct |+EAST| 2| 1| 1 | 4| 22.22 |11.11 |11.11 | 44.44| 50.00 |25.00 |25.00 | 50.00 |33.33 |50.00 |+| 2| 2| 1 | 5| 22.22 |22.22 |11.11 | 55.56| 40.00 |40.00 |20.00 | 50.00 |66.67 |50.00 |+432 944.4433.3322.22 100.00amt?de_run;s ct; ct

21、ct; ct;r: Dthe SAS data set WORK.ONE:N Be Date20102010tted:data WORK.TWO;set WORK.ONE; de_;run;ed, wher ay, . :WORK.TWODate Day2010 12010 4ble Day?Date)Date)Date)()r: Ba tted:t;t.= Less than 50K- er;o=1; t;ate;tt.yate=Date of Hire; run;yeeam fail?ng fment. dure.ment. mentr: COLOR.DAT:+10-+20-+30 wwing SAS pr tted:RS;over; hType $ 5$ 11;Type $;run;A. T w=wwr: DCTS:nsOR152ING300102 51.99EQUI MENT255OR12515OR455MENT672tted:data WORK);ns);ns);run;in?t;=1;=2;=2;=2;A. 2B. 3C. 4D. 6r: Ader the data step: data WORK.TEST;1.csv dsd;=2;run;D. both A or C will work.r: Atted:e_e