**1. Change the file tree to work with your system**.
**   An easy way to do this is to copy the file tree out of the address line of Windows Explorer**.

*****************************************************************************************************************.
*****EDIT HERE		EDIT HERE**********************************************.
*****************************************************************************************************************.

FILE HANDLE ST_IMPORT /NAME="C:\filename.csv".
**the save command will save the file to the same folder as was used in the import handle***.

FILE HANDLE ST_SAVE    /NAME="COHORT_DEMO.SAV".

*****************************************************************************************************************.
*****YOU MAY  RUN NOW **********************************************.
*****************************************************************************************************************.

GET DATA  /TYPE = TXT
 /FILE = ST_IMPORT
 /DELCASE = LINE
 /DELIMITERS = ","
 /QUALIFIER = '"'
 /ARRANGEMENT = DELIMITED
 /FIRSTCASE = 2
 /IMPORTCASE = ALL
 /VARIABLES =
 Your_Unique_Identifier 	A16
 First_Name 		A20
 Middle_Initial 		A1
 Last_Name 		A20
 Name_Suffix 		F5.0
 Requester_Return_Field A50
 Record_Found 	A1
 SD1 		A8
 College_Code_Branch 	A9
 College_Name 	A40
 College_State 	A2
 Year2Year4 		F1.0
 Public_Private 	A7
 EB1	 	A8
 EE1	 	A8
 Enrollment_Status 	A1
 Graduated 		A1
 GD1	 	A8
 Degree_Title 		A80
 Major 		A80
 College_Sequence 	F2.0
.
COMPUTE ORIG_ROW=$CASENUM.
VARIABLE WIDTH  ALL (10).
EXE.


*REFORMAT DATES FROM ALPHA TO DATE FORMAT*.
	COMPUTE SearchDate=	  DATE.DMY(NUMBER(SUBSTR(SD1,7,2),F2.0),NUMBER(SUBSTR(SD1,5,2),F2.0),NUMBER(SUBSTR(SD1,1,4),F4.0)).
	COMPUTE EnrollmentBegin= DATE.DMY(NUMBER(SUBSTR(EB1,7,2),F2.0),NUMBER(SUBSTR(EB1,5,2),F2.0),NUMBER(SUBSTR(EB1,1,4),F4.0)).
	COMPUTE EnrollmentEnd=	DATE.DMY(NUMBER(SUBSTR(EE1,7,2),F2.0),NUMBER(SUBSTR(EE1,5,2),F2.0),NUMBER(SUBSTR(EE1,1,4),F4.0)).
	COMPUTE GraduationDate=	DATE.DMY(NUMBER(SUBSTR(GD1,7,2),F2.0),NUMBER(SUBSTR(GD1,5,2),F2.0),NUMBER(SUBSTR(GD1,1,4),F4.0)).
	COMPUTE Requester_Return_Field=REPLACE(Requester_Return_Field,"_","").
	FORMAT SEARCHDATE EnrollmentBegin EnrollmentEnd GraduationDate(ADATE) .
	EXE.
	DELETE VARIABLES EB1 EE1 GD1 SD1.