proc import datafile= '/home/sadhanashukla93/ListenData/Sample/sample_excel_NEW.xlsx'
out=session7
dbms=xlsx
replace;
Getnames=yes;
run;

proc means data=session7 sum mean min max median;
class educationfield;
var monthlyincome;
run;


/* Problem 2 */
proc means data=session7 mean median nway;
class department educationfield;
var monthlyincome;
run;

/* Problem 3 */
proc means data=session7 sum;
where monthlyincome >=2000;
class department;
var monthlyincome;
output out=outprob3;
run;

/* Problem 4 */

/* proc sort data=session7; */
/* by jobrole; */
/* run; */

proc means data=session7 ;
class jobrole educationfield;
output out=outprob4 (where=(_type_=1) ;
output out=outprob3 (where=(_type_=2);
run;

/* Problem 5 */

Proc format;
value $ edu.;
1 ='Below College'
2 = 'College' 
3= 'Bachelor' 
4 ='Master'
5= 'Doctor';
run;

proc means data= session7 nway ;
class department education;
var monthlyrate hourlyrate;
format Education edu.;
output out = prblm5 ;

run;

/* Problem 6 */

proc means data=session7;
class jobrole department;
var monthlyincome hourlyrate;
output out= prob7 sum(monthlyincome)= mean(hourlyrate)=/autoname;
run;

/* Problem 7 */
DATE9.
DDMMYY8.
YYMMDD6.
YYMMDD8.
YYMMDD10.