SAS宏入门.ppt

SAS宏入门,SAS宏的作用,获取SAS系统信息有条件执行数据步和过程步开发交互式系统产生与数据无关的SAS程序在不同的SAS数据步和过程步之间传递数据重复执行SAS程序,简介：,定义：可以按照用户的需要对SAS系统进行扩充和定义，以减轻在完成一些相同的统计分析任务时的文本录入量。宏功能包括：宏处理器宏语言两种定义符：procplot;plotrun%mendplot,在调用左边这段宏时，要给出各个参数的值，如%plot(height,weight)SAS看到的语句是：PROCPLOT;PLOTHEIGHT*WEIGHT;RUN;,2.5宏表达式,三种：A、文本表达式B、逻辑表达式C、算术表达式宏处理器首先对A进行解析，再计算B或C值。,A、文本表达式,定义：是任何文本、宏变量、宏函数或宏调用的组合，通常产生文本。常见的有：Run;%plotProcprint;Run;,DATATEMP;SETIN.PERMDATA;IFAGE=20;RUN;PROCPLOT;PLOTINCOME*AGE;RUN;PROCPRINT;RUN;,-,3.3用宏参数在宏中传递信息,%macroplot(yvar=,xvar=);procplot;plot%plot(yvar=income,xvar=age)%plot(yvar=income,xvar=yrs_educ),PROCPLOT;PLOTINCOME*AGE;RUN;PROCPLOT;PLOTINCOME*YRS_EDUC;RUN;,用宏参数在宏中传递信息,使用宏参数的好处：可以减少使用%LET语句，而且可以使变量不会对宏外部的程序产生干扰。注意：在上面的宏定义中，宏参数后带有等号，这种宏参数称为关键字宏参数，在调用这种宏时，必须写出宏参数名、等号和所赋给的值，但宏参数的位置可以任意排列，即上面的两个宏调用也可以这样写：%plot(xvar=age,yvar=income)%plot(xvar=yrs_educ,yvar=income),3.4根据条件产生SAS代码,%macrowhatstep(info=,mydata=);%if,Procreportdata=,如果对INFO和MYDATA赋值分别为print和grocery,即：%whatstep(info=print,mydata=grocery)产生程序为：PROCPRINTDATA=GROCERY；RUN；,如果对参数INFO和MYDATA赋值分别为report和book,即：%whatstep(info=print,mydata=grocery)产生的程序为：OPTIONSNODATENONUMBERPS=18LS=70FMTSEARCH=（SASUSER）；PROCREPORTDATA=BOOKNOWD；COLUMNMANAGERDEPTSALES;WHERESECTOR=SE；FORMATMANAGER$MGRFMT.DEPT$DEPTEMT.SALESDOLLAR11.2;TITLESALESFORTHESOUTHEASTSECTOR;RUN;,3.5用循环语句%DO产生重复的文本,%macronames(name=.number=);%don=1%to,3.6为宏变量引用产生后缀,%macronamesx(name=,number=);%don=1%to注意：在宏变量NAME与字母X间使用了定界符“.”。,/*/*计算人口调查中的MyersIndex程序*/*/libnamefamd:mohhealthfam2;dataabc(keep=eww1);setfam.fam2;e=int(98-k4)*12+(6-k5)/12);/*ageinthe10thru49*/ifein(10,20,30,40)thenw=1;ifein(11,21,31,41)thenw=2;ifein(12,22,32,42)thenw=3;ifein(13,23,33,43)thenw=4;ifein(14,24,34,44)thenw=5;ifein(15,25,35,45)thenw=6;ifein(16,26,36,46)thenw=7;ifein(17,27,37,47)thenw=8;ifein(18,28,38,48)thenw=9;ifein(19,29,39,49)thenw=10;ifw=.thendelete;/*ageinthe20thru59year*/ifein(20,30,40,50)thenw1=1;ifein(21,31,41,51)thenw1=2;ifein(22,32,42,52)thenw1=3;ifein(23,33,43,53)thenw1=4;ifein(24,34,44,54)thenw1=5;ifein(25,35,45,55)thenw1=6;ifein(26,36,46,56)thenw1=7;ifein(27,37,47,57)thenw1=8;ifein(28,38,48,58)thenw1=9;ifein(29,39,49,59)thenw1=10;ifw1=.thendelete;run;,/*frequnciesforagein10thru49*/procfreqdata=abcnoprint;tablesw/out=f1;procfreqdata=abcnoprint;tablesw1/out=f2;run;dataff1;setf1(rename=(count=count1);f1=w*count1;dataff2;setf2(rename=(count=count2);w1=10-w1;f2=w1*count2;datam_s;/*uniteff1andff2andsumforcount*/mergeff1ff2;count=f1+f2;run;procmeanssumnoprintdata=m_s;varcount;outputout=tempsum=sm;datamyers(drop=_type_freq_smpercentsumn);mergem_stemp;sumn+sm;per=count/sumn*100;myers=abs(per-10);run;titleMyersIndex;procprintnoobsdata=myers;sumcountpermyers;run;title;procdatasets;deleteabcf1f2ff1ff2m_stemp;run;quit;,libnamefamd:mohhealthfam2;dataabc(keep=eww1);setfam.fam2;e=int(98-k4)*12+(6-k5)/12);%letage=ifein;/*ageinthe10thru49*/,/*frequnciesforagein10thru49*/%macrofreq(var,file);procfreqdata=abcnoprint;tables,%macropw(file,a,b,c,po);data,%macropo(x,p,y,z);data,/*sortingfordata*/%sorting(p1);%sorting(p2);%sorting(p3);%sorting(p4);%sorting(p5);%sorting(p6);datatotal;mergep1p2p3p4p5p6;byn;run;quit;goptionsdevice=WINctext=bluegraphrcinterpol=join;axis1color=bluewidth=2.0length=40;axis2color=bluewidth=2.0length=15;procgplotdata=WORK.TOTAL;plot(POWER1POWER2POWER3POWER4POWER5POWER6)*N/overlayhaxis=axis1vaxis=axis2;run;quit;,/*/*两样本均数比较的POWER计算程序*/*/%macropw;data,%analysit(p1,105,120,12,power1,p1);%analysit(p2,105,115,12,power2,p2);%analysit(p3,105,112,12,power3,p3);%analysit(p4,105,110,12,power4,p4);%analysit(p5,105,108,12,power5,p5);%analysit(p6,105,116,12,power6,p6);datatotal;mergep1p2p3p4p5p6;byn;run;quit;/*以下程序为power与n之间关系的曲线图*/goptionsdevice=WINctext=bluegraphrcinterpol=join;axis1color=bluewidth=2.0length=40;axis2color=bluewidth=2.0length=15;procgplotdata=WORK.T