The Road to Mathematics-sas (12)

Data student1;
Input name$ age score;
Datalines;
Wangwu 29 68
Lisi 30 85
Wangxi 28 79
Lixingxun 32 91
Wufang 27 56
;
Run
Data student;
Set student1;
Run
Data student2;
Input name$ age score;
Datalines;
WANGWU 29 88
Lisi 30 89
Wangxi 28 85
Lixingxun 32 93
Wufang 27 76
;
Run
/* Display the original data set */
Proc Print data=student;
Title "Original data Set";
Run
/*remove Removal Observation */
Data student1;
Modify Student1;
If score <80 then remove;
Run
Proc Print data=student1;
Title "Remove";
Run
/*replace Replacement Observations */
Data student;
Modify student Student2;
by name;
If score >85 then replace;
Run
Proc Print data=student;
Title "Replace";

Run

This blog all content is original, if reprint please indicate source http://blog.csdn.net/myhaspl/

The Road to Mathematics-sas (12)