sas program

wxie22 — Wed, 23 Feb 2022 01:40:05 GMT

Hi all!

below is my code. So the code with the if statement works totally fine. I was trying to do the same thing using a select statement, but I got 0 observations except for ShipDays<3. Does anyone know what's wrong?

data work.fast work.slow work.veryslow;
set hw2.allorders;
where Order_Type=2 or Order_Type=3;
ShipDays=Delivery_Date-Order_Date;
if ShipDays<3 then output work.fast;
else if ShipDays>7 then output work.veryslow;
else if ShipDays>5 and ShipDays<7 then output work.slow;

drop Employee_ID;

run;

/*problem1 part b*/

data work.fast work.slow work.veryslow;
set hw2.allorders;
where Order_Type=2 or Order_Type=3;
ShipDays=Delivery_Date-Order_Date;
select(ShipDays);
when (ShipDays<3) output work.fast;
when (ShipDays>7) output work.veryslow;
when ((ShipDays>5)and(ShipDays<7)) output work.slow;
otherwise;
end;
drop Employee_ID;

run;

Re: sas program

Reeza — Wed, 23 Feb 2022 03:21:00 GMT

Select should not have the SHIPDAYS in the first SELECT statement.

I believe you're running into the issue illustrated in Example 4.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/p09213s9jc2t99n1vx0omk2rh9ps.htm

data work.fast work.slow work.veryslow;
set hw2.allorders;
where Order_Type=2 or Order_Type=3;
ShipDays=Delivery_Date-Order_Date;
select;
when (ShipDays<3) output work.fast;
when (ShipDays>7) output work.veryslow;
when ((ShipDays>5)and(ShipDays<7)) output work.slow;
otherwise;
end;
drop Employee_ID;
run;

FYI - please include the log in your future questions.

@wxie22 wrote:

Hi all!

below is my code. So the code with the if statement works totally fine. I was trying to do the same thing using a select statement, but I got 0 observations except for ShipDays<3. Does anyone know what's wrong?

data work.fast work.slow work.veryslow;
set hw2.allorders;
where Order_Type=2 or Order_Type=3;
ShipDays=Delivery_Date-Order_Date;
if ShipDays<3 then output work.fast;
else if ShipDays>7 then output work.veryslow;
else if ShipDays>5 and ShipDays<7 then output work.slow;

drop Employee_ID;

run;

/*problem1 part b*/

data work.fast work.slow work.veryslow;
set hw2.allorders;
where Order_Type=2 or Order_Type=3;
ShipDays=Delivery_Date-Order_Date;
select(ShipDays);
when (ShipDays<3) output work.fast;
when (ShipDays>7) output work.veryslow;
when ((ShipDays>5)and(ShipDays<7)) output work.slow;
otherwise;
end;
drop Employee_ID;

run;

topic Re: sas program in SAS Programming

sas program

Re: sas program