I am getting an error message as 'variable id does not uniquely identify the observations' while reshaping the data from wide to long. I checked my id variable i.e. FIPS and found that there are duplicate observations. However, I cannot remove the duplicates of the id variable FIPS as it will remove observations of another variable called uw_id. I want the variable uw_id for analysis. Removing observations of uw_id by dropping duplicates of FIPS will not serve my analysis. I will appreciate if I receive any help.