I have two table which I am trying to UNION, however, I am facing an issue where data from one fo the table get missed out.
I am working on SAS DI 4.9.
Table 1
| Untitled1 | Untitled2 | Untitled3 | Untitled4 | Untitled5 | Untitled6 | Untitled7 | Untitled8 | Untitled9 |
| LWI93262167 | F | Change | 26.9 | 09-Dec-12 | A | T;T;F;F;F;T;F;T;T;F;T;F;F;F;T | ||
| VE98710787 | F | Change | 32.9 | 09-Dec-12 | B | T;F;F;T;T;F;T; ;T;F; ;F;F;F;T | ||
| SDG13502113 | F | No change | 25.02 | 09-Dec-12 | C | F;F;F;T;F;F;F;T;F;F; ;F;T;F;T | ||
| SDG38203520 | F | No change | 20.02 | 09-Dec-12 | D | T;T;F;T;F;T;T; ;F;F;T;F;T;F;T | ||
| LW93262167 | F | No change | 27.02 | 09-Dec-12 | E | T;T;F;F;F;T;F;T;F;F;T;F;T;F;T |
Properties of table
| Column | Type | length | Informat | Format |
| Untitled1 | Character | 23 | $CHAR23. | $CHAR23. |
| Untitled2 | Character | 8 | $8. | $8. |
| Untitled3 | Character | 15 | $CHAR15. | $CHAR15. |
| Untitled4 | Character | 8 | (None) | (None) |
| Untitled5 | Numeric | 8 | date. | date. |
| Untitled6 | Character | 500 | $CHAR500. | $CHAR500. |
| Untitled7 | Character | 50 | $CHAR50. | $CHAR50. |
| Untitled8 | Character | 10 | $CHAR10. | $CHAR10. |
| Untitled9 | Character | 1000 | $CHAR1000. | $CHAR1000. |
Table 2
| Untitled1 | Untitled2 | Untitled3 | Untitled4 | Untitled5 | Untitled6 | Untitled7 | Untitled8 | Untitled9 |
| 20170805_EAP_Account_Req_New_20180112_073647 | 1 | 4 | 32 | 05-Aug-17 |
|
properties of table
| Column | Type | length | Informat | Format |
| Untitled1 | Character | 46 | $46. | $46. |
| Untitled2 | Character | 8 | (None) | (None) |
| Untitled3 | Character | 8 | (None) | (None) |
| Untitled4 | Character | 8 | (None) | (None) |
| Untitled5 | Numeric | 8 | date. | date. |
| Untitled6 | Character | 8 | (None) | (None) |
| Untitled7 | Character | 8 | (None) | (None) |
| Untitled8 | Character | 8 | (None) | (None) |
| Untitled9 | Character | 8 | (None) | (None) |
My output has missing values
| Untitled1 | Untitled2 | Untitled3 | Untitled4 | Untitled5 | Untitled6 | Untitled7 | Untitled8 | Untitled9 |
| 4 | . | . | ||||||
| LWI93262167 | F | . | 26.9 | 12-Sep-12 | ||||
| VE98710787 | F | . | 32.9 | 12-Sep-12 | ||||
| SDG13502113 | F | . | 25.02 | 12-Sep-12 | ||||
| SDG38203520 | F | . | 20.02 | 12-Sep-12 | ||||
| LW93262167 | F | . | 27.02 | 12-Sep-12 |
can someone please explain or give me alternative
Why no one is answering.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.