SAS認證考試資料講解

1、Good is good, but better carries it.精益求精，善益求善。SAS認證考試-SASGlobalCertificationprogram一、SASCertifiedBaseProgrammerforSAS9Credential1,OverviewTheSASCertifiedBaseProgrammerforSAS9credentialistheidealcertificationforthoserelativelynewtoSASprogrammingornewtoSAScertification.Itisalsotheprinciplecertificatio

2、nforotheradvancedcertificationsavailablefromSAS.CandidatesshouldbefamiliarwiththeenhancementsandnewfunctionalitythatareavailableinSAS9.2.SuccessfulcandidatesshouldhaveexperienceinprogramminganddatamanagementusingSAS9andshouldbeableto:importandexportrawdatafilesmanipulateandtransformdatacombineSASdat

3、asetscreatebasicdetailandsummaryreportsusingSASproceduresidentifyandcorrectdata,syntaxandprogramminglogicerrors.ToearnthiscredentialyoumustpasstheSASBaseProgrammingforSAS9Exam2,ExamcontentRequiredExamCandidateswhoearnthiscredentialwillhaveearnedapassingscoreontheSASBaseProgrammingforSAS9Exam.Thisexa

4、misadministeredbySASandPrometric.70multiple-choicequestions(mustachievescoreof65%correcttopass)2hourstocompleteexamUseexamIDA00-211;requiredwhenregisteringwithHYPERLINK/sasPrometric.Examtopicsinclude:AccessingDataUseFORMATTEDandLISTinputtoreadrawdatafiles.UseINFILEstatementoptionstocontrolprocessing

5、whenreadingrawdatafiles.UsevariouscomponentsofanINPUTstatementtoprocessrawdatafilesincludingcolumnandlinepointercontrols,andtrailingcontrols.CombineSASdatasets.AccessanExcelworkbook.CreatingDataStructuresCreatetemporaryandpermanentSASdatasets.CreateandmanipulateSASdatevalues.Exportdatatocreatestanda

6、rdandcomma-delimitedrawdatafiles.ManagingDataInvestigateSASdatalibrariesusingbaseSASutilityprocedures.SortobservationsinaSASdataset.UseassignmentstatementsintheDATAstep.ModifyvariableattributesusingoptionsandstatementsintheDATAstep.Accumulatesub-totalsandtotalsusingDATAstepstatements.UseSASfunctions

7、tomanipulatecharacterdata,numericdata,andSASdatevalues.UseSASfunctionstoconvertcharacterdatatonumericandviceversa.ProcessdatausingDOLOOPS.ProcessdatausingSASarrays.Validateandcleandata.GeneratingReportsGeneratelistreportsusingthePRINTprocedure.GeneratesummaryreportsandfrequencytablesusingbaseSASproc

8、edures.Enhancereportsthroughtheuseofuser-definedformats,titles,footnotesandSASSystemreporting.GenerateHTMLreportsusingODSstatements.HandlingErrorsIdentifyandresolveprogramminglogicerrors.Recognizeandcorrectsyntaxerrors.Examineandresolvedataerrors.3,ExamPreparationExperienceisacriticalcomponenttobeco

9、mingaSASCertifiedProfessional.Thebelowdiagramillustratestrainingoptionsavailabletohelpyouprepareforthiscredentialsrequiredexamination.Besuretocheckyourlocalcountryspreparationbundleswhichoftenincludeanexamvoucher.ViewtheHYPERLINK/certify/creds/samples.htmlsamplequestionsforthisexam.Forcertificationc

10、andidatesintheU.S.andCanada:HYPERLINK/certify/discounts/bpc.htmlBestValuedeals!Saveupto50%Allyouneedtoprepareinonepackage-atonelowprice!Packagesdesignedtosuiteverylearningstyle:classroom,e-Learning,orbook4,ExamRegistrationRegistrationOptionsOnlineVisitHYPERLINK/sast_blank/sas.Followtheseeasystepsonc

11、eonthesite:SelectthefirstboxScheduleaTestSelectScheduleanAppointmentChooseyourcountryandstate/provinceifapplicableInsurethatSASInstituteisselectedasyourclientandprogramSelectyourdesiredSAScertificationexamReviewavailabletestingsitesandselectScheduleAppointmentFirst-timeregistrationwithPrometricrequi

12、resa24-hourwaitingperiodbeforethecandidatecanscheduleanexamonline.CandidateswhoareregisteringforanexamforthefirsttimewillreceiveanemailconfirmationfromPrometricwithin24hourstobegintheonlineschedulingprocess.CandidateswhohavepreviouslytestedwithPrometricandhavetheirPrometricIDorhavepreviouslyregister

13、edonlinecanscheduletheirexamonlineimmediately.TelephoneByphoneintheU.S.andCanada:888-895-5819between7:00a.m.and7:00p.m.CSTByphoneoutsidetheU.S.andCanada,visitHYPERLINK/sast_blank/sasforalistofexamregistrationphonenumbers.TestingLocationsTofindyournearesttestingcenter,visitHYPERLINK/sast_blank/sas.In

14、formationrequireduponregistrationPleasebepreparedtoprovidethefollowinginformationtoPrometricwhenregistering:Firstandlastname-Pleaseprovideyournameasyouwouldlikeittoappearonyourcertificate.Prometricassignsauniqueidentificationnumbertoeachcandidate.PleaseusethisIDnumbereachtimeyouscheduleanexamwithPro

15、metricorSAS.Mailingaddress-Pleaselisttheaddresstowhichallcorrespondenceshouldbemailed.Companyname-Ifyouhavelistedyourbusinessaddress,pleaseincludeyourcompanynametoensureappropriaterouting.E-mailaddress-Forthelatestprogramupdates,emailisthemostefficientandeffectivemeansofcontactingyou.Contactphonenum

16、bersExamnumberandtitleTestingcenterpreference-Tofindyournearesttestingcenter,visitHYPERLINK/sast_blank/sas.Methodofpayment(creditcard(AmericanExpress,Mastercard,andVisa),vouchers)Paymentoptionsmayvarybycountry.Ifyouraddresshaschangedsinceyoulastregisteredforanexam,pleasecontactPrometrictoupdateyourd

17、emographicinformation.ExamPricingWithinNorthAmericaandIndia,thecostassociatedwithanexamofferedthroughPrometricisUS$180.ThesameinChina.Certificationexampricesaresubjecttochange.Insomecountries,differentpricingandadditionaltaxesmayapply.PleasevisitHYPERLINK/sast_blank/sasforexampricinginyourcountry.Fa

18、culty,staff,andfull-timestudentsofdegree-grantinginstitutionsareeligibleforadiscountonSASCertificationexams.CandidatesintheUnitedStatesandCanadareceiveaHYPERLINK/certify/discounts/50%discount.InternationalcandidatesshouldcontactHYPERLINK/offices/intro.htmlyourlocalofficefordiscountinformation.Cancel

19、lationPolicyCandidatesmaycancelorrescheduleexamsatnochargeiftheycontactthePrometricRegionalServiceCenterby6:00p.m.ETatleastonebusinessdaypriortothescheduledexamdate.Candidateswhodonotappearforthetestorcancellessthanonebusinessdaybeforetheexamwillnotreceivearefund.RetakePolicyCandidatesmayattempteach

20、SASCertifiedProfessionalexamuptothreetimesinatwelve-monthperiod,waitingaminimumof30calendardaysbetweenattempts.Examsthatdonotcomplywiththeretakeexaminationpolicywillbeconsideredinvalid.Examretakesrequirepaymentofthefullexamfeeandarenotdiscounted.CandidateAgreementCandidatesareencouragedtoreviewtheHY

21、PERLINK/certify/reg/cand_agmt.pdfSASInstituteInc.CertificationProgramAgreementpriortotheirexamday.5,ExamDayWhattobring:Certificationcandidatesarerequiredtoprovidetwoformsofidentificationatthetestingcenter,includingonephotoidentificationsuchasadriverslicenseoravalidpassport.Bothformsmustdisplaythecan

22、didatessignature.Arrivingatthetestcenter:Candidatesshouldplantoarrive15minutesbeforetheirscheduledexamtime.Candidatesarrivingmorethan15minuteslatearenotguaranteedexamavailabilityorarefund.Referencematerials:Tomaintainthesecurityofthetestenvironment,candidatesarenotpermittedtobringreferencematerialso

23、fanykindintothetestingcenter.Personalitems:Theonlyitemsallowedinthetestingareaareyouridentification.Pleaseleaveanybackpacks,laptops,briefcasesandotherpersonalitemsathome.Ifyouhavepersonalitemsthatcannotbeleftbehind(suchaspurses),thetestingcentermayhavelockersavailableforuse.Nocameras,cellphones,audi

24、oplayers,orotherelectronicdevicesareallowedduringexamsessions.PleaserefertoHYPERLINK/TestTakers/FAQs/Regulations.htmt_blankPrometricTestingCenterRegulationsformoreinformation.Allnoteswillbecollectedattheendoftestingandnomaterialmayberemovedfromthetestingevent.6,AftertheExamScoreReportYouwillreceivea

25、nimmediatepass/failscoreuponcompletionofyourexamattemptatyourtestingfacility.Thescorereportwilldisplaythepercentageofitemsineachsectionthatyouansweredcorrectlyfortheyourexam.Pleasenote:Thesesectionscoresarecalculatedonapersectionbasisandcannotbeusedindeterminingyourtotalscore.Theyareprovidedtoyoufor

26、descriptivepurposesonly.WelcomeE-mailandCertificateIfyouhavepassedyourexamandmetallrequirementsforthiscredential,youwillreceivetwoe-mails.Onee-mailwillcontainyourlogoaccessandwelcomeinformation.Theseconde-mailwillincludeapdfcopyofyourcertificatewhichyoucanprintatanytime.Thesee-mailswillbesenttothee-

27、mailaddressyouprovidedtoPrometricatexamregistration.Pleaseallowatleasttwoweeksfromyourexamdatetoreceiveyoure-mails.DirectoryListingUponreceiptofyourcredentialsfromSAS,yournamewillbeaddedtotheSASCertifiedProfessionalDirectoryListing.Thisprocesscantakeuptooneweekafteryourcertificateisawarded.Ifyoudono

28、twishforyournametoappearintheHYPERLINK/certify/directory/index.hsqlSASCertifiedProfessionalDirectorylisting,youmaychosetobeexcludedatthetimeofexamregistration.二、SASCertifiedAdvancedProgrammerforSAS9Credential1,overviewTheSASCertifiedAdvancedProgrammerforSAS9credentialrepresentstheupperechelonofSASpr

29、ogrammers.ThosewhoearntheadvancedprogrammingcredentialhavedemonstratedahighlevelofproficiencyinSASprogrammingexpertiseandareamuchsoughtaftercommodityintheglobaljobmarket.ASASadvancedprogrammershouldhavecurrentSASprogramminganddatamanagementexperience.Successfulcandidatesshouldbeskilledintaskssuchasu

30、singadvancedDATAstepprogrammingstatementsandefficiencytechniquestosolvecomplexproblemswritingandinterpretingSASSQLcodecreatingandusingtheSASMACROfacility.CandidatesfortheSASAdvancedProgrammerforSAS9examshouldbefamiliarwithenhancementsandnewfunctionalitythatareavailableinSAS9.2.Thecandidatemustcurren

31、tlyholdaSASCertifiedBaseProgrammerforSAS9credential.2,examcontentRequiredExamCandidateswhoearnthiscredentialwillhavetakenandearnedpassingscoresofthefollowingtwoexams:1)SASBaseProgrammingExamforSAS9,and2)SASAdvancedProgrammingExamforSAS9.ThisexamisadministeredbySASandPrometric.63multiple-choicequesti

32、ons(mustachievescoreof65%correcttopass)2hourstocompleteexamUseexamIDA00-212;requiredwhenregisteringwithHYPERLINK/sasPrometric.Examtopicsinclude:AccessingDataUsingSQLGeneratedetailreportsbyworkingwithasingletable,joiningtables,orusingsetoperatorsintheSQLprocedure.Generatesummaryreportsbyworkingwithas

33、ingletable,joiningtables,orusingsetoperatorsintheSQLprocedure.Constructsub-queriesandin-lineviewswithinanSQLprocedurestep.ComparesolvingaproblemusingtheSQLprocedureversususingtraditionalSASprogrammingtechniques.AccessDictionaryTablesusingtheSQLprocedure.MacroProcessingCreateanduseuser-definedandauto

34、maticmacrovariableswithintheSASMacroLanguage.AutomateprogramsbydefiningandcallingmacrosusingtheSASMacroLanguage.Understandtheuseofmacrofunctions.Usevarioussystemoptionsthatareavailableformacrodebugginganddisplayingvaluesofuser-definedandautomaticmacrovariablesintheSASlog.Createdata-drivenprogramsusi

35、ngSASMacroLanguage.AdvancedProgrammingTechniquesDemonstratetheuseofadvanceddatalook-uptechniquessuchasarrayprocessing,hashobjects,formats,andcombining/mergingdata.ReduceI/ObycontrollingthespacerequiredtostoreSASdatasetsusingcompressiontechniques,lengthstatements,oreliminatingvariablesandobservations

36、.ReduceprogrammingtimebydevelopingreusableSASprogramswhichincorporatedatastepviews,DATAstepsthatwriteSASprograms,andtheFCMPprocedure.PerformeffectivebenchmarkingbyusingtheappropriateSASSystemoptionsandinterpretingtheresultingresourceutilizationstatistics.DeterminetheresourcesusedbytheSORTprocedurean

37、davoidunnecessarysortsbyusingappropriateindexes,datasetoptions,BYstatementoptions,andtheCLASSstatement.IdentifyappropriateapplicationsforusingindexesandcreatethemusingtheDATAstep,theDATASETSprocedure,ortheSQLprocedure.ComparetechniquestoeliminateduplicatedatausingtheDATAstep,theSORTprocedure,andtheS

38、QLprocedure.2,exampreparation.ExperienceisacriticalcomponenttobecomingaSASCertifiedProfessional.Thebelowdiagramillustratestrainingoptionsavailabletohelpyouprepareforthiscredentialsrequiredexamination.Besuretocheckyourlocalcountryspreparationbundleswhichoftenincludeanexamvoucher.FormoreinformationCon

39、tacttheSASGlobalCertificationProgramatHYPERLINKmailto:certificationcertificationor800-333-7660.三、SASCertifiedPlatformAdministrator9CredentialThiscredentialisdesignedforthoseITadministratorsresponsibleforinstalling,configuring,administeringandmaintainingtheplatformforSASBusinessAnalytics1，OverviewThe

40、SASCertifiedPlatformAdministratorforSAS9credentialistheidealcertificationforthosewhohavetheskillsandknowledgenecessaryfortheadministrationoftheplatformforSASBusinessAnalytics.Successfulcandidatesshouldbeableto:SecuretheSASconfigurationoneachservermachineCheckstatusandoperateserversMonitorserveractiv

41、ityandadministerloggingEstablishformal,regularlyscheduledbackupprocessesAddusersandmanagetheiraccessEstablishconnectivitytodatasourcesSetupandsecuremetadatafolderstructuresAdministerrepositoriesandmovemetadataToearnthiscredential,youmustpasstheSASCertifiedPlatformAdministrationforSAS9exam.2，ExamCont

42、entRequiredExamCandidateswhoearnthiscredentialwillhaveearnedapassingscoreontheSASPlatformAdministrationforSAS9exam.ThisexamisadministeredbySASandHYPERLINK/sast_blankPrometric.65multiple-choicequestions(mustachievescoreof69%correcttopass)2hourstocompleteexamUseexamIDA00-250;requiredwhenregisteringwit

43、hHYPERLINK/sasPrometric.Examtopicsinclude:SecuringtheSASconfigurationSecureaSASplatformconfiguration.CheckingtheStatusandOperationofSASServersManagemetadatarepositories.IdentifythepropertiesandfunctionalityofSASservers.ValidateaSASserver.Monitoring,Logging,andTroubleshootingSASServersMonitorSASserve

44、rs.AdministerSASserverloggingandmodifyloggingconfigurations.TroubleshootbasicSASserverissues.BackingUptheSASEnvironmentBackuptheSASenvironment.RestoretheSASenvironment.AdministeringUsersManageconnectionprofiles.Manageroles.Registerusersandgroupsinthemetadata.Giveusersaccesstoprocessingserversanddata

45、servers.Determinewhentostorepasswordsinthemetadata.AdministeringDataAccessRegisterlibrariesandtablesinthemetadata.Updatetablemetadata.Pre-assignalibrary.Troubleshootdataaccessproblems.UsethemetadataLIBNAMEengine.SecuringMetadataIdentifyhowthemetadataauthorizationlayerinteractswithothersecuritylayers

46、.Identifywhere,how,andtowhommetadatapermissionsareassigned.Determinetheoutcomeofmetadataauthorizationdecisions.Usemetadatapermissionstosecuremetadata.CreateanduseAccessControlTemplates.MovingMetadataPromotemetadataandassociatedcontent.3，ExamPreparationTherecommendedpreparationfortheSASPlatformAdmini

47、stration9.2examisbasedontheHYPERLINK/edu/schedules.html?ctry=us&id=329SASPlatformAdministrationFastTrackcourse.Whilenoexamquestionswillbedrawnverbatimfromthecourseorcourseexercises,thecoursewillprovidecandidateswithafoundationfromwhichtoapplytheknowledgeandskillsnecessaryfortheexam.Experienceisacrit

48、icalcomponenttobecomingaSASCertifiedProfessional.Thebelowdiagramillustratestrainingoptionsavailabletohelpyouprepareforthiscredentialsrequiredexamination.Besuretocheckyourlocalcountryspreparationbundleswhichoftenincludeanexamvoucher.FormoreinformationContacttheSASGlobalCertificationProgramatHYPERLINK

49、mailto:certificationcertificationor800-333-7660.四、SASCertifiedPredictiveModelerusingSASEnterpriseMiner5or6CredentialThiscredentialisdesignedforSASEnterpriseMineruserswhoperformpredictiveanalytics.1,OverviewIntodaysglobaleconomybusinessesdependonadvancedanalyticstogivethemacompetitiveadvantage.Thedev

50、elopmentandimplementationofmodelstopredicttargetedoutcomesisquicklybecomingastapleoftodaysmostsuccessfulcompanies,causingthisperformance-basedcredentialtobeoneofthefastestgrowingcertificationsavailablefromSAS.Acandidateforthisexamshouldhavetheabilityto:preparedatabuildpredictivemodelsassessmodelssco

51、renewdatasetsimplementmodels.Duringthisperformance-basedexamination,candidateswilluseSASEnterpriseMinertoperformtheexaminationtasks.ItisessentialthatthecandidatehaveafirmunderstandingandmasteryofthefunctionalitiesforpredictivemodelingavailableinSASEnterpriseMiner5or6.Candidatesforthisexaminationcane

52、lecttocompletethisexaminationusingtheSASEnterpriseMiner5.3or6.1interface.*Toearnthiscredential,youmustpasseitherthePredictiveModelingusingSASEnterpriseMiner5examorPredictiveModelingusingSASEnterpriseMiner6exam.2,ExamContentRequiredExamCandidateswhoearnthiscredentialwillhaveearnedapassingscoreonthePr

53、edictiveModelingUsingSASEnterpriseMiner5orthePredictiveModelingUsingSASEnterpriseMiner6Exam.61multiple-choicequestions(mustachievescoreof70%correcttopass)3hourstocompleteexamCandidateswilluseSASEnterpriseMinertoperformthisexamandwillselectthesoftwareinterfacetheyprefertouse(SASEnterpriseMiner5.3or6.

54、1)ExamofferedexclusivelyatSAStrainingcentersExamtopicsinclude:DataPreparationStartinganewEnterpriseMinerprojectMissingvaluesInitialdataexplorationincludingdatavisualization/measurementlevelsorscales/variablereductionTransformation/recoding/binningPredictiveModelsDatasplitting/balancing/overfitting/o

55、versamplingLogistic/linearregressionArtificialneuralnetworks(MLP)DecisiontreesVariableimportance/oddsratioProfit/loss/priorprobabilitiesModelAssessmentComparisonbetweenmodels/liftchart/ROC/profit&lossAssessmentofasinglemodelScoringandImplementationScoreadatasetModelimplementation3,ExamPreparationFor

56、thosenewtopredictivemodelingornewtoSASEnterpriseMiner,thefollowingcoursewillenableyoutodevelopyourskillsintheareaofdataminingandpredictivemodelingaswellastoprepareforthecertificationexam.HYPERLINK/edu/schedules.html?ctry=us&id=857t_blankAppliedAnalyticsUsingSASEnterpriseMiner(theseareavailableinthet

57、rainingcentersaswellasLiveWebande-Learning)ExperienceisacriticalcomponenttobecomingaSASCertifiedProfessional.Thebelowdiagramillustratestrainingoptionsavailabletohelpyouprepareforthiscredentialsrequiredexamination.Besuretocheckyourlocalcountryspreparationbundleswhichoftenincludeanexamvoucher.Forcandi

58、dateswithconsiderableexperienceinpredictivemodelingwithSASEnterpriseMiner,thefollowingpublicationprovidesasolidoverviewofthetypesofconceptsandskillsfoundintheexamination:HYPERLINK/apps/pubscat/bookdetails.jsp?pc=58519PredictiveModelingwithSASEnterpriseMiner:PracticalSolutionsforBusinessApplications.

59、SeeinformationonHYPERLINK/certify/creds/prep.htmlbundledtrainingoptions.FormoreinformationContacttheSASGlobalCertificationProgramatHYPERLINKmailto:certificationcertificationor800-333-7660.4,ExamRegistrationRegistrationOptionsOnlineRegisterfortheHYPERLINK/edu/schedules.html?ctry=us&id=660PredictiveMo

60、delingUsingSASEnterpriseMiner5exam.RegisterfortheHYPERLINK/edu/schedules.html?ctry=us&id=1005PredictiveModelingUsingSASEnterpriseMiner6exam.TelephoneByphoneintheU.S.:800-333-7660ExamPricingIntheUnitedStates,thecostassociatedwiththisexamisUS$250.Certificationexampricesaresubjecttochange.Faculty,staff