[公告] sas codes 11/19

[chandre (捲捲)]

合併資料(加樣本)

DATA store1;
  INPUT sale @@;
  store=1;
CARDS;
12 58 27
;

DATA store2;
  INPUT sale @@;
  store=2;
CARDS;
35 89 73
;

DATA both;
  SET store1 store2;

PROC PRINT DATA=both;
  VAR store sale;
RUN;


永久儲存

DATA store1;
  INPUT sale @@;
  store=1;
CARDS;
12 58 27
;

DATA store2;
  INPUT sale @@;
  store=2;
CARDS;
35 89 73
;

DATA “c:\data\both”;
  SET store1 store2;

PROC PRINT DATA=both;
  VAR store sale;
RUN;

使用永久資料庫

DATA d1;
  SET "c:\data\both";

PROC PRINT DATA=d1;

PROC PRINT DATA="c:\data\both";
RUN;

簡化路徑

LIBNAME dd "c:\data";

DATA d1;
  SET dd.both;

PROC PRINT DATA=d1;

PROC PRINT DATA=dd.both;
RUN;

合併資料(加變項)
DATA basic;
  INPUT id $ sex $ blood $ height weight;
CARDS;
T001 M A  167 68
T002 F O  163 70
T003 M B  166 64
T004 F O  163 67
T005 F B  173 59
T006 F A  166 70
T007 M O  166 79
T008 F AB 177 55
T009 M B  161 77
T010 F O  179 61
T011 M AB 167 58
T012 F A  168 63
T013 F O  163 63
T014 F B  166 69
T015 F O  171 79
T016 F A  174 56
;

DATA score;
  INPUT id $ s1 s2 s3 s4;
CARDS;
T001 57 94 88 60
T002 69 62 65 75
T003 77 89 78 77
T004 66 55 64 66
T005 93 73 86 74
T006 74 83 87 79
T007 76 55 77 87
T008 67 91 56 87
T009 65 58 92 78
T010 80 85 65 62
T011 79 82 77 65
T012 79 58 64 81
T013 79 62 62 80
T014 56 71 81 80
T015 64 87 92 57
T016 69 93 56 86
;

PROC PRINT DATA=basic;

PROC PRINT DATA=score;

DATA combine;
  MERGE basic score;

PROC PRINT DATA=combine;
RUN;

合併資料(依關鍵值)

PROC PRINT DATA=basic;

PROC PRINT DATA=time;

PROC SORT DATA=basic;
  BY id;

PROC SORT DATA=time;
  BY id;

DATA combine;
  MERGE basic time;
  BY id;

PROC PRINT DATA=combine;
RUN;


-----------------------------------------------------------------------------
sas codes:
Operator

DATA oper;
  INPUT x y @@;
  r1=x+y;
  r2=x-y;
  r3=x*y;
  r4=x/y;
  r5=x**2;
CARDS;
1 9 2 8 7 5 8 9 1 2 7 5
9 8 2 1 3 6 4 7 2 3 3 9
;

PROC PRINT DATA=oper;
RUN;

--
Que la musique l'accompagne en tout lieu.

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 140.109.224.53
推 Gokusen:哈謝謝捲捲神人：-D