[计算机软件及应用]从入门到精通sas练习 杨池然

《[计算机软件及应用]从入门到精通sas练习 杨池然》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、SAS基础练习1、变量libnamedy'd:test';datady.sfza;lengthid$18.;/*id是字符型变量，需要加$*/inputidsex$;cards;411422198306340045M411422198709098907F;run;procprintdata=dy.sfza(keep=idsex);run;libnamedf'd:dzwj';%letfl='d:dzwjemp.txt';/*定义外面文件路径赋值给fl*/filenamefil"(&fl)";/*取出宏变量，给fil*/datadf.employeer;/*将数据存储在逻辑库df制定的文件

2、夹下*/infilefil;/*读取外部文件fil所指向的文件*/lengthid$18.;/*身份证号超过了8字节，需要用length定义*/inputbhao$name$id@;run;procprintdata=df.employeer;run;libnamedy'd:test';datady.xadd11;x=3;y='5';z=x+y;/*字符变量和数字变量做加运算*/run;procprint;run;libnamedy'd:test';datady.clink;x=3;a='hello';k=a

3、

4、x;/*数字型变量与字符型变量做链接运算*/run;procprint;run

5、;libnamedy'd:test';datady.xtochar;x=12345678;a=substr(x,5,6);/*将数字型x变化成字符类型*/run;procprint;run;libnamedy'd:test';datady.const;x='新宋体';a="Howdoyoudo？";/*常量可以用单引号或者双引号括起来*/run;procprint;run;libnamedy'd:test';datady.dyh;y="John's'";/*常量里面有单引号，外面用双引号括起来*/k='大家"灵活"使用实例';/*常量里面有双引号，外面用单引号括起来*/run;procp

6、rint;run;libnamedy'd:test';datady.szx;x=86;/*将数值型常量赋值给变量*/y=-10;z=+36;k=2E-5;run;procprint;run;libnamedy'd:test';datady.riq;cdate="3mar2010"d;ctime='7:30't;cdatetime='6jan2010:8:18:30pm'dt;;/*将日期d和时间t型变量赋值给变量*/这里面有两个分号run;procprint;formatcdateyymmdd10.ctimetime10.cdatetimedatetime22.;/*格式化定义的时间*/r

7、un;libnamedy'd:test';datady.power;y=2**3;/*2的3次幂*/run;procprint;run;libnamedy'd:test';datachoose;inputid$name$sex$score@@;cards;001白小燕F50002张涛M70003赵新雨F90004郑起心M30;datapassnopass;setchoose;ifscore>=60thenoutputpass;/*主要训练>=的使用*/elseoutputnopass;run;procprintdata=nopass;/*只输出不及格的人数*/title"不及格的学生";r

8、un;libnamedy'd:test';datady.connstr;str1='how';str2='doyoudo';con=str1

9、

10、str2;conn2=str1!!str2;/*用

11、

12、和!!链接两个字符串*/run;procprint;run;libnamedy'd:test';datady.definearr;arrayx{3}$('yang''ni''hao');/*定义的一个字符类型的一维数组*/run;procprint;run;以下红色的字体为不能实现的程序，原因不详。libnamedy'd:test';datady.definetwoarr;inputx11-x

13、12y21-22@@;arrayxy{2,2}x11-x12y21-22;/*定义二维数组*/cards;1234;run;procprint;run;libnamedy'd:test';datady.definewotemarr;arrayt{2,2}$_temporary_('A''B''C''D');/*定义的临时的二维字符型数组*/y=t(1,2);puty=;run;procprint