https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714603#M220629 <P>It would probably help to provide an example of the BEFORE and AFTER insertion table. Since you specifically say "row 3" then your before should include at least 4 rows of data and the result should show what is expected after the insertion. If your data as lots of variables we don't need to see all of them but enough to tell what was "inserted".</P> <P>&nbsp;</P> <P>It may also help if you tell us if your existing data is sorted in any way, by what variables, and if you have a variable or combinations of variables that uniquely identify each row.</P> Wed, 27 Jan 2021 15:04:52 GMT ballardw 2021-01-27T15:04:52Z https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714581#M220620 How insert new row at 3rd row place already existing table Wed, 27 Jan 2021 14:18:46 GMT https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714581#M220620 BrahmanandaRao 2021-01-27T14:18:46Z https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714584#M220622 <P>What should the new row contain?</P> <P>&nbsp;</P> <P>By the way, your title and text don't match, could you please go back to your&nbsp;<STRONG>original</STRONG> post and change the title to "Insert Row"? Thanks.</P> Wed, 27 Jan 2021 14:25:51 GMT https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714584#M220622 PaigeMiller 2021-01-27T14:25:51Z https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714603#M220629 <P>It would probably help to provide an example of the BEFORE and AFTER insertion table. Since you specifically say "row 3" then your before should include at least 4 rows of data and the result should show what is expected after the insertion. If your data as lots of variables we don't need to see all of them but enough to tell what was "inserted".</P> <P>&nbsp;</P> <P>It may also help if you tell us if your existing data is sorted in any way, by what variables, and if you have a variable or combinations of variables that uniquely identify each row.</P> Wed, 27 Jan 2021 15:04:52 GMT https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714603#M220629 ballardw 2021-01-27T15:04:52Z https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714625#M220639 Use the FIRSTOBS + OBS options with the SET statement. Wed, 27 Jan 2021 15:53:32 GMT https://communities.sas.com/t5/SAS-Programming/Insert-value/m-p/714625#M220639 Reeza 2021-01-27T15:53:32Z