Hi, I have a continuous variable (median household income) from my census data that I am trying to convert into an ordinal variable (i.e. I'm trying to make median household income groups). I attempted to split up the variable (FSA_medincome_household) into 12 groups based on an incremental income of $10,000, using this code:

egen FSA_medincome_household_743ord = cut(FSA_medincome_household_743), at(10000(10000)120000) label


The problem here is that all my variables get coded as missing. I am not sure if it has something to do with the large numbers for the variable or because it's represented as a long storage type.


Can anyone help me figure out what I am doing wrong?

Thanks in advance!