https://communities.sas.com/t5/SAS-Procedures/Duplicate-rows/m-p/407022#M67040 <P>Assuming it's OK to give you exactly what you asked for ...</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>data want;</P> <P>if _n_=1 then set EMPL_Hierarchy;</P> <P>array L_ {4} L1_ID L2_ID L3_ID L4_ID;</P> <P>set EmplData;</P> <P>if _n_ &gt; 1 then L_{_n_-1} = ' ';</P> <P>run;</P> Tue, 24 Oct 2017 17:48:07 GMT Astounding 2017-10-24T17:48:07Z https://communities.sas.com/t5/SAS-Procedures/Duplicate-rows/m-p/406988#M67038 <P>Hi,</P><P>&nbsp;</P><P>I got struck, help me on this.</P><P>&nbsp;</P><P>I have a table Empldata (EMP_ID is in character format and Interest is in Numeric Format)</P><P>&nbsp;</P><P>EMP_ID&nbsp; &nbsp; Interest</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.2</P><P>202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.4</P><P>303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.7</P><P>404&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.1</P><P>&nbsp;</P><P>&nbsp;</P><P>I have Another Table EMPL_Hierarachy (all columns&nbsp; are in Character format)</P><P>L1_ID(Empl ID)&nbsp; &nbsp; &nbsp; &nbsp; L2_ID (Reporting Manager ID)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L3_ID (Senior Manager ID)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L4_ID (Head of All Empls)</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>&nbsp;</P><P>&nbsp;</P><P>I need I output table like below</P><P>&nbsp;</P><P>EMP_ID&nbsp; &nbsp; Interest&nbsp; &nbsp;L1_ID&nbsp; &nbsp; &nbsp; &nbsp; L2_ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L3_ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L4_ID</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>404&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>OR</STRONG></P><P>&nbsp;</P><P>EMP_ID&nbsp; &nbsp; Interest&nbsp; &nbsp;L1_ID&nbsp; &nbsp; &nbsp; &nbsp; L2_ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L3_ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;L4_ID</P><P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>404&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;404</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Please can some body help me on this.</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in Adavance</P><P>&nbsp;</P><P>&nbsp;</P><P>Teja&nbsp;&nbsp;</P> Tue, 24 Oct 2017 15:57:34 GMT https://communities.sas.com/t5/SAS-Procedures/Duplicate-rows/m-p/406988#M67038 TejaSurapaneni 2017-10-24T15:57:34Z https://communities.sas.com/t5/SAS-Procedures/Duplicate-rows/m-p/407022#M67040 <P>Assuming it's OK to give you exactly what you asked for ...</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>data want;</P> <P>if _n_=1 then set EMPL_Hierarchy;</P> <P>array L_ {4} L1_ID L2_ID L3_ID L4_ID;</P> <P>set EmplData;</P> <P>if _n_ &gt; 1 then L_{_n_-1} = ' ';</P> <P>run;</P> Tue, 24 Oct 2017 17:48:07 GMT https://communities.sas.com/t5/SAS-Procedures/Duplicate-rows/m-p/407022#M67040 Astounding 2017-10-24T17:48:07Z