I have a date variable that is currently formatted as YYYY-MM-DD, and is already a date/numeric variable type.    How can I change the format to YYYYMMDD without the dashes separating the year, month, and day?  ... View more

Hello!   I have a data set with Street, City, State, and ZipCode but some of the data only contain City and State and are missing ZipCode.    I know that the SASHELP.ZIPCODE library contains ZipCode data for City and States. How would I be able to:  Take the instances that are missing ZipCode --> Take State and City that are present --> Compare to the SASHELP.ZIPCODE library and then --> Return the ZipCode value stored in SASHELP.ZIPCODE library if the City and State values match the StateCode and (City or Alias_CityN)    Really lost and any guidance is appreciated!    ... View more