Hi all. I have a data set that has Geo ID in a column. It's ID for MCD, Minor Civil Division, and should be 5 digits long. Some of the numbers -should- have leading zeros. So Geo IDs in the data file like "210" should be "00210". But the file got manipulated some, and now it's a csv file and the leading zeros got removed. How can I code, in sas, to get back leading zeros and make this a string field. Some of the values need to add two leading zeros and some need to add only one leading zero. I'm including part of the file, with the GEO ID column. I'd like to leave the original column there and add a new column, called "Geo_ID_Txt" as the new geo id that's string and that has the leading zeros. Thanks ... View more

Hi all. I hope everyone is healthy. Suppose I have a data set like this: county Treatment Raceth Percent CountyA vaccine All 43 CountyB vaccine All 48 CountyC vaccine All 27 CountyD vaccine All 31 CountyE vaccine All 12 CountyF vaccine All 52 CountyG vaccine All 18 CountyA vaccine White 76 CountyB vaccine White 56 CountyD vaccine White 94 CountyE vaccine White 25 CountyF vaccine White 88 CountyG vaccine White 44 CountyA vaccine Black 93 CountyD vaccine Black 54 CountyE vaccine Black 57 CountyG vaccine Black 81 CountyB vaccine Asian 76 CountyC vaccine Asian 6 CountyD vaccine Asian 34 CountyD vaccine Hispanic 12 CountyF vaccine Hispanic 77 CountyG vaccine Hispanic 70   And another data set with ID codes for county county CountyID CountyA c01 CountyB c02 CountyC c03 CountyD c04 CountyE c05 CountyF c06 CountyG c07   How do I get a data set that has, for each race ethnic group, one line for each county ID code, even when the first data set has missing lines for those counties. So for example, the output data set would include these lines county CountyID Treatment Raceth Percent CountyA c01 vaccine Asian   CountyB c02 vaccine Asian 76 CountyC c03 vaccine Asian 6 CountyD c04 vaccine Asian 34 CountyE c05 vaccine Asian   CountyF c06 vaccine Asian   CountyG c07 vaccine Asian   CountyA c01 vaccine Hispanic   CountyB c02 vaccine Hispanic   CountyC c03 vaccine Hispanic   CountyD c04 vaccine Hispanic 12 CountyE c05 vaccine Hispanic   CountyF c06 vaccine Hispanic 77 CountyG c07 vaccine Hispanic 70   Thanks   ... View more