Hello Ruth, I believe that we are in the same SAS class! As previously stated, your code creates a variable that is never assigned a value, so I think that all your formats were deleted somehow. I would first try to use the formats in general, then if that didn't work then I would create the formats again.   To do this, you would need to create an excel sheet that is titled "Data Map - Hypertension Study.xlsx", in addition to having a spreadsheet in this titled "Format Control Sheet". In the sheet you could copy and paste the table that I have listed below, which has all the formats in the appropriate way I believe.   %LET CourseRoot = *Whatever your course root is*; LIBNAME HypTabs "&CourseRoot/Hypertension Study/Data/3_Tabulations"; LIBNAME HypImpt "&CourseRoot/Hypertension Study/Data/2_Import"; LIBNAME HypFmts XLSX "&CourseRoot\Hypertension Study\Documents\Data Map - Hypertension Study.xlsx"; PROC FORMAT CNTLIN = HypFmts.'Format Control Sheet'N LIBRARY = HypTabs.HypFormats; RUN;   FMTNAME TYPE HLO START END SEXCL EEXCL LABEL CODCd N   1 1     Heart Disease CODCd N   2 2     Heart Failure CODCd N   3 3     Stroke CODCd N   4 4     Other COD DBPHypCats N L   60   Y Below Normal DBPHypCats N   60 80   Y Normal DBPHypCats N   80 90   Y High Normal DBPHypCats N   90 100   Y Stage 1 Hypertension DBPHypCats N   100 110   Y Stage 2 Hypertension DBPHypCats N H 110       Stage 3 Hypertension DBPHypYN N L   90   Y No Hypertension DBPHypYN N H 90       Hypertension GenderCd N   1 1     Male GenderCd N   2 2     Female IndVbl N   0 0     No IndVbl N   1 1     Yes SBPHypCats N L   90   Y Below Normal SBPHypCats N   90 120   Y Normal SBPHypCats N   120 140   Y High Normal SBPHypCats N   140 160   Y Stage 1 Hypertension SBPHypCats N   160 180   Y Stage 2 Hypertension SBPHypCats N H 180     Y Stage 3 Hypertension SBPHypYN N L   140   Y No Hypertension SBPHypYN N H 140       Hypertension EthCd C   H H     Hispanic EthCd C   N N     Non-Hispanic EthRaceCd C   HIS HIS     Hispanic EthRaceCd C   NHA NHA     NH Asian EthRaceCd C   NHB NHB     NH Black EthRaceCd C   NHO NHO     NH Other Race EthRaceCd C   NHW NHW     NH White RaceCd C   A A     Asian RaceCd C   B B     Black RaceCd C   O O     Other Race RaceCd C   W W     White StateCd C   IA IA     Iowa StateCd C   MS MS     Mississippi StateCd C   UT UT     Utah   Hope this helps, Alex ... View more