42.DATA VALIDATION TECHNIQUES

                  DATA VALIDATION TECHNIQUES

1.PROC PRINT

-->HERE WE USED NOOBS FOR REMOVING THE NUMBERS IN THE RESULT..

PROC PRINT DATA=SASUSER.CLASS2 NOOBS ;

VAR NAME AGE CLASS;

RUN;

LOG:

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.

NOTE: PROCEDURE PRINT used (Total process time):

      real time           1.92 seconds

      cpu time            0.40 seconds

RESULT:

Name	Age	CLASS
Alfred	14	9
Alice	13	8
Barbara	13	8
Carol	14	9
Henry	14	9
James	12	7
Jane	12	7
Janet	15	10
Jeffrey	13	8
John	12	7
Joyce	11	6
Judy	14	9
Louise	12	7
Mary	15	10
Philip	16	11
Robert	12	7
Ronald	15	10
Thomas	11	6
William	15	10

2.PROC MEANS

PROC MEANS DATA=SASUSER.CLASS2;

LABEL DOB='Date Of Birth';

LABEL CLASS='CLASS';

RUN;

LOG:

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.

NOTE: PROCEDURE MEANS used (Total process time):

      real time           1.09 seconds

      cpu time            0.04 seconds

RESULT:

Variable	Label	N	Mean	Std Dev	Minimum	Maximum
Age Height Weight DOB CLASS	Age Height Weight Date Of Birth CLASS	19 19 19 19 19	13.3157895 62.3368421 100.0263158 18482.26 8.3157895	1.4926722 5.1270752 22.7739335 442.3167344 1.4926722	11.0000000 51.3000000 50.5000000 17638.00 6.0000000	16.0000000 72.0000000 150.0000000 19344.00 11.0000000

-->HERE WE ARE USING SELECTED STATISTICS IN THEIS PROCEDURE LIKE N,MEAN,MIN,MAX..

PROC MEANS DATA=SASUSER.CLASS2 N MEAN MIN MAX;

VAR AGE CLASS;

RUN;

LOG:

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.

NOTE: PROCEDURE MEANS used (Total process time):

      real time           0.09 seconds

      cpu time            0.03 seconds

RESULT:

Variable	Label	N	Mean	Minimum	Maximum
Age CLASS	Age	19 19	13.3157895 8.3157895	11.0000000 6.0000000	16.0000000 11.0000000

-->HERE WE USED NMISS FOR KNOWING THE MISSING OBSERVATIONS IN THE DATASET..

PROC MEANS DATA=SASUSER.CLASS2 NMISS;

VAR AGE;

OUTPUT OUT=A22;

RUN;

LOG:

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.

NOTE: The data set WORK.A22 has 5 observations and 4 variables.

NOTE: PROCEDURE MEANS used (Total process time):

      real time           0.09 seconds

      cpu time            0.01 seconds

RESULT:

The MEANS Procedure

Analysis Variable : Age Age
N Miss
0

-->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