/*Submit a libname statement*/
libname sasdata2 "E:\Epid759\sasdata2";


/*Question 1: Proc Contents*/
proc contents data=sasdata2.wave1 varnum;
run;
proc contents data=sasdata2.wave2 varnum;
run;
proc contents data=sasdata2.wave3 varnum;
run;


/*Question 2: Proc Means*/
proc means data=sasdata2.wave1 ;
run;
proc means data=sasdata2.wave2 ;
run;
proc means data=sasdata2.wave3 ;
run;


/*Question 3: Proc Print*/
proc print data=sasdata2.wave1(obs=25) ;
run;


/*Question 4: Stack the data*/
data sasdata2.allwaves;
  set sasdata2.wave1
      sasdata2.wave2
	  sasdata2.wave3;
run;
proc contents data=sasdata2.allwaves varnum;
run;
proc means data=sasdata2.allwaves;
  class round;
run;


/*Question 5: Explore the data*/
proc contents data=sasdata2.autism_demog varnum;
run;
proc contents data=sasdata2.autism_socialization varnum;
run;
proc means data=sasdata2.autism_demog;
run;
proc means data=sasdata2.autism_socialization;
run;
proc print data=sasdata2.autism_demog(obs=10);
run;
proc print data=sasdata2.autism_socialization(obs=10);
run;


/*Question 6: Sort the data*/
proc sort data=sasdata2.autism_demog;
  by newinit;
run;
proc sort data=sasdata2.autism_socialization;
  by newinit;
run;


/*Question 7; Merge the data*/
data sasdata2.autism_combined;
  merge sasdata2.autism_demog sasdata2.autism_socialization;
  by newinit;
run;
proc means data=sasdata2.autism_combined;
run;
proc print data=sasdata2.autism_combined(obs=10);
run;


/*Question 8: Create an Aggregated dataset*/
proc sort data=sasdata2.autism_combined;
  by newinit;
run;
proc means data=sasdata2.autism_combined noprint;
  by newinit;
  output out=sasdata2.autism_summary
         mean(vsae)= mean_vsae
		 mean(vsst)= mean_vsst
		 n(vsae)   = n_vsae
		 n(vsst)   = n_vsst;
run;


/*Question 9: Descriptives for new aggregated dataset*/
proc means data=sasdata2.autism_summary;
run;