I transposed the following data and included DROP = _NAME_ to drop the variable that was formerly used to describe the labels of a set of values: Original list of variables: SSN, VisitDt, Measure, Value   PROC TRANSPOSE        DATA = WORK.V1        OUT = WORK.V2 (DROP = _NAME_                                                   RENAME = (COL1 = HtIn                                                                       COL2 = WtKg                                                                       COL3 = SBP                                                                       COL4 = DBP)                                                   );        VAR Value;        BY SSN VisitDt; RUN;   The new list of variables is:  SSN, VisitDt, _LABEL_, HtIn, WtKg, SBP, DBP   Why is _LABEL_ in the output? Shouldn't it have dropped? Any ideas on how to fix this? Thx! ... View more

I was asked to store the following format into a catalog ("MyFormats") in the WORK library. I'm confused if I need a separate step to do this, or if I can insert the statements into the existing step. Thank you!   PROC FORMAT;      VALUE YesNo      0 = 'No'      1 = 'Yes'      OTHER = 'Unexpected Value'; RUN; ... View more