I have two data sets, Data set 1 Area High Risk Alert Release Month Delivery Lead Year Number of Project Hours Primarykey SA FALSE July Naresh,A 2017 12 SAFALSE2017 TC High May Madhu,Sudhan 2017 25 TCHigh2017 STC FALSE Aug Naresh,A 2017 45 STCFALSE2017 SA FALSE July Madhu,Sudhan 2017 65 SAFALSE2017 TC High May Sridhar,raju 2016 12 TCHigh2016 STC FALSE Aug Naresh,A 2016 52 STCFALSE2016 Data set 2 Area High Risk Alert Release Month Manager Year Primaykey SA FALSE July Nandan, Krishna 2017 SAFALSE2017 TC HIGH May Nandan, Krishna 2017 TCHIGH2017 STC FALSE Aug Madhu, Shankar 2017 STCFALSE2017 SA FALSE July Madhu, Shankar 2017 SAFALSE2017 TC High May Madhu, Shankar 2017 TCHigh2017 STC FALSE Aug Nandan, Krishna 2017 STCFALSE2017 Using primary key i have done left join using primary key my data sert looks like this Area High Risk Alert Release Month Delivery Lead Year Number of Project Hours Primarykey Manager Name SA FALSE July Naresh,A 2017 12 SAFALSE2017 Nandan, Krishna TC High May Madhu,Sudhan 2017 25 TCHigh2017 Nandan, Krishna STC FALSE Aug Naresh,A 2017 45 STCFALSE2017 Madhu, Shankar SA FALSE July Madhu,Sudhan 2017 65 SAFALSE2017 Nandan, Krishna TC High May Sridhar,raju 2016 12 TCHigh2016 #N/A STC FALSE Aug Naresh,A 2016 52 STCFALSE2016 #N/A After exporting it to CSV my data extracts accuratly but unwanted blanks appears. Proc export data= final_data outfile="Path/final_data.csv"; DBMS=CSV Replace; Run; Area High Risk Alert Release Month Delivery Lead Year Number of Project Hours Primarykey Manager Name SA FALSE July Naresh,A 2017 12 SAFALSE2017 Nandan, Krishna TC High May Madhu,Sudhan 2017 25 TCHigh2017 Nandan, Krishna STC FALSE Aug Naresh,A 2017 45 STCFALSE2017 Madhu, Shankar SA FALSE July Madhu,Sudhan 2017 65 SAFALSE2017 Nandan, Krishna TC High May Sridhar,raju 2016 12 TCHigh2016 #N/A STC FALSE Aug Naresh,A 2016 52 STCFALSE2016 #N/A
... View more