I have created two new variables with the name "newsales" and "ordersize" then i was trying to create a new table
including these variables but in the output these two variables were not included. How to add those two columns in new table?
/* creating a new variable */
retain sales newsales;
newsales = Sales*1.05;
/* if else condition */
if Quantity <=2 then ordersize = "l";
else if Quantity <5 then ordersize = "m";
else ordersize = "h";
/*creating new table with defined column*/
data temp(keep = Quantity Sales newtsales ordersize );
The Simplilearn community is a friendly, accessible place for professionals of all ages and backgrounds to engage in healthy, constructive debate and informative discussions. Get your pressing questions answered,
participate in monthly contests, create polls to get a feel for the market, build your network, and more! Pull up a chair and come join the discussion -today!