LIBNAME CAHSEE 'D:\SAS CAHSEE2005';

PROC IMPORT OUT = CAHSEE.CASHEE2005 
            DATAFILE = "D:\SAS CAHSEE2005\cahsee_2005_2nd.txt" 
            DBMS=TAB REPLACE;
     GETNAMES=YES;
     DATAROW=2; 
     GUESSINGROWS=20; 
RUN;

PROC CONTENTS DATA = CAHSEE.CASHEE2005;
RUN;

PROC PRINT DATA=CAHSEE.CASHEE2005 (OBS = 10);
RUN;

PROC FREQ DATA = CAHSEE.CASHEE2005;
	TITLE 'Frequency Counts of the data';
	TABLES CountyName;
RUN;

PROC FREQ DATA = CAHSEE.CASHEE2005 (WHERE = ( CountyName = 'Alameda' ));
	TITLE 'Frequency Counts of the data';
	TABLES DistrictName;
RUN;

PROC FREQ DATA = CAHSEE.CASHEE2005 (WHERE = ( CountyName = 'Alameda' AND DistrictName = 'Alameda City Unified'));
	TITLE 'Frequency Counts of the data';
	TABLES SchoolName;
RUN;

DATA ALAMEDA;
	SET CAHSEE.CASHEE2005;
	IF ( CountyName = 'Alameda' AND DistrictName = 'Alameda City Unified'
		AND (SchoolName = 'Alameda High' OR SchoolName = 'Encinal High') );
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 2));
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 3));
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 4));
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 2));
	TITLE 'Grade 10';
	VAR SchoolName MathTestDate MathNumberPassed MathNumberTested MathPercentPassed MathPSPercentCorrect;
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 3));
	TITLE 'Grade 11';
	VAR SchoolName MathTestDate MathNumberPassed MathNumberTested MathPercentPassed MathPSPercentCorrect;
RUN;

PROC PRINT DATA = ALAMEDA (WHERE = (SummaryType = 4));
	TITLE 'Grade 12';
	VAR SchoolName MathTestDate MathNumberPassed MathNumberTested MathPercentPassed MathPSPercentCorrect;
RUN;