作者chandre (卷卷)
看板Psychology01
标题[公告] sas code 11/12
时间Fri Nov 14 16:44:33 2008
资料处理简介
简单运算
+
-
*
/
**
条件式
>
<
>=
<=
And
Or
Not
条件式(if)
If() then()
IF year=88 OR year=99 THEN year=.;
If ()then() else()
IF year=88 OR year=99 THEN mod_year=.;
ELSE mod_year=year;
If ()then do() end
IF year=88 OR year=99 THEN DO;
year=.;
missing=1;
END;
If ()then do() end else()
IF year=88 OR year=99 THEN DO;
year=.;
modified="YES";
END;
ELSE modified="NO";
条件式(select)
SELECT;
WHEN ( age<18 ) group=1;
WHEN ( age>=18 AND age<65 ) group=2;
WHEN ( age>=65 ) group=3;
OTHERWISE group=.;
END;
分割资料(取其中一群)
DATA old_data;
SET age_data;
IF age>=65 THEN OUTPUT;
PROC PRINT DATA=old_data;
RUN;
分割资料(分多群)
DATA child adult old;
SET age_data;
SELECT;
WHEN (age<18) OUTPUT child;
WHEN (18<=age<65 ) OUTPUT adult;
WHEN (age>=65) OUTPUT old;
END;
PROC PRINT DATA=child;
PROC PRINT DATA=adult;
PROC PRINT DATA=old;
============================================================================
程式码：
(一)if
DATA d1;
INPUT year @@;
IF year=88 OR year=99 THEN year=.;
CARDS;
12 88 8 5 7 10 9 2 99 8
7 5 88 3 14 88 26 18 99 25
;
PROC PRINT DATA=d1;
RUN;
--------------------------------------------------------------------
(二)select
DATA group;
INPUT age @@;
SELECT;
WHEN ( age<18 ) group=1;
WHEN ( age>=18 AND age<65 ) group=2;
WHEN ( age>=65 ) group=3;
OTHERWISE group=.;
END;
CARDS;
19 85 70 19 23 75 1 96 15 47
13 44 81 41 34 31 99 72 27
;
PROC PRINT DATA=group;
RUN;
------------------------------------------------------------------------------
(三)divide date
DATA age_data;
INPUT age @@;
CARDS;
19 85 70 19 23 75 1 96 15 47
13 44 81 41 34 31 99 72 27
;
PROC PRINT DATA=age_data;
DATA child adult old;
SET age_data;
SELECT;
WHEN (age<18) OUTPUT child;
WHEN (18<=age<65 ) OUTPUT adult;
WHEN (age>=65) OUTPUT old;
END;
PROC PRINT DATA=child;
PROC PRINT DATA=adult;
PROC PRINT DATA=old;
RUN;
==============================================================================
这次的档案比较复杂
助教寄给我一份ppt和四份sas codes
我目前只贴了他上过的部份
如果有需要档案的推个文吧
--
Que la musique l'accompagne en tout lieu.
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.109.224.53