id in str format: how to compute summary statistics with this type of data?

[Michael Duarte Goncalves]

Hi everyone,

I have an id variable in string format, and I am unable to produce summary statistics with this type of id.

And when I use destring, it gives me following error:

. destring id, replace
id: contains nonnumeric characters; no replace

Just a small note: My id variable is of type "BD5fe56fef5...".
Thank you very much for your help.

Best,
Michael

[Andrew Musau]

It appears that you need encode. See

help encode

[Michael Duarte Goncalves]

Thanks Andrew Musau. But when I do encode, I obtain this message:

. encode id, gen(id2)
too many values
r(134);

In fact, I have more than 1,200,000 IDs.

[Andrew Musau]

egen id2= group(id)

[Michael Duarte Goncalves]

Hi Andrew Musau,

Thank you so much for the provided code.
It works indeed.

Best,

Michael