When I run this code, SAS is automatically assigning formats and informats to all of my data when I only want a format on my date variable. Am I accidentally creating these formats and informats or I am missing something? Is there any way that I can get SAS to stop creating these Formats and Informats? I have copied the formats that I keep getting below. * Creating data for Iowa *;
DATA WORK.Vitals_IA ;
HtIn = HtCm * 2.54;
WtLb = WtKg * .454;
DROP HtCm WtKg;
SET HypImpt.Vit_IA (RENAME = (SSN = FedData));
SSN = PUT(FedData, 11.);
DROP FedData;
RUN;
* Creating data for Mississippi *;
DATA WORK.Vitals_MS (RENAME = (VisitDate = VisitDt Height = HtIn Weight = WtLb));
SET HypImpt.Mississippi_VS;
RUN;
* Creating data for Utah *;
DATA WORK.Vitals_UT;
LENGTH SSN $11.
pt1 $3.
pt2 $2.
pt3 $4.;
SET HypImpt.utah_vitals: (RENAME = (ApptDate = VisitDt));
IDs = STRIP(SSN);
pt1 = substr(IDs,1,3);
pt2 = substr(IDs,4,2);
pt3 = substr(IDs,6,4);
SSN = CATX('-', pt1, pt2, pt3);
RUN;
PROC TRANSPOSE
DATA = WORK.Vitals_UT
OUT = WORK.Vitals_UT2 (DROP = _NAME_ _LABEL_ RENAME = (Col1 = HtIn Col2 = WtLb Col3 = SBP Col4 = DBP));
VAR Value;
BY VisitDt SSN;
RUN;
* Creating Combined Data Set *;
DATA HypTabs.Vitals (LABEL = Vital Signs);
ATTRIB SSN LABEL= 'Social Security Number' LENGTH = $11.
VisitDt LABEL= 'Visit Date' LENGTH = 8. FORMAT = DATE9.
HtIn LABEL = 'Height (In)' LENGTH = 8.
WtLb LABEL= 'Weight (Lb)' LENGTH = 8.
SBP LABEL= 'Systolic BP (mmHg)' LENGTH = 8.
DBP LABEL= 'Diastolic BP (mmHg)' LENGTH = 8.;
KEEP SSN VisitDt HtIn WtLb SBP DBP;
SET WORK.Vitals_IA
WORK.Vitals_MS
WORK.Vitals_UT2;
RUN;
PROC SORT DATA= HypTabs.Vitals;
BY SSN VisitDt;
RUN;
PROC CONTENTS DATA= HypTabs.Vitals VARNUM;
RUN;
PROC PRINT DATA= HypTabs.Vitals (obs=1);
RUN; Variables in Creation Order# Variable Type Len Format Informat Label123456 SSN Char 11 $9. $9. Social Security Number VisitDt Num 8 DATE9. Visit Date HtIn Num 8 BEST. Height (In) WtLb Num 8 BEST. Weight (Lb) SBP Num 8 BEST12. Systolic BP (mmHg) DBP Num 8 BEST12. Diastolic BP (mmHg)
... View more