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

162.A COMPREHENSIVE ANALYSIS OF GLOBAL RENEWABLE ENERGY PROJECTS USING SAS PROCEDURES: PROC PRINT | PROC SORT | PROC MEANS | PROC FREQ | PROC GCHART | PROC SQL | PROC FORMAT | PROC REPORT | PROC TABULATE | PROC UNIVARIATE

on

A COMPREHENSIVE ANALYSIS OF GLOBAL RENEWABLE ENERGY PROJECTS USING SAS PROCEDURES: PROC PRINT | PROC SORT | PROC MEANS | PROC FREQ | PROC GCHART | PROC SQL | PROC FORMAT | PROC REPORT | PROC TABULATE | PROC UNIVARIATE


/*Creating a unique dataset centered around "Global Renewable Energy Projects"*/

data RenewableProjects;

    length 

        Project_Name $20 

        Country $15 

        Energy_Type $12 

        Status $20;

    input 

        Project_ID 

        Project_Name $ 

        Country $ 

        Energy_Type $ 

        Capacity_MW 

        Investment_USD_Million 

        Start_Year 

        Status $;

    datalines;

1 SolarOne USA Solar 150 300 2018 Operational

2 WindMax Germany Wind 200 500 2020 Under_Construction

3 HydroFlow Brazil Hydro 500 800 2015 Operational

4 GeoThermX Iceland Geothermal 100 250 2019 Operational

5 BioEnergyPlus India Biomass 75 150 2021 Planned

;

run;

proc print data=RenewableProjects;

    title "List of Global Renewable Energy Projects";

run;

Output:
                                                                        List of Global Renewable Energy Projects

Obs Project_Name Country Energy_Type Status Project_ID Capacity_MW Investment_USD_Million Start_Year
1 SolarOne USA Solar Operational 1 150 300 2018
2 WindMax Germany Wind Under_Construction 2 200 500 2020
3 HydroFlow Brazil Hydro Operational 3 500 800 2015
4 GeoThermX Iceland Geothermal Operational 4 100 250 2019
5 BioEnergyPlus India Biomass Planned 5 75 150 2021


proc sort data=RenewableProjects out=SortedProjects;

    by Country Start_Year;

run;

proc print;run;

Output:
                                                                           List of Global Renewable Energy Projects

Obs Project_Name Country Energy_Type Status Project_ID Capacity_MW Investment_USD_Million Start_Year
1 HydroFlow Brazil Hydro Operational 3 500 800 2015
2 WindMax Germany Wind Under_Construction 2 200 500 2020
3 GeoThermX Iceland Geothermal Operational 4 100 250 2019
4 BioEnergyPlus India Biomass Planned 5 75 150 2021
5 SolarOne USA Solar Operational 1 150 300 2018

 

proc means data=RenewableProjects mean maxdec=2;

    var Capacity_MW Investment_USD_Million;

    title "Average Capacity and Investment of Renewable Energy Projects";

run;

Output:
                                    Average Capacity and Investment of Renewable Energy Projects

                                                                The MEANS Procedure

Variable Mean
Capacity_MW
Investment_USD_Million
205.00
400.00

proc freq data=RenewableProjects;

    tables Energy_Type;

    title "Distribution of Projects by Energy Type";

run;

Output:
                                                Distribution of Projects by Energy Type

                                                           The FREQ Procedure

Energy_Type Frequency Percent Cumulative
Frequency		 Cumulative
Percent
Biomass 1 20.00 1 20.00
Geothermal 1 20.00 2 40.00
Hydro 1 20.00 3 60.00
Solar 1 20.00 4 80.00
Wind 1 20.00 5 100.00

proc gchart data=RenewableProjects;

    vbar Status / discrete;

    title "Number of Projects by Status";

run;


proc sql;

    select Project_Name, Country, Investment_USD_Million

    from RenewableProjects

    where Investment_USD_Million > 300;

quit;

Output:
Project_Name Country Investment_USD_Million
WindMax Germany 500
HydroFlow Brazil 800

proc format;

    value $EnergyFmt

        'Solar' = 'Solar Energy'

        'Wind' = 'Wind Energy'

        'Hydro' = 'Hydroelectric'

        'Geothermal' = 'Geothermal Energy'

        'Biomass' = 'Biomass Energy';

run;


proc print data=RenewableProjects;

    format Energy_Type $EnergyFmt.;

    title "Projects with Formatted Energy Types";

run;

Output:
                                                                 Projects with Formatted Energy Types

Obs Project_Name Country Energy_Type Status Project_ID Capacity_MW Investment_USD_Million Start_Year
1 SolarOne USA Solar Energy Operational 1 150 300 2018
2 WindMax Germany Wind Energy Under_Construction 2 200 500 2020
3 HydroFlow Brazil Hydroelectric Operational 3 500 800 2015
4 GeoThermX Iceland Geothermal Energy Operational 4 100 250 2019
5 BioEnergyPlus India Biomass Energy Planned 5 75 150 2021

proc report data=RenewableProjects nowd;

    column Country Capacity_MW;

    define Country / group;

    define Capacity_MW / analysis sum;

    title "Total Capacity by Country";

run;

Output:
                                                                Total Capacity by Country

Country Capacity_MW
Brazil 500
Germany 200
Iceland 100
India 75
USA 150


proc tabulate data=RenewableProjects;

    class Energy_Type Status;

    var Investment_USD_Million;

    table Energy_Type, Status*Investment_USD_Million*mean;

    title "Average Investment by Energy Type and Status";

run;

Output:
                                                          Average Investment by Energy Type and Status

  Status
Operational
Planned
Under_Construction
Investment_USD_Million Investment_USD_Million Investment_USD_Million
Mean Mean Mean
Energy_Type . 150.00 .
Biomass
Geothermal 250.00 . .
Hydro 800.00 . .
Solar 300.00 . .
Wind . . 500.00


proc univariate data=RenewableProjects;

    var Capacity_MW;

    histogram;

    title "Distribution of Project Capacities";

run;

Output:
                                                     Distribution of Project Capacities

                                                          The UNIVARIATE Procedure
                                                                Variable: Capacity_MW

Moments
N 5 Sum Weights 5
Mean 205 Sum Observations 1025
Std Deviation 171.75564 Variance 29500
Skewness 1.82160401 Kurtosis 3.47610241
Uncorrected SS 328125 Corrected SS 118000
Coeff Variation 83.7832392 Std Error Mean 76.8114575

Basic Statistical Measures
Location Variability
Mean 205.0000 Std Deviation 171.75564
Median 150.0000 Variance 29500
Mode . Range 425.00000
    Interquartile Range 100.00000

Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 2.668873 Pr > |t| 0.0559
Sign M 2.5 Pr >= |M| 0.0625
Signed Rank S 7.5 Pr >= |S| 0.0625

Quantiles (Definition 5)
Level Quantile
100% Max 500
99% 500
95% 500
90% 500
75% Q3 200
50% Median 150
25% Q1 100
10% 75
5% 75
1% 75
0% Min 75

Extreme Observations
Lowest Highest
Value Obs Value Obs
75 5 75 5
100 4 100 4
150 1 150 1
200 2 200 2
500 3 500 3


proc corr data=RenewableProjects;

    var Capacity_MW Investment_USD_Million;

    title "Correlation Between Capacity and Investment";

run;

Output:
                                                      Correlation Between Capacity and Investment

                                                                       The CORR Procedure

2 Variables: Capacity_MW Investment_USD_Million

Simple Statistics
Variable N Mean Std Dev Sum Minimum Maximum
Capacity_MW 5 205.00000 171.75564 1025 75.00000 500.00000
Investment_USD_Million 5 400.00000 257.39075 2000 150.00000 800.00000

Pearson Correlation Coefficients, N = 5
Prob > |r| under H0: Rho=0
  Capacity_MW Investment_USD_Million
Capacity_MW
1.00000
 
0.96843
0.0067
Investment_USD_Million
0.96843
0.0067
1.00000
 


proc freq data=RenewableProjects;

    tables Start_Year;

    title "Number of Projects Initiated Each Year";

run;

Output:
  
                                                         Number of Projects Initiated Each Year

                                                                  The FREQ Procedure

Start_Year Frequency Percent Cumulative
Frequency		 Cumulative
Percent
2015 1 20.00 1 20.00
2018 1 20.00 2 40.00
2019 1 20.00 3 60.00
2020 1 20.00 4 80.00
2021 1 20.00 5 100.00



PRACTICE AND COMMENT YOUR CODE: 

-->PLEASE FOLLOW OUR BLOG FOR MORE UPDATES.

TO FOLLOW OUR TELEGRAM CHANNEL CLICK HERE

Comments

Post a Comment