Hi,
I have problem generating a hid variable.
I want to reproduce an exact clone of my
hhid. It is 12 characters long.
I wish somebody out there could help me.
(A copy and paste in notepad would produce
better tables).
. use amhr41rt, clear
. li hhid hv001 hv002 hv003 hv021 hv022 in 1/20
+------------------------------------------------------+
| hhid hv001 hv002 hv003 hv021 hv022 |
|------------------------------------------------------|
1. | 1 2 1 2 1 1 1 |
2. | 1 3 1 3 1 1 1 |
3. | 1 5 1 5 2 1 1 |
4. | 1 6 1 6 1 1 1 |
5. | 1 7 1 7 2 1 1 |
|------------------------------------------------------|
6. | 1 8 1 8 1 1 1 |
7. | 1 9 1 9 1 1 1 |
8. | 1 10 1 10 1 1 1 |
9. | 1 11 1 11 2 1 1 |
10. | 1 12 1 12 1 1 1 |
|------------------------------------------------------|
11. | 1 13 1 13 1 1 1 |
12. | 1 14 1 14 2 1 1 |
13. | 1 15 1 15 2 1 1 |
14. | 1 16 1 16 1 1 1 |
15. | 1 17 1 17 2 1 1 |
|------------------------------------------------------|
16. | 1 18 1 18 2 1 1 |
17. | 1 19 1 19 3 1 1 |
18. | 1 20 1 20 2 1 1 |
19. | 1 21 1 21 2 1 1 |
20. | 1 22 1 22 1 1 1 |
+------------------------------------------------------+
. tostring hv001 hv002, replace
hv001 was double now str3
hv002 was double now str2
. g hhid2 = hv001+hv002
. li hhid hhid2 hv001 hv002 hv003 hv021 hv022 in 1/20
+--------------------------------------------------------------+
| hhid hhid2 hv001 hv002 hv003 hv021 hv022 |
|--------------------------------------------------------------|
1. | 1 2 12 1 2 1 1 1 |
2. | 1 3 13 1 3 1 1 1 |
3. | 1 5 15 1 5 2 1 1 |
4. | 1 6 16 1 6 1 1 1 |
5. | 1 7 17 1 7 2 1 1 |
|--------------------------------------------------------------|
6. | 1 8 18 1 8 1 1 1 |
7. | 1 9 19 1 9 1 1 1 |
8. | 1 10 110 1 10 1 1 1 |
9. | 1 11 111 1 11 2 1 1 |
10. | 1 12 112 1 12 1 1 1 |
|--------------------------------------------------------------|
11. | 1 13 113 1 13 1 1 1 |
12. | 1 14 114 1 14 2 1 1 |
13. | 1 15 115 1 15 2 1 1 |
14. | 1 16 116 1 16 1 1 1 |
15. | 1 17 117 1 17 2 1 1 |
|--------------------------------------------------------------|
16. | 1 18 118 1 18 2 1 1 |
17. | 1 19 119 1 19 3 1 1 |
18. | 1 20 120 1 20 2 1 1 |
19. | 1 21 121 1 21 2 1 1 |
20. | 1 22 122 1 22 1 1 1 |
+--------------------------------------------------------------+
. g hhid3 = "hv001"+" "+"hv002"
. li hhid* hv001 hv002 hv003 hv021 hv022 in 1/20
+----------------------------------------------------------------------------+
| hhid hhid2 hhid3 hv001 hv002 hv003 hv021
hv022 |
|----------------------------------------------------------------------------|
1. | 1 2 12 hv001 hv002 1 2 1 1
1 |
2. | 1 3 13 hv001 hv002 1 3 1 1
1 |
3. | 1 5 15 hv001 hv002 1 5 2 1
1 |
4. | 1 6 16 hv001 hv002 1 6 1 1
1 |
5. | 1 7 17 hv001 hv002 1 7 2 1
1 |
|----------------------------------------------------------------------------|
6. | 1 8 18 hv001 hv002 1 8 1 1
1 |
7. | 1 9 19 hv001 hv002 1 9 1 1
1 |
8. | 1 10 110 hv001 hv002 1 10 1 1
1 |
9. | 1 11 111 hv001 hv002 1 11 2 1
1 |
10. | 1 12 112 hv001 hv002 1 12 1 1
1 |
|----------------------------------------------------------------------------|
11. | 1 13 113 hv001 hv002 1 13 1 1
1 |
12. | 1 14 114 hv001 hv002 1 14 2 1
1 |
13. | 1 15 115 hv001 hv002 1 15 2 1
1 |
14. | 1 16 116 hv001 hv002 1 16 1 1
1 |
15. | 1 17 117 hv001 hv002 1 17 2 1
1 |
|----------------------------------------------------------------------------|
16. | 1 18 118 hv001 hv002 1 18 2 1
1 |
17. | 1 19 119 hv001 hv002 1 19 3 1
1 |
18. | 1 20 120 hv001 hv002 1 20 2 1
1 |
19. | 1 21 121 hv001 hv002 1 21 2 1
1 |
20. | 1 22 122 hv001 hv002 1 22 1 1
1 |
+----------------------------------------------------------------------------+
. g hhid4 = hv001+" "+hv002
. li hhid* hv001 hv002 hv003 hv021 hv022 in 1/20
+------------------------------------------------------------------------------------+
| hhid hhid2 hhid3 hhid4 hv001 hv002 hv003
hv021 hv022 |
|------------------------------------------------------------------------------------|
1. | 1 2 12 hv001 hv002 1 2 1 2 1
1 1 |
2. | 1 3 13 hv001 hv002 1 3 1 3 1
1 1 |
3. | 1 5 15 hv001 hv002 1 5 1 5 2
1 1 |
4. | 1 6 16 hv001 hv002 1 6 1 6 1
1 1 |
5. | 1 7 17 hv001 hv002 1 7 1 7 2
1 1 |
|------------------------------------------------------------------------------------|
6. | 1 8 18 hv001 hv002 1 8 1 8 1
1 1 |
7. | 1 9 19 hv001 hv002 1 9 1 9 1
1 1 |
8. | 1 10 110 hv001 hv002 1 10 1 10 1
1 1 |
9. | 1 11 111 hv001 hv002 1 11 1 11 2
1 1 |
10. | 1 12 112 hv001 hv002 1 12 1 12 1
1 1 |
|------------------------------------------------------------------------------------|
11. | 1 13 113 hv001 hv002 1 13 1 13 1
1 1 |
12. | 1 14 114 hv001 hv002 1 14 1 14 2
1 1 |
13. | 1 15 115 hv001 hv002 1 15 1 15 2
1 1 |
14. | 1 16 116 hv001 hv002 1 16 1 16 1
1 1 |
15. | 1 17 117 hv001 hv002 1 17 1 17 2
1 1 |
|------------------------------------------------------------------------------------|
16. | 1 18 118 hv001 hv002 1 18 1 18 2
1 1 |
17. | 1 19 119 hv001 hv002 1 19 1 19 3
1 1 |
18. | 1 20 120 hv001 hv002 1 20 1 20 2
1 1 |
19. | 1 21 121 hv001 hv002 1 21 1 21 2
1 1 |
20. | 1 22 122 hv001 hv002 1 22 1 22 1
1 1 |
+------------------------------------------------------------------------------------+
. g l1=length(hhid)
. g l2=length(hhid4)
. su l1 l2
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
l1 | 5980 12 0 12 12
l2 | 5980 5.211204 .7336612 3 6
. g str12 hhid5 = hv001+" "+hv002
. g l3=length(hhid5)
. li hhid* hv001 hv002 hv003 hv021 hv022 in 1/20
+--------------------------------------------------------------------------------------------+
| hhid hhid2 hhid3 hhid4 hhid5 hv001 hv002
hv003 hv021 hv022 |
|--------------------------------------------------------------------------------------------|
1. | 1 2 12 hv001 hv002 1 2 1 2 1 2
1 1 1 |
2. | 1 3 13 hv001 hv002 1 3 1 3 1 3
1 1 1 |
3. | 1 5 15 hv001 hv002 1 5 1 5 1 5
2 1 1 |
4. | 1 6 16 hv001 hv002 1 6 1 6 1 6
1 1 1 |
5. | 1 7 17 hv001 hv002 1 7 1 7 1 7
2 1 1 |
|--------------------------------------------------------------------------------------------|
6. | 1 8 18 hv001 hv002 1 8 1 8 1 8
1 1 1 |
7. | 1 9 19 hv001 hv002 1 9 1 9 1 9
1 1 1 |
8. | 1 10 110 hv001 hv002 1 10 1 10 1 10
1 1 1 |
9. | 1 11 111 hv001 hv002 1 11 1 11 1 11
2 1 1 |
10. | 1 12 112 hv001 hv002 1 12 1 12 1 12
1 1 1 |
|--------------------------------------------------------------------------------------------|
11. | 1 13 113 hv001 hv002 1 13 1 13 1 13
1 1 1 |
12. | 1 14 114 hv001 hv002 1 14 1 14 1 14
2 1 1 |
13. | 1 15 115 hv001 hv002 1 15 1 15 1 15
2 1 1 |
14. | 1 16 116 hv001 hv002 1 16 1 16 1 16
1 1 1 |
15. | 1 17 117 hv001 hv002 1 17 1 17 1 17
2 1 1 |
|--------------------------------------------------------------------------------------------|
16. | 1 18 118 hv001 hv002 1 18 1 18 1 18
2 1 1 |
17. | 1 19 119 hv001 hv002 1 19 1 19 1 19
3 1 1 |
18. | 1 20 120 hv001 hv002 1 20 1 20 1 20
2 1 1 |
19. | 1 21 121 hv001 hv002 1 21 1 21 1 21
2 1 1 |
20. | 1 22 122 hv001 hv002 1 22 1 22 1 22
1 1 1 |
+--------------------------------------------------------------------------------------------+
. assert hhid==hhid5
5980 contradictions in 5980 observations
assertion is false
r(9);
. su l1 l2 l3
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
l1 | 5980 12 0 12 12
l2 | 5980 5.211204 .7336612 3 6
l3 | 5980 5.211204 .7336612 3 6
Best regards.
Amadou.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
