I need a count of the Unknown which is the value of 'Z' in the race fields. I need to add variables, Multi-Racial and Unknown. And the matrix I provided is an example of the data. The variable names were RWHT = White, RBLK = Black, RASN = Asian, RAIN = American Indian, RHIP = Hawaiian/Pacific Islander, HISP = Hispanic. Need to add Mutliracial and Unknow. Mutliracial would be if any two or more of RWHT, RBLK, RASN, RAIN, RHIP = Y. Unknown would be if any race/ethinicty = Z and all others = N. The result I am looking for would be as follows: Unduplicated Headcount 2022 Asian/Pacific Islanders 128 Black (non-Hispanic) 595 Hispanic 478 American Indian/Alaskan Native 34 White (non-Hispanic) 4,552 Multi Racial 132 Unknown 100 The matrix is a sample of the actual date from the file I am reading into SAS.
... View more