I would like to locate/organize my valid agency IDs (agencyid).
agencyid
CA0006
TN0106
NY0009
LA0035
TN0105
TN01o
CA0017
cA0006
La0035
The correct structure of the agency ID should be the state letters = 4 numbers ex,. (NY1111)The first thing I wanted to do is to make the first two letter of my agencyid variable upper case and maybe code as 9 (invalid ids) the ids that do not have the correct structure (NY1111) such as id TN01o. How can I do this?? thank you!
Thank you!
agencyid
CA0006
TN0106
NY0009
LA0035
TN0105
TN01o
CA0017
cA0006
La0035
The correct structure of the agency ID should be the state letters = 4 numbers ex,. (NY1111)The first thing I wanted to do is to make the first two letter of my agencyid variable upper case and maybe code as 9 (invalid ids) the ids that do not have the correct structure (NY1111) such as id TN01o. How can I do this?? thank you!
Thank you!
Last edited: