proc import datafile="C:\Users\jarvah1\Downloads\DATA FOR EXERCISES-20210126\wage.xlsx"
DBMS=xlsx out=wage;
run;
proc print data=wage (obs=10);
run;
proc contents data=wage;
run;
* 1st way to put a comment;
/* 2nd way to put a comment */
proc means data=wage n mean std q1 median q3 maxdec=3;
var wage;
run;
* correlations;
proc corr data=wage outp=pear;
var wage educ exper tenure nonwhite female;
run;
proc export data=pear
outfile="C:\Users\jarvah1\Downloads\DATA FOR EXERCISES-20210126\pearson.xlsx"
dbms=xlsx;
run;
proc corr data=wage pearson spearman nosimple;
var wage educ exper tenure nonwhite female;
run;
ods graphics off;
proc reg data=wage;
model lwage=educ exper female / white;
*test educ=exper;
output out=out_wage 
predicted=fitted
residual=res;
run; quit;
proc print data=out_wage (obs=10);
var lwage educ exper female fitted res;
run;