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.));