Hello All, I am trying to write a query to replace missing values for the column Shipmode and they have a correlation with the difference of ShipDate and OrderDate. There are 4 types of ShipMode, Same day if the ship date and order date are the same, First class if its below 3 days, Second class if its below 4 days and everything else is Standard Class I tried the following query with no luck. It is replacing my original dataset with only the values of those with the missing values. I am an absolute beginner to SAS, so any help on this would be deeply appreciated data apacstore;
set work.apacstore;
if shipdate-orderdate <=1 then shipmode = 'Same Day';
if shipdate-orderdate > 1 or shipdate-orderdate < 3 then shipmode = 'First Class';
if shipdate-orderdate >= 3 or shipdate-orderdate <= 4 then shipmode 'Second Class';
if shipdate-orderdate > 4 then shipmode = 'Standard Class';
where shipmode is missing;
run;
... View more