SAS Solution for Business Analysis Plan

• 26th Jan, 2023
• 15:53 PM

DM 'clear log';
proc datasets library=work kill nolist memtype=data; quit;

PROC IMPORT OUT= WORK.data 
            DATAFILE= "/home/u45002597/MGT585/Folder/concerts.csv" 
            DBMS=CSV REPLACE ;
            delimiter=',';
     GETNAMES=YES;
     DATAROW=2; 
RUN;

data data2 (drop=Date2);
format date E8601DZ.;
    set data;
date2 = strip(substr(strip(put(date,E8601DZ.)),1,10));
Year = input(substr(date2, 1 , 4),8.);
month = input(substr(date2, 6 , 2),8.);
day = input(substr(date2, 9 , 2),8.);
run;

* Concert by Year;

PROC FREQ DATA=data2;
    TABLES Year;
RUN;

PROC SGPLOT DATA = data2;
VBAR year;
RUN;

* Concerts by Month;

PROC FREQ DATA=data2;
    TABLES month;
RUN;

PROC SGPLOT DATA = data2;
VBAR month;
RUN;

* Concerts by Day;

PROC FREQ DATA=data2;
    TABLES Day;
RUN;

PROC SGPLOT DATA = data2;
VBAR Day;
RUN;