SAS9.3的安装可以参考:https://bbs.pinggu.org/thread-1414846-1-1.html
SAS学习笔记目录
Print语句的应用
- 数据的展示,展示的变量可通过VAR进行选择
- 进行简单的汇总
- proc print data=ia.empdata noobs;
- var JobCode EmpID Salary;
- where JobCode='PILOT';
另外逻辑符号对应为:AND(&),OR(|),NO(^)
另外一个例子使我对ID的用法有初步的了解
- proc sort data=ia.empdata out=work.empdata;
- by JobCode;
- run;
- proc print data=work.empdata;
- by JobCode;
- id JobCode;
- sum Salary;
- run;
- LIKE
- sounds like
- IS MISSING (or IS NULL)
- where Code like 'E_U%';
- where Name=*'SMITH';
- where Flight is missing;
- where Flight is null;
优化输出
输出标题:
TITLEn 'text'
FOOTNOTEn 'text'
- title1 'Flight Crew Employee Listing';
- footnote2 'Employee Review';
- proc print data=ia.empdata label;
- label LastName='Last Name'
- FirstName='First Name'
- Salary='Annual Salary';
- title1 'Salary Report';
- run;
- proc print data=ia.empdata split=' ';
- label LastName='Last Name'
- FirstName='First Name'
- Salary='Annual Salary';
- title1 'Salary Report';
- run;
数据值的格式化
FORMAT varible(s) format;
- proc print data=ia.empdata;
- format Salary dollar11.2;
- run;
下一篇:创建SAS数据文件