Do you want to insert a row or simply rename the variable? If it's the latter, then (assuming you dataset is called have), when opening the dataset simply use something like:   set have (rename=(characteristic=gender);   Otherwise, if you really want to insert a row, you may first have to use a length statement (before the set statement) and then include code (after the set statement): data want; length characteristic $6; set have; if characteristic='F' then do; hold=characteristic; characteristic='Gender'; output; characteristic=hold; output; end; else output; run; Art, CEO, AnalystFinder.com   ... View more

Hey Aditya1, As you are saying you are having three tables with same variables, then you have to use set statement or use union with PROC SQL. ... View more

@aditya1 wrote: data flowersales; input customerid $ saledate mmddyy10. variety $ quantity; datalines ; 240W 02-07-2003 Ginger 120 240W 02-07-2003 Protea 180 356W 02-08-2003 Heliconia 60 356W 02-08-2003 Anthurium 300 188R 02-11-2003 Ginger 24 188R 02-11-2003 Anthurium 24 240W 02-12-2003 Heliconia 48 240W 02-12-2003 Protea 48 240W 02-13-2003 Ginger 188 188R 02-12-2003 Ginger 500 356W 02-12-2003 Ginger 240 ; run; Create a dataset "sumsales" (sort it by customer, saledate variety quantity) - keep all original obsservations and variables this  is the program  Create Variable ABCD - show the total sales for each customer    ... View more