Libname S3A3 'D:\STAT 3A03\Fall 2017\Data';
run;

PROC IMPORT out=S3A3.Fish
   datafile="D:\STAT 3A03\Fall 2017\Data\Fish.txt"
       DBMS=DLM
       REPLACE;
   Getnames=yes;
   Datarow=2;
run;

* Question 1(a);
PROC MEANS Data=S3A3.Fish Mean Var;
Var Age Length;
run;

* Question 1(b);
PROC SORT Data=S3A3.Fish OUT=S3A3.Fish_Sorted;
BY Age;
run;

PROC MEANS Data=S3A3.Fish_Sorted N Mean Var;
Var Length;
BY Age;
run;

* Question 2(a), 2(b);
* PROC PRINT automatically outputs the column (variable) names so parts (a) and (b);
* can be done together;
* Part (a) can also be done by simply opening the dataset once it has been imported;

PROC IMPORT out=S3A3.Heights
   datafile="D:\STAT 3A03\Fall 2017\Data\Heights.txt"
       DBMS=DLM
       REPLACE;
   Getnames=yes;
   Datarow=2;
run;

PROC PRINT Data=S3A3.Heights(obs=10);
run; 

* Question 2(c);
PROC MEANS Data=S3A3.Heights Min Q1 Median Q3 Max;
VAR Mheight Dheight;
run;

* Question 2(d);
PROC MEANS Data=S3A3.Heights Mean CLM;
VAR Mheight Dheight;
run;