人大经济论坛SAS中级视频教程讲义

人大经济论坛sas中级视频教程讲义

目录

前言...............................................................................................................................1一、函数篇...................................................................................................................2

（一）字符型函数...................................................................................................................2

1.CAT类函数http://PRESS函数..........................................................................................................23.COUNT函数.................................................................................................................44.FIND函数.....................................................................................................................45.IFC函数........................................................................................................................56.PUT函数.......................................................................................................................57.REPEAT函数................................................................................................................68.SCAN函数....................................................................................................................69.SUBSTR函数................................................................................................................610.TRANWRD函数.........................................................................................................711.LENGTH类函数.........................................................................................................7（二）数值型函数...................................................................................................................8

1.DIF函数........................................................................................................................82.CEIL函数......................................................................................................................83.FLOOR函数..................................................................................................................84.IFN函数........................................................................................................................85.INPUT函数...................................................................................................................96.INT函数........................................................................................................................97.INTCK函数..................................................................................................................98.INTNX函数http://G函数....................................................................................................................1110.ROUND函数............................................................................................................11（三）日期型函数.................................................................................................................11

1.DATDIF函数..............................................................................................................112.DATE函数（TODAY函数）.....................................................................................123.DATETIME函数.........................................................................................................12

人大经济论坛sas中级视频教程讲义

4.DAY函数....................................................................................................................125.MONTH函数..............................................................................................................136.YEAR函数..................................................................................................................13(四)SCL语言函数.................................................................................................................13

1.OPEN函数..................................................................................................................132.CLOSE函数................................................................................................................133.FETCHOBS函数........................................................................................................144.VARNUM函数...........................................................................................................145.GETVARC函数/GETVARN函数...............................................................................14

二、SQL篇.................................................................................................................15

（一）单表操作.....................................................................................................................15（二）多表操作.....................................................................................................................17

1.多表关联....................................................................................................................182.子查询........................................................................................................................213.SET运算符..................................................................................................................22（三）创建和更新表.............................................................................................................23

1.创建表........................................................................................................................232.更新表........................................................................................................................233.删除表..................................................................................................................... …… 此处隐藏：19826字，全部文档内容请下载后查看。喜欢就下载吧 ……