62.ADDING NEW DATA INTO AVAILABLE DATA USING MERGE

on

         ADDING NEW DATA INTO AVAILABLE DATA USING MERGE 


DATA  WHICH WANTS TO MERGE WITH ALREADY CREATED DATE..IT CONSISTS OF 3 STEPS AND I HAVE ALSO SORTED THE DATA..

1.DATA CLASS1;

 SET SASHELP.CLASS4;

RUN;


LOG:

NOTE: There were 19 observations read from the data set SASHELP.CLASS4.

NOTE: The data set WORK.CLASS1 has 19 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.50 seconds

      cpu time            0.04 seconds


2.DATA WORK.CLASS2;

 INPUT  Name$ Sex$ Age Height Weight DOB:DATE9. CLASS GRADE$;

 DATALINES;

 Nancy F 19 69 102 12MAR2002 . A

 Firoz M 20 76 125 15JUN2001 . A

 ;

RUN;


LOG:

NOTE: The data set WORK.CLASS2 has 2 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.07 seconds

      cpu time            0.00 seconds


3.DATA SASHELP.CLASS3;

 MERGE CLASS1

       CLASS2;

RUN;

PROC PRINT;RUN;


LOG:

NOTE: There were 19 observations read from the data set WORK.CLASS1.

NOTE: There were 2 observations read from the data set WORK.CLASS2.

NOTE: The data set SASHELP.CLASS3 has 19 observations and 8 variables.

NOTE: DATA statement used (Total process time):

      real time           0.09 seconds

      cpu time            0.01 seconds


RESULT:
                                                              The SAS System

Obs Name Sex Age Height Weight DOB CLASS GRADE
1 Nancy F 19 69 102 12MAR2002 . A
2 Firoz M 20 76 125 15JUN2001 . A
3 Barbara F 13 65.3 98 14DEC2010 8 C
4 Carol F 14 62.8 102.5 12NOV2009 9 B
5 Henry M 14 63.5 102.5 14NOV2009 9 C
6 James M 12 57.3 83 15MAR2011 7 A
7 Jane F 12 59.8 84.5 17APR2011 7 A
8 Janet F 15 62.5 112.5 14NOV2009 10 A
9 Jeffrey M 13 62.5 84 15APR2010 8 B
10 John M 12 59 99.5 15JUN2011 7 A
11 Joyce F 11 51.3 50.5 17DEC2012 6 C
12 Judy F 14 64.3 90 18DEC2010 9 A
13 Louise F 12 56.3 77 14NOV2011 7 A
14 Mary F 15 66.5 112 15DEC2009 10 A
15 Philip M 16 72 150 16APR2008 11 B
16 Robert M 12 64.8 128 14DEC2011 7 C
17 Ronald M 15 67 133 12MAR2009 10 A
18 Thomas M 11 57.5 85 14MAY2012 6 A
19 William M 15 66.5 112 15FEB2009 10 C

PROC SORT DATA=SASHELP.CLASS3;

 BY NAME;

RUN;

PROC PRINT;RUN;


LOG:

NOTE: There were 19 observations read from the data set SASHELP.CLASS3.

NOTE: The data set SASHELP.CLASS3 has 19 observations and 8 variables.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.23 seconds

      cpu time            0.03 seconds


RESULT:SORTED DATA

                                                              The SAS System


Obs Name Sex Age Height Weight DOB CLASS GRADE
1 Barbara F 13 65.3 98 14DEC2010 8 C
2 Carol F 14 62.8 102.5 12NOV2009 9 B
3 Firoz M 20 76 125 15JUN2001 . A
4 Henry M 14 63.5 102.5 14NOV2009 9 C
5 James M 12 57.3 83 15MAR2011 7 A
6 Jane F 12 59.8 84.5 17APR2011 7 A
7 Janet F 15 62.5 112.5 14NOV2009 10 A
8 Jeffrey M 13 62.5 84 15APR2010 8 B
9 John M 12 59 99.5 15JUN2011 7 A
10 Joyce F 11 51.3 50.5 17DEC2012 6 C
11 Judy F 14 64.3 90 18DEC2010 9 A
12 Louise F 12 56.3 77 14NOV2011 7 A
13 Mary F 15 66.5 112 15DEC2009 10 A
14 Nancy F 19 69 102 12MAR2002 . A
15 Philip M 16 72 150 16APR2008 11 B
16 Robert M 12 64.8 128 14DEC2011 7 C
17 Ronald M 15 67 133 12MAR2009 10 A
18 Thomas M 11 57.5 85 14MAY2012 6 A
19 William M 15 66.5 112 15FEB2009 10 C


TRY THIS AND COMMENT ...


-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE: https://t.me/SasAll4You


Comments

Post a Comment