300.CREATION, SORTING, ANALYSIS, AND YEARLY REPORT GENERATION OF INDIAN NEWS CHANNEL DATA USING PROC PRINT, PROC SORT, AND PROC SQL WITH MACRO AUTOMATION

-

CREATION, SORTING, ANALYSIS, AND YEARLY REPORT GENERATION OF INDIAN NEWS CHANNEL DATA USING PROC PRINT, PROC SORT, AND PROC SQL WITH MACRO AUTOMATION


1. CREATE THE DATASET

options  nocenter;

%macro News_India;

  filename News Temp;

  data _null_;

   file News;

put "101 NDTV National 75 2024 4.7";

put "102 AajTak National 90 2024 4.8";

put "103 RepublicTV Politics 85 2024 4.6";

put "104 IndiaTV General 65 2023 4.3";

put "105 ABPNews National 70 2023 4.4";

put "106 ZeeNews Politics 60 2024 4.2";

put "107 TimesNow English 68 2024 4.5";

put "108 News18 Regional 50 2023 4.1";

put "109 TV9Telugu Regional 45 2024 4.3";

put "110 ETVBharat Regional 55 2024 4.4";

put "111 Wion English 40 2023 4.6";

put "112 CNNNews18 English 38 2024 4.5";

run;


data work.News_Channels;

 infile News;

 input NewsID ChannelName :$20. Category :$15. Viewers_Lakh Year Rating;

run;


2. DISPLAY THE DATASET

title "NEWS INDIA DATASET: LIST OF POPULAR CHANNELS AND RATINGS";

proc print data=News_Channels noobs label;

    label

        NewsID = "Channel ID"

        ChannelName = "News Channel Name"

        Category = "Category Type"

        Viewers_Lakh = "Viewership (in Lakhs)"

        Year = "Year of Survey"

        Rating = "Viewer Rating (1-5)";

run;

%Mend;


%News_India;

OUTPUT:

NEWS INDIA DATASET: LIST OF POPULAR CHANNELS AND RATINGS

Channel IDNews Channel NameCategory TypeViewership (in Lakhs)Year of SurveyViewer Rating (1-5)
101NDTVNational7520244.7
102AajTakNational9020244.8
103RepublicTVPolitics8520244.6
104IndiaTVGeneral6520234.3
105ABPNewsNational7020234.4
106ZeeNewsPolitics6020244.2
107TimesNowEnglish6820244.5
108News18Regional5020234.1
109TV9TeluguRegional4520244.3
110ETVBharatRegional5520244.4
111WionEnglish4020234.6
112CNNNews18English3820244.5

3. Sorting The Dataset

proc sort data=News_Channels out=News_Sorted;

 by  Descending Viewers_Lakh;

run;

proc print data=News_Sorted;

run;

OUTPUT:

ObsNewsIDChannelNameCategoryViewers_LakhYearRating
1102AajTakNational9020244.8
2103RepublicTVPolitics8520244.6
3101NDTVNational7520244.7
4105ABPNewsNational7020234.4
5107TimesNowEnglish6820244.5
6104IndiaTVGeneral6520234.3
7106ZeeNewsPolitics6020244.2
8110ETVBharatRegional5520244.4
9108News18Regional5020234.1
10109TV9TeluguRegional4520244.3
11111WionEnglish4020234.6
12112CNNNews18English3820244.5


4. Top Rated Channels (Rating = 4.6)

title "Top Rated News Channels In India(2024)";

proc sql;

 select NewsID,ChannelName,Category,Viewers_Lakh,Rating

 from News_Sorted

 where Rating >= 4.6

 Order by NewsID;

quit;

OUTPUT:

Top Rated News Channels In India(2024)

NewsIDChannelNameCategoryViewers_LakhRating
101NDTVNational754.7
102AajTakNational904.8
103RepublicTVPolitics854.6
111WionEnglish404.6

5. Average Viewership by Category

title "AVERAGE VIEWERSHIP BY CATEGORY";

proc sql;

 select NewsID,Category,Avg(Viewers_Lakh) as AvgViewers format=8.2

 from News_Sorted

 Group by Category;

quit;

OUTPUT:

AVERAGE VIEWERSHIP BY CATEGORY

NewsIDCategoryAvgViewers
107English48.67
112English48.67
111English48.67
104General65.00
101National78.33
102National78.33
105National78.33
106Politics72.50
103Politics72.50
109Regional50.00
108Regional50.00
110Regional50.00

6. Macro For Yearly Report

%macro news_report(year);

title "NEWS CHANNEL REPORT FOR YEAR &year";

proc print data=News_Channels;

 where year = &year;

 var NewsID ChannelName Year Viewers_Lakh Rating;

run;


proc sql;

 select Category,Avg(Viewers_Lakh) as AvgViewers format=8.2,

        avg(Rating) as AvgRating  format=3.1

 from News_Channels

 where year = &year

 group by category;

quit;

%mend;


%news_report(2024)

OUTPUT:

NEWS CHANNEL REPORT FOR YEAR 2024

ObsNewsIDChannelNameYearViewers_LakhRating
1101NDTV2024754.7
2102AajTak2024904.8
3103RepublicTV2024854.6
6106ZeeNews2024604.2
7107TimesNow2024684.5
9109TV9Telugu2024454.3
10110ETVBharat2024554.4
12112CNNNews182024384.5

NEWS CHANNEL REPORT FOR YEAR 2024

CategoryAvgViewersAvgRating
English53.004.5
National82.504.8
Politics72.504.4
Regional50.004.4

%news_report(2023)

OUTPUT:

NEWS CHANNEL REPORT FOR YEAR 2023

ObsNewsIDChannelNameYearViewers_LakhRating
4104IndiaTV2023654.3
5105ABPNews2023704.4
8108News182023504.1
11111Wion2023404.6

NEWS CHANNEL REPORT FOR YEAR 2023

CategoryAvgViewersAvgRating
English40.004.6
General65.004.3
National70.004.4
Regional50.004.1




To Visit Our Previous Online Streaming Flatform Dataset:Click Here
To Visit Our Previous Statistical Evaluation Of Clinical Trials:Click Here
To Visit Our Previous Unlocking Retail Insights Dataset:Click Here
To Visit Our Previous Sas Interview Questions-1:Click Here



Follow Us On : 


 


--- FOLLOW OUR BLOG FOR MORE INFORMATION.

--->PLEASE DO COMMENTS AND SHARE OUR BLOG.

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 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Table of Contents 1. ...
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