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