sas programming advanced techniques

《sas programming advanced techniques》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、1.1IntroductionofCourseTopics1-31.1IntroductionofCourseTopicsGeneralBusinessScenarioInternationalAirlineshasseveraldatafilesthatmustbemanipulatedbeforetheycanbeusedforreportproduction.Theto-dolistincludestheitemsonthefollowingslides:continued...3...GeneralBusinessScenario

2、¢appending¢combining−rawdatafiles−threeSASdatasets−SASdatasetswithoutcommonBYvariablesDateExpensesOriginDestination02DEC199958907RDULHR03DEC1999108543RDULHR−asummarydataset04DEC199921963RDULHR05DEC199931517RDULHR06DEC1999105682RDULHR07DEC199966992RDULHR08DEC199992873RDULH

3、Rwithadetaildataset09DEC199959560RDULHR10DEC199941096RDULHR11DEC199910272RDULHR12DEC199935121RDULHR13DEC199965836RDULHR14DEC199973350RDULHR−asmalldatasetwith15DEC199958539RDULHR16DEC199964191RDULHR17DEC1999116839RDULHR18DEC199982369RDULHRalargedataset19DEC1999109908RDULHR

4、20DEC19992439RDULHR21DEC199936700RDULHRExpensesOriginDestinationDateDateClassBusinessEconomyProfitAirportCityAirportName12DEC199935121RDULHR13DEC199965836RDULHR58907RDULHR02DEC199902DEC199919200316107965071553London,EnglandHeathrowAirport14DEC199973350RDULHR108543RDULHR03

5、DEC199903DEC199917600250708018114308London,EnglandHeathrowAirport15DEC199958539RDULHR21963RDULHR04DEC199904DEC1999176002834084960108937London,EnglandHeathrowAirport16DEC199964191RDULHR31517RDULHR05DEC199905DEC199917600327007221690999London,EnglandHeathrowAirport17DEC19991

6、16839RDULHR105682RDULHR06DEC199906DEC199922400294307487121019London,EnglandHeathrowAirport18DEC199982369RDULHR66992RDULHR07DEC199907DEC199922400294308496069798London,EnglandHeathrowAirport19DEC1999109908RDULHR92873RDULHR08DEC199908DEC199920800272508230537482London,England

7、HeathrowAirport20DEC19992439RDULHR59560RDULHR09DEC199909DEC199922400327008442979969London,EnglandHeathrowAirport21DEC199936700RDULHR41096RDULHR10DEC199910DEC199920800327006796880372London,EnglandHeathrowAirport10272RDULHR11DEC199911DEC1999224002943078588120146London,Engla

8、ndHeathrowAirport14DEC199973350RDULHR35121RDULHR12DEC199912DEC199917600305206796880967London,Eng