topic SAS character to numeric in SAS Programming

SAS character to numeric

mariamon0 — Fri, 06 Mar 2020 16:02:09 GMT

I have an id variable in one study that is numeric

and a study_id variable in another study that is a character.

How do I harmonize these so that study_id=id as well as change them from character to numeric.

Kurt_Bremser — Fri, 06 Mar 2020 16:06:41 GMT

ID variables are not used for calculations, so store them as character.

Please supply examples for your character ID data, then we can show you how to convert the numbers to that.

mariamon0 — Fri, 06 Mar 2020 16:10:56 GMT

the id= 23434 just a number

the pid= 23423 is also just a number

study_id is BOM234 letters and numbers

I am trying to sort by just study_id

I want id and pid to be be renamed as study_id

Kurt_Bremser — Fri, 06 Mar 2020 16:17:46 GMT

So the first three digits of an ID correspond to the last three digits of the study_id?

mariamon0 — Fri, 06 Mar 2020 16:19:19 GMT

ID belongs to study 1

pid belongs to study 2

and study_id belongs to study 3

I am trying to combine information from all three studies.

but want one variable called study id to know who all the participants are

Kurt_Bremser — Fri, 06 Mar 2020 16:24:21 GMT

Is it important to know if a single person took part in more than one study? If yes, how can you correlate the entries?

If no, just format your purely numeric IDs (if they are actually stored in numeric variables in SAS) with z6. (to get an even length).