SAS class R

[Kurt_Bremser]

How were the formats created? Please post that code.

Do the types of the variables correspond to the types of the formats?

Your code creates a variable that is never assigned a value.

You will have to re-sort your datasets.

When posting logs, always include the whole code, not just the messages.

[tagawa_sas · Accepted solution]

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