资源描述：
《using_sas_views_and_sql_views》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、UsingSASViewsandSQLViewsLynnPalmer,StateofCalifornia,Richmond,CAABSTRACTortwoemployees.Byputtingthisknowledgeintoanorganizationallibraryofviews,morestaffcanactindependently,andstaffcanchangewithoutcrisis.Viewsareawayofsimplifyingaccesstoyourorganization’sdatabasewhilemaintaini
2、ngsecurity.Withnewandeasierwaystoaccessdata,moreusersareabletogettheirdatadirectlyfromVIEWSINSASCODEtheorganizationdatabase.Thisdataoftenrequiressomeknowledgeofthe"rules"forsummarizingandpresentingtheTherearethreetypesofSASdataviews:DATAstepinformation.Theserulesmaynotbereadil
3、yavailabletoorviews,PROCSQLviews,andSAS/ACCESSviews(viewknownbyallstaff.Additionally,databasestructurescanbedescriptors).SASdataviewsarethemembertype,VIEWcomplexanddifficulttonavigate.Onewaytomangedataandaredefinedasnativeorinterface.Nativeviewsaretheaccessistosetupviewsthatgo
4、vernhowthedataisextracted.viewscreatedinaDATAsteporwithPROCSQL.Viewscan,also,makeiteasiertoaccesscomplexdatastoredinInterfaceviewsarecreatedwithSAS/ACCESStoreadoradatabasebysummarizingthedatafortheuser.Youcancreatewritedatatoadatabase(DBMS)suchasDB2,ORACLE,SASviewsandSQLviewst
5、hataretransparenttoyouruserandorADABAS.FromVersion7forward,ithasbeenpossibleallowyoutomanagedataaccess.tocreatenativeviewsthatusetheUSINGLIBNAMEstatementandtherefore,areabletodirectlyinterfaceadatabase.BothnativeandinterfaceviewscanbeusedwithINTRODUCTIONDATAorPROCsteps.WhatAre
6、Views?SASDataViews:Aviewislikeastoredquery.Itcontainsnodata,butinsteadSASDATAstepviewstellSAShowtoprocessdatausingcontainscodethatdescribes,defines,orselectsstoreddatawhenthecodethatyouspecifyintheDATAstep.Onlyoneitisneeded.Thedatausuallyisinadatabase,howeveritcouldviewcanbecr
7、eatedinaDATAstepandtheviewnamebeinaSASdatasetorfile.ViewsarenamedandusedlikeamustmatchoneoftheDATAstepnames.Thistypeoftable,dataset,orfilewouldbeused.However,viewsareonlyviewcanonlyreadtheunderlyingdata.DATAstepviewscode.Theviewisasubsetorsupersetofthedatafromwhichitcangenerat
8、edatasetswhentheviewisexecuted.Aviewisiscreated.Theadvantageo
