
- 26th Jan 2023
- 06:03 am
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;