%LET Location=M:\01_SAS\A_XNC_Datamart\SASPrograms\09_IPEDS\2020-2021\2020-2021\202003_Fall\03_Completions\;
Libname SAS "&Location";

Data newData;
	INFILE "&Location.section07_29july2020_curric_prog_titles.txt"
	Missover delimiter='~';
	INPUT Code :$6. / 
			Title :$50. /
			OldCIP :$10. /
			NewCip :$10. /
			Coor :$50.;
Run;

Proc Export Data=NewData File="&Location.CipCodes.csv" replace;
Proc Export Data=NewData File="&Location.CipCodes.xlsx" dbms=xlsx replace;
Data SAS.CIPCrosswalk; set newData; Run;