资源描述:
《Save Time Today Using SAS Views》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、SUGI27AdvancedTutorialsPaper19-27SaveTimeTodayUsingSASViewsRobertRay,SASInstituteInc.,CaryNCABSTRACTVIEWBASICS:Inthistimeofexplodingdatavolumes,youroldfriendtheViewscanbecreatedusingPROCSQLortheDATAStep.SQLviewswereavailablefirst,butbothviewSASdataviewcanbemoreimportantthaneverasatoolto
2、reducetotaljobI/Oand,thereby,totaltime.ViewscanflavorshavebeenavailablesinceSASversion6.07.BothbecreatedinSASwitheitherSQLortheDATAStepandviewtypesstoretheintermediateresultsofpartialusedsinglyorincombination.SASdataviewscanbecompilationinspecialfiletypes.Whenreferencedbyausedasonemightus
3、eUnix'pipes'tochainmultipledataclientprocedure,theviewmetadataisretrieved,manipulationstagestogetherwithoutinterveningI/O.compilationiscompleted,datasourcesareopenedandJudicioususeofthisestablishedtechnologycancutoutputbuffersareproducedandfedtotheclient,justasifexecutionreal-timesignific
4、antlyandbringyourcriticalaSASdatafilewasbeingreadfromdisk.Mostdatajobsbackintotheirtimewindows.Additionally,thisclientsareblissfullyunawarethattheirdataisbeingpaperwillbrieflydiscussthenew“pipes”featureofthecreatedontheflyonebufferatatime.multi-process(MP)SAS/CONNECTproduct..Bothviewtype
5、sdividethecompilationprocessacrosstheLOTSMOREDATA,NOMORETIME:definitionandexecutionphases,buttoadifferentdegree.DATAStepviewsaremorecompletewhentheyareWiththeexplosionofinformationflowingfromnewstoredeventothepointofopeningallreferenceddatasourcessuchastheInternet,it’snosurprisethatITsour
6、cestovalidatevariablereferences(moreonthisdepartmentsarefeelingthetime-to-solutionsqueezeforlater).ThismeansthataDATAStepviewislesslikelytotheirlargebusiness-criticalapplications.Thosebatchtimefailatexecutiontimeduetosyntacticerrorsbutalsoisawindowsseemtobegettingsmallereveryyear.Ifyourbi
7、tlessflexible.arefeelingthepinch,itmaybetimetotakeacarefullookatyourSASapplicationstoseeifyoucanusesomeoldSQLviews,ontheotherhand,gothroughonlyabasictoolssoshavesignificanttimefromyourlarge-datajobs.syntacticcheckbeforethequerytreerepresentationisSASdataviews,bothDA