Hi all,
I'm running into some data conversion issues and I'm hoping to get some guidance. Currently, I have a variable from the National Survey for Families and Households (NSFH) that is coded numerically. I am attempting to merge this data set by occupation using the ONET Database due to the SOC codes. The SOC codes are written as 11-1031.00, 33-9099.00, etc. When I generate a "job" variable to replace the NSFH variable, the resulting output is the answer what Stata believes is an equation. Thus, my variable values become negative. How do I generate the "job" variable to be a string so that Stata doesn't calculate the perceived equation? I'm attaching my syntax as well as the output below for your review:
https://drive.google.com/file/d/1piLh3FxOxH8McLWesh9hANFRoM9Kb_oJ/view?usp=drive_link
https://drive.google.com/file/d/1KUyJeVHP6bs5XtX8Pyp3OPI0rA07iTfZ/view?usp=drive_link
Any help to make my new "job" variable a string variable so I can merge my data sets would be greatly appreciated!
I'm running into some data conversion issues and I'm hoping to get some guidance. Currently, I have a variable from the National Survey for Families and Households (NSFH) that is coded numerically. I am attempting to merge this data set by occupation using the ONET Database due to the SOC codes. The SOC codes are written as 11-1031.00, 33-9099.00, etc. When I generate a "job" variable to replace the NSFH variable, the resulting output is the answer what Stata believes is an equation. Thus, my variable values become negative. How do I generate the "job" variable to be a string so that Stata doesn't calculate the perceived equation? I'm attaching my syntax as well as the output below for your review:
https://drive.google.com/file/d/1piLh3FxOxH8McLWesh9hANFRoM9Kb_oJ/view?usp=drive_link
https://drive.google.com/file/d/1KUyJeVHP6bs5XtX8Pyp3OPI0rA07iTfZ/view?usp=drive_link
Any help to make my new "job" variable a string variable so I can merge my data sets would be greatly appreciated!
Comment