a.) You will need to sort the incoming dataset by state, sex, status as these are "by statement" variables. b.) On Transpose Properties: Under Options --> "Assign Columns" --> "Select Columns whose values define groups of records to transpose (BY statement): Provide state, sex & status as by variables. c.) On Transpose Properties: Under Options --> "Other Options" --> "Specify Proc Transpose options": Provide "name=year prefix=count" as input. d.) On Transpose Properties: Under Options --> "Additional Options" --> Select "Yes" for "Update the Metadata for the Target tables". d.) On Transpose Properties --> "Mappings" tab: Bring state, sex, status on the Target table. e.) On Transpose Properties --> "Mappings" tab: On the target table: Add "Year" as Character variable and "Count1" as numeric variable. f.) Run the Transpose Transformation. ... View more