/*Importing an excel file*/
libname car 'c:/';
proc import out=car.auto
datafile="c:/auto.xls"
dbms=excel2000  replace;
sheet="auto";
getnames=yes;
run;

/*Analyzing the mean and frequency
of the data*/
proc means data=car.auto;
run;
proc freq data=car.auto;
run;

/*Finding correlations between a pair of  variables*/
proc corr data=car.auto;
run;

/*Droping and keeping variables*/
data car.est2 (keep=intercept mpg length);
set car.est1;
run;

data car.est3 (drop=price _model_ _depvar_ _type_ _RMSE_);
set car.est1;
run;

/*Exporting data to Excel data*/
proc export data=car.est2
outfile="c:\est.xls"
dbms=excel2000 replace;
run;