I am using a data set which contains more than 600,000 observations on household expenditure.
The household expenditure varibale is " nf_value" which is string. (appeared in red color )
Then I coverted it into numeric using 'destring command' and named as "expend". (digits changed into blue color )
However, stils I can not do any mathematical operations correctly using "expend"
(I think it is beacuse some 'lable values' assinged to each cell.)
Can anybody help me to convert this 'blue digit column' in to 'black digit column'.; simply to normal integer or byte variable?
psu | a0 | snumber | hhno | nhh | result | nf_code | nf_value | expend |
39 | 96375 | 1 | 1 | 1 | 1 | 2001 | 400 | 400 |
39 | 96375 | 1 | 1 | 1 | 1 | 2002 | 48 | 48 |
39 | 96375 | 1 | 1 | 1 | 1 | 2003 | 87 | 87 |
39 | 96375 | 1 | 1 | 1 | 1 | 2101 | 350 | 350 |
0 Response to To convert 'blue digit ' column into 'black digit' column (string to normal variable)
Post a Comment