BookmarkSubscribeRSS Feed
Deepankar
Calcite | Level 5

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

 

Untitled1Untitled2Untitled3Untitled4Untitled5Untitled6Untitled7Untitled8Untitled9
LWI93262167FChange26.909-Dec-12AT;T;F;F;F;T;F;T;T;F;T;F;F;F;T  
VE98710787FChange32.909-Dec-12BT;F;F;T;T;F;T; ;T;F; ;F;F;F;T  
SDG13502113FNo change25.0209-Dec-12CF;F;F;T;F;F;F;T;F;F; ;F;T;F;T  
SDG38203520FNo change20.0209-Dec-12DT;T;F;T;F;T;T; ;F;F;T;F;T;F;T  
LW93262167FNo change27.0209-Dec-12ET;T;F;F;F;T;F;T;F;F;T;F;T;F;T  

 

Properties of table

ColumnTypelengthInformatFormat
Untitled1Character23$CHAR23.$CHAR23.
Untitled2Character8$8.$8.
Untitled3Character15$CHAR15.$CHAR15.
Untitled4Character8(None)(None)
Untitled5Numeric8date.date.
Untitled6Character500$CHAR500.$CHAR500.
Untitled7Character50$CHAR50.$CHAR50.
Untitled8Character10$CHAR10.$CHAR10.
Untitled9Character1000$CHAR1000.$CHAR1000.

Table 2

Untitled1Untitled2Untitled3Untitled4Untitled5Untitled6Untitled7Untitled8Untitled9
20170805_EAP_Account_Req_New_20180112_073647  143205-Aug-17        

 

       

                

 

properties of table

 

 

 

ColumnTypelengthInformatFormat
Untitled1Character46$46.$46.
Untitled2Character8(None)(None)
Untitled3Character8(None)(None)
Untitled4Character8(None)(None)
Untitled5Numeric8date.date.
Untitled6Character8(None)(None)
Untitled7Character8(None)(None)
Untitled8Character8(None)(None)
Untitled9Character8(None)(None)

 

My output has missing values

 

Untitled1Untitled2Untitled3Untitled4Untitled5Untitled6Untitled7Untitled8Untitled9
                                                      4           ..                                
LWI93262167                                   F                  .26.912-Sep-12                                
VE98710787                                    F                  .32.912-Sep-12                                
SDG13502113                                   F                  .25.0212-Sep-12                                
SDG38203520                                   F                  .20.0212-Sep-12                                
LW93262167                                    F                  .27.0212-Sep-12                                

 

can someone please explain or give me alternative

2 REPLIES 2
Deepankar
Calcite | Level 5

Why no one is answering.

LinusH
Tourmaline | Level 20
This is site for volunteers, you could hope for, but require, to be answered.
Also, DI Studio question should be in the Data Management forum. SAS Studio is a different product.

That said, show the code generated for the trasformation.
Also, please stay why you are you this transformation - what is the business rule here?
Data never sleeps

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

Watch Now →
Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2006 views
  • 0 likes
  • 2 in conversation