172.GENERATING RANDOM STUDENT DATA IN SAS | USING DATA STEP | CREATING ARRAYS | RANDOM NUMBER GENERATION WITH RANUNI | CONDITIONAL DATA OUTPUT | PROC PRINT FOR DATA DISPLAY | PROC FREQ FOR CLASS DISTRIBUTION FINAL REPORT GENERATION USING PROC REPORT

-

GENERATING RANDOM STUDENT DATA IN SAS | USING DATA STEP | CREATING ARRAYS | RANDOM NUMBER GENERATION WITH RANUNI | CONDITIONAL DATA OUTPUT | PROC PRINT FOR DATA DISPLAY | PROC FREQ FOR CLASS DISTRIBUTION  | FINAL REPORT GENERATION  USING PROC REPORT

/*Creating a new dataset of School*/

Data School;

  Array Class[5] $10 _Temporary_ ('Class6','Class7','Class8','Class9','Class10');

  Array Subject[3] $15 _Temporary_ ('Math','Science','English');

  Do Roll_No = 1 To 20;

    Class_Index = Ceil(Ranuni(123)*5);

    Class_Name = Class(Class_Index);

    Num_Sub = Ceil(Ranuni(123)*3);

    Do Sub_Id = 1 To Num_Sub;

      Subject_Name = Subject(Sub_Id);

      Output;

    End;

  End;

  Drop Class_Index Num_Sub Sub_Id;

Run;

Proc Print;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 1 Class9 Math
2 2 Class6 Math
3 2 Class6 Science
4 2 Class6 English
5 3 Class7 Math
6 4 Class9 Math
7 4 Class9 Science
8 5 Class6 Math
9 6 Class9 Math
10 6 Class9 Science
11 7 Class10 Math
12 8 Class9 Math
13 8 Class9 Science
14 9 Class8 Math
15 9 Class8 Science
16 9 Class8 English
17 10 Class6 Math
18 10 Class6 Science
19 10 Class6 English
20 11 Class9 Math
21 11 Class9 Science
22 11 Class9 English
23 12 Class9 Math
24 13 Class8 Math
25 13 Class8 Science
26 13 Class8 English
27 14 Class6 Math
28 14 Class6 Science
29 15 Class9 Math
30 15 Class9 Science
31 16 Class8 Math
32 17 Class8 Math
33 18 Class8 Math
34 18 Class8 Science
35 19 Class6 Math
36 20 Class8 Math
37 20 Class8 Science
38 20 Class8 English


/* Using Select Statement */

Data Class6 

         Class7 

         Class8 

        Class9 

       Class10;

  Set School;

  Select (Class_Name);

    When ('Class6') Output Class6;

    When ('Class7') Output Class7;

    When ('Class8') Output Class8;

    When ('Class9') Output Class9;

    When ('Class10') Output Class10;

    Otherwise;

  End;

Run;

Proc Print Data=Class6;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 2 Class6 Math
2 2 Class6 Science
3 2 Class6 English
4 5 Class6 Math
5 10 Class6 Math
6 10 Class6 Science
7 10 Class6 English
8 14 Class6 Math
9 14 Class6 Science
10 19 Class6 Math

Proc Print Data=Class7;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 3 Class7 Math


Proc Print Data=Class8;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 9 Class8 Math
2 9 Class8 Science
3 9 Class8 English
4 13 Class8 Math
5 13 Class8 Science
6 13 Class8 English
7 16 Class8 Math
8 17 Class8 Math
9 18 Class8 Math
10 18 Class8 Science
11 20 Class8 Math
12 20 Class8 Science
13 20 Class8 English

Proc Print Data=Class9;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 1 Class9 Math
2 4 Class9 Math
3 4 Class9 Science
4 6 Class9 Math
5 6 Class9 Science
6 8 Class9 Math
7 8 Class9 Science
8 11 Class9 Math
9 11 Class9 Science
10 11 Class9 English
11 12 Class9 Math
12 15 Class9 Math
13 15 Class9 Science

Proc Print Data=Class10;

Run;

Output:

Obs Roll_No Class_Name Subject_Name
1 7 Class10 Math


/*Frequency Distribution of Classes and Subjects*/

proc freq data=SCHOOL;

  tables CLASS_NAME SUBJECT_NAME / nocum nopercent;

run;

Output:

                                                                   The FREQ Procedure

Class_Name Frequency
Class10 1
Class6 10
Class7 1
Class8 13
Class9 13

Subject_Name Frequency
English 6
Math 20
Science 12

/*Aggregated Analysis*/

proc sql;

  create table ClassSummary as

  select CLASS_NAME,

         count(distinct ROLL_NO) as Total_Students,

         count(*) / count(distinct ROLL_NO) as Avg_Subjects_Per_Student

  from SCHOOL

  group by CLASS_NAME;

quit;


proc print data=ClassSummary;

run;

Output:

Obs Class_Name Total_Students Avg_Subjects_Per_Student
1 Class10 1 1.00000
2 Class6 5 2.00000
3 Class7 1 1.00000
4 Class8 6 2.16667
5 Class9 7 1.85714


/*Detailed Report*/

proc report data=SCHOOL nowd;

  column ROLL_NO CLASS_NAME SUBJECT_NAME;

  define ROLL_NO / group;

  define CLASS_NAME / group;

  define SUBJECT_NAME / display;

run;

Output:

Roll_No Class_Name Subject_Name
1 Class9 Math
2 Class6 Math
    Science
    English
3 Class7 Math
4 Class9 Math
    Science
5 Class6 Math
6 Class9 Math
    Science
7 Class10 Math
8 Class9 Math
    Science
9 Class8 Math
    Science
    English
10 Class6 Math
    Science
    English
11 Class9 Math
    Science
    English
12 Class9 Math
13 Class8 Math
    Science
    English
14 Class6 Math
    Science
15 Class9 Math
    Science
16 Class8 Math
17 Class8 Math
18 Class8 Math
    Science
19 Class6 Math
20 Class8 Math
    Science
    English

PRACTICE AND COMMENT YOUR CODE: 

--->PLEASE FOLLOW OUR BLOG FOR MORE UPDATES.

PLEASE FOLLOW OUR TELEGRAM CHANNEL CLICK HERE

PLEASE FOLLOW OUR FACEBOOK PAGE  CLICK HERE

Comments

Post a Comment

Popular posts from this blog

409.Can We Build a Reliable Emergency Services Analytics & Fraud Detection System in SAS While Identifying and Fixing Intentional Errors?

-
Image
Building a Reliable Emergency Services Analytics & Fraud Detection System in SAS Through Systematic Error Identification and Correction -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- HERE WE USED THESE SAS STATEMENTS AND FUNCTIONS FOR THIS PROJECT: DATA STEP | SET | INPUT | DATALINES | LENGTH | FORMAT | IF-THEN-ELSE | MDY | INTCK | INTNX | STRIP | TRIM | CAT | CATX | PROPCASE | UPCASE | LOWCASE | COALESCE | MERGE | PROC SQL | PROC MEANS | PROC UNIVARIATE | PROC FREQ | PROC CORR | PROC SGPLOT | PROC TRANSPOSE | PROC APPEND | PROC DATASETS DELETE | %MACRO / %MEND -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- INTRODUCTION Table of Con...
Read more

397.If a satellite has excellent signal strength but very high latency, can it still deliver good quality communication? Why or why not?A Sas Study

-
Image
If a satellite has excellent signal strength but very high latency, can it still deliver good quality communication? Why or why not?A Sas Study -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- HERE IN THIS PROJECT WE USED THESE SAS STATEMENTS — DATA STEP | PROC SQL |  PROC PRINT | PROC SGPLOT | MACROS | PROC CORR | PROC MEANS | PROC FREQ | PROC UNIVARIATE | SET | APPEND | PROC TRANSPOSE | PROC DATASETS DELETE | DATA FUNCTIONS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- INTRODUCTION Satellite communication is a backbone of modern connectivity—supporting  GPS, TV broadcasting, military operations, disaster management, banking, a...
Read more

401.How Efficient Are Global Data Centers? A Complete SAS Analytics Study

-
Image
How Efficient Are Global Data Centers? A Complete SAS Analytics Study -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- HERE IN THIS PROJECT WE USED THESE SAS STATEMENTS — DATA STEP | PROC SQL |  PROC PRINT | PROC SGPLOT | MACROS | PROC CORR | PROC MEANS | PROC FREQ | PROC UNIVARIATE | APPEND PROC TRANSPOSE | PROC DATASETS DELETE | DATA FUNCTIONS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1. INTRODUCTION Modern data centers are the backbone of cloud computing, AI, banking, healthcare, and government systems. They consume massive power, require efficient cooling, and must ensure zero downtime . This project simulates global data c...
Read more