SAS编程技巧：数据操作与管理

%GLOBAL odb;

%LET odb=cowlife;

%GLOBAL path;

%LET path=netslifemiscow;

%GLOBAL schema;

%LET schema=tmrlifearc;

%GLOBAL user;

%LET user=netslifesas;

%GLOBAL password;

%LET password=;

libname netssas "/paic/hq/sasuserdata16/netssasdata" ;

设置数据压缩：

options compress=binary;

libname &odb oracle path=&path schema=&schema user=&user password="&password";

/*系统变量*/

%GLOBAL systemdate;

%LET systemdate=%sysfunc(datetime());

%GLOBAL yyyymm;

%LET yyyymm=201503;

%GLOBAL yyyymm_01;

%LET yyyymm_01=%sysfunc(putn(%sysfunc(intnx(month,%sysfunc(inputn(&yyyymm.,yymmn6.)),-1)),yymmn6.));