Hi i want to create observation GENDER in a row above characteristic how do i do that. thanks in advance ... View more

Hi i want to create a table that contains same variable names it has three desired output tables . i want all three output's in a single table  i tried it with 'merge' statement iam getting column wise but i need it in a row. ... View more

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