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

79.CREATING OWN DATASETS AND USING MERGE STATEMENT

on

             CREATING OWN DATASETS AND USING MERGE STATEMENT


CREATING A NEW DATASET : CLASS

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;


OUTPUT:

                                                               The SAS System


Obs NAME CLASS SEX AGE
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

CREATING A NEW DATASET : PERSONAL

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;


OUTPUT:

                                                                                        The SAS System


Obs FATHER_NAME MOTHER_NAME SIBLINGS VILLAGE CITY STATE
1 KRISHNA LAKSHMI BROTHER BHEEMGAL NIZAMABAD TELANGANA
2 ABDUL FARAH SISTER KOVALAM TIRUVANANTHAPURAM KERALA
3 SRINIVAS INDIRA NO MALAVALLI MYSORE KARNATAKA
4 RAJEEV GEETHA SISTER HAMPI HOSPET KARNATAKA
5 SANJAY UMA BROTHER TIRUMALA TIRUPATHI ANDHRAPRADESH
6 ALI FATHIMA NO MUNNAR MUNNAR KERALA
7 RAVI ANITA BROTHER KUKATPALLY HYDERABAD TELANGANA
8 PRAVEEN PREETHI NO RAMPOOR NIZAMABAD TELANGANA
9 VIJAY ASHA SISTER BODHGAYA GAYA BIHAR
10 SURESH GEETHA NO BODHAN NIZAMABAD TELANGANA



MERGE THE BOTH CLASS AND PERSONAL DATASETS : STUDENTS

DATA STUDENTS;

 MERGE CLASS PERSONAL;

RUN;

PROC PRINT;RUN;


OUTPUT:
                                                                                               The SAS System

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