ods rtf file="/folders/myfolders/project/output.rtf";
/*Objective 1*/
proc import datafile="/folders/myfolders/project/Ana.xlsx"
out=project dbms=xlsx replace;
sheet="Sheet1";
getnames=YES;
run;
proc univariate data=project normal;
var Branch1;
title "Branch 1";
run;
proc univariate data=project normal;
var Branch2;
title "Branch 2";
run;
proc univariate data=project normal;
var Branch3;
title "Branch 3";
run;
data Branch;
input Branch$ Sales@@;
datalines;
1 16 2 85 3 14
1 17 2 67 3 12
1 7 2 6 3 12
1 12 2 24 3 53
1 121 2 123 3 6
1 86 2 84 3 21
1 72 2 127 3 0
1 37 2 101 3 4
1 26 2 37 3 0
1 20 2 2 3 0
1 31 2 101 3 4
1 51 2 63 3 53
1 10 2 40 3 54
1 70 2 100 3 33
1 20 2 78 3 0
1 34 2 14 3 38
1 23 2 15 3 0
1 68 2 17 3 3
1 3 2 93 3 31
1 9 2 102 3 0
1 28 2 25 3 10
1 8 2 53 3 5
1 7 2 25 3 52
1 12 2 2 3 0
1 32 2 45 3 37
1 76 2 146 3 10
1 24 2 287 3 12
1 131 2 44 3 1
1 212 2 85 3 24
1 22 2 33 3 681

;
proc npar1way data=Branch;
class Branch;
var Sales;
run;
/*Objective 2*/
proc import datafile="/folders/myfolders/project/Date.xlsx"
out=Date dbms=xlsx replace;
sheet="Sheet1";
getnames=YES;
run;
proc sort data=Date;
by Date;
run;
proc transpose data=Date out=Datelong name=Date1;
by Date;
var Branch1 Branch2 Branch3;
run;
proc freq data=Datelong;
tables Date1*Date*col1/ cmh2 scores=rank;
run;
/*Objective 3*/
proc import datafile="/folders/myfolders/project/Ana3.xlsx"
out=project3 dbms=xlsx replace;
sheet="Sheet1";
getnames=YES;
run;
data project3;
set project3;
Branch123 = Branch1+Branch2+Branch3;
proc npar1way data=project3;
class Half;
var Branch123;
run;
ods rtf close;