Hi,
I`m fairly new to Stata and I know this question is previously answered however I could not make it work for me.

This is the type of data I`m working with:

id date r i
1 2002_11 1.307071 .87494
1 2002_12 1.403008 1.019082
1 2003_01 1.570926 1.152942
1 2003_02 1.894784 1.307366
1 2003_03 1.798847 1.235295

This is the command i`m using:

reshape wide r i, i(id) j(date) str

This is the error:
values of variable date not unique within id
Your data are currently long. You are performing a reshape wide. You specified i(id) and j(date). There are observations
within i(id) with the same value of j(date). In the long data, variables i() and j() together must uniquely identify the
observations.

What do I need to change or add ?

Thanks for all replies.

Best,
Emerson