264.TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT | MACROS

on
0

80.NON-MATCH DATA WITH SET STATEMENT

on

                       NON-MATCH DATA WITH SET STATEMENT


 DATA CLASS;

INPUT NAME$ CLASS SEX$ AGE;

CARDS;

MANI 5 M 10

FARAN 6 M 11

CHIKU 4 F 09

NAINA 2 F 06

RAGHU 6 M 12

FARAH 9 F 14

KRITI 10 F 15

RASHI 9 F 16

RIYA 8 F 13

SRI 9 M 14

;

RUN;

PROC PRINT;

RUN;


DATA PERSONAL;

 LENGTH FATHER_NAME  MOTHER_NAME $10. SIBLINGS $8. VILLAGE $10. CITY $20.  STATE $13.;

 INPUT FATHER_NAME$ MOTHER_NAME$ SIBLINGS$ VILLAGE$ CITY$ STATE$;

 CARDS;

 KRISHNA LAKSHMI BROTHER BHEEMGAL NIZAMABAD TELANGANA

 ABDUL FARAH SISTER KOVALAM TIRUVANANTHAPURAM KERALA

 SRINIVAS INDIRA NO MALAVALLI MYSORE KARNATAKA

 RAJEEV GEETHA SISTER HAMPI HOSPET KARNATAKA

 SANJAY UMA BROTHER TIRUMALA TIRUPATHI ANDHRAPRADESH

 ALI FATHIMA NO MUNNAR MUNNAR KERALA

 RAVI ANITA BROTHER KUKATPALLY HYDERABAD TELANGANA

 PRAVEEN PREETHI NO RAMPOOR NIZAMABAD TELANGANA

 VIJAY ASHA SISTER BODHGAYA GAYA BIHAR

 SURESH GEETHA NO BODHAN NIZAMABAD TELANGANA

 ;

RUN;

PROC PRINT;

RUN;


##THIS IS THE LAST CREATED BLOG BUT FOR A CHANGE IF WE REPLACE MERGE WITH SET THEN WHAT WILL HAPPEN...


DATA STUDENTS;

 SET CLASS PERSONAL;

RUN;

PROC PRINT;RUN;


EXPLANATION:SO HERE WHAT WE HAVE TO UNDERSTAND THAT IN SET STATEMENT WE SHOULD HAVE SAME VARIABLES OR WE HAVE TO RENAME THE VARIABLES WHICH ARE MATCHING WITH THE DATA...OTHERWISE THE DATA OUTPUT WILL BE LIKE BELOW DATA.......


OUTPUT:

                                                                                                           The SAS System

Obs NAME CLASS SEX AGE FATHER_NAME MOTHER_NAME SIBLINGS VILLAGE CITY STATE
1 MANI 5 M 10            
2 FARAN 6 M 11            
3 CHIKU 4 F 9            
4 NAINA 2 F 6            
5 RAGHU 6 M 12            
6 FARAH 9 F 14            
7 KRITI 10 F 15            
8 RASHI 9 F 16            
9 RIYA 8 F 13            
10 SRI 9 M 14            
11   .   . KRISHNA LAKSHMI BROTHER BHEEMGAL NIZAMABAD TELANGANA
12   .   . ABDUL FARAH SISTER KOVALAM TIRUVANANTHAPURAM KERALA
13   .   . SRINIVAS INDIRA NO MALAVALLI MYSORE KARNATAKA
14   .   . RAJEEV GEETHA SISTER HAMPI HOSPET KARNATAKA
15   .   . SANJAY UMA BROTHER TIRUMALA TIRUPATHI ANDHRAPRADESH
16   .   . ALI FATHIMA NO MUNNAR MUNNAR KERALA
17   .   . RAVI ANITA BROTHER KUKATPALLY HYDERABAD TELANGANA
18   .   . PRAVEEN PREETHI NO RAMPOOR NIZAMABAD TELANGANA
19   .   . VIJAY ASHA SISTER BODHGAYA GAYA BIHAR
20   .   . SURESH GEETHA NO BODHAN NIZAMABAD TELANGANA


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