OUTPUT STATEMENT
CONTROLLING THE OUTPUT::::
--->HOW TO CREATE MULTIPLE OBSERVATIONS FROM 'ONE OBSERVATION'?
---> BY USING 'OUTPUT' STATEMENT
FOR CALCULATING THE AGES FOR ONLY ONE YEAR
WHAT IF CALCULATING THE AGES FOR 5 YR?
1.FOR CALCULATING THE AGES FOR ONLY ONE YEAR
DATA SAS;
SET SASHELP.CLASS;
YEAR=1;
NEWAGE=AGE+1; *14+1=15 12+1=13 ;
RUN;
PROC PRINT;
RUN;
2.WHAT IF CALCULATING THE AGES FOR 5 YR?
LAST OBSERVATION VALUE WILL COME IN THE OUTPUT
DATA SAS;
SET SASHELP.CLASS;
YEAR=1;
NEWAGE=AGE+1;
YEAR=2;
NEWAGE=AGE+2;
YEAR=3;
NEWAGE=AGE+3;
YEAR=4;
NEWAGE=AGE+4;
YEAR=5;
NEWAGE=AGE+5;
RUN;
PROC PRINT;
RUN;
----FOR PROPER OUTPUT USE 'OUTPUT' STATEMENT TO THE SYNTAX
DATA SAS;
SET SASHELP.CLASS;
YEAR=1;
NEWAGE=AGE+1;
OUTPUT;
YEAR=2;
NEWAGE=AGE+2;
OUTPUT;
YEAR=3;
NEWAGE=AGE+3;
OUTPUT;
YEAR=4;
NEWAGE=AGE+4;
OUTPUT;
YEAR=5;
NEWAGE=AGE+5;
OUTPUT;
RUN;
PROC PRINT;
RUN;
DATA GROW;
SET PROG2.GROWTH;
MONTH=1;
TOTALVAL=NUMEMPS*(1+INCREASE); *220*1+0.075;
RUN;
PROC PRINT;
RUN;
DATA GROW;
SET PROG2.GROWTH;
MONTH=1;
TOTALVAL=NUMEMPS*(1+INCREASE);OUTPUT;
MONTH=2;
TOTALVAL=NUMEMPS*(2+INCREASE);OUTPUT;
MONTH=3;
TOTALVAL=NUMEMPS*(3+INCREASE);OUTPUT;
RUN;
PROC PRINT;
RUN;
DATA WEW;
SET SASHELP.CLASS;
IF AGE >14 THEN OUTPUT;
RUN;
PROC PRINT;
RUN;
WRITING MULTIPLE SAS DATASETS FROM(IN) ONE DATASTEP
DATA SUB;
INPUT ID NAME$ AGE SUBJECT$;
CARDS;
101 ANIL 25 MATHS
102 HEMA 24 ENGLISH
103 KAMAL 26 PHARMA
104 ASHOK 25 MATHS
105 RAMYS 26 MECH
106 XXXXX 24 ENGLISH
107 YYYYY 26 PHARMA
108 ZZZZZ 24 MATHS
109 AAAAA 25 ENGLISH
110 BBBBB 28 MECH
111 CCCCC 26 MATHS
112 DDDDD 28 PHARMA
;
RUN;
PROC PRINT;
RUN;
DATA MATHS;
SET SUB;
IF SUBJECT='MATHS' THEN OUTPUT;
RUN;
DATA ENGLISH;
SET SUB;
IF SUBJECT='ENGLISH' THEN OUTPUT;
RUN;
DATA MATHS
ENGLISH
PHARMA
MECH;
SET SUB;
IF SUBJECT='MATHS' THEN OUTPUT MATHS;
ELSE IF SUBJECT='ENGLISH' THEN OUTPUT ENGLISH;
ELSE IF SUBJECT='PHARMA' THEN OUTPUT PHARMA;
ELSE IF SUBJECT='MECH' THEN OUTPUT MECH;
RUN;
PROC PRINT;
RUN;
NOTE:FOUR WAYS WE CAN USE THE "OUTPUT" STATEMENT
1.CREATING MULTIPLE OBSERVATION FROM ONE OBSERVATION
2.CREATING MULTIPLE DATASETS FROM ONE DATASTEP
3.SUBSETTING THE OBSERVATIONS BY "IF THEN OUTPUT"
4.CREATING THE NEW DATASET IN PROC MEANS
PLEASE FOLLOW THE BLOG AND SHARE IT...
Comments
Post a Comment