Creating new variable with IF/THEN

[AMMAN]

data  ClaimsByQuarter2;
set work.Claims;
if MOS = 'January'  then Quarter = '1';
run;

I can't figure out why I am getting on observation returned when I should have many that qualify.  Advice is appreciated.

I cannot attach the data set; its too large.

[tomrvincent]

if you comment it out do you get anything?

[novinosrin]

or leading blanks/ case sensitivity issue perhaps?

Try

if strip(upcase(MOS))='JANUARY' then quarter='1';

[AMMAN]

Tried this.  Same result:  one line with missing values

[novinosrin]

lets debug

proc sql;

select distinct mos 

from have;

quit;

Let us know the above report

[tomrvincent]

so claims is empty.

[ballardw]

---

@AMMAN wrote:

data  ClaimsByQuarter2;
set work.Claims;
if MOS = 'January'  then Quarter = '1';
run;

I can't figure out why I am getting on observation returned when I should have many that qualify.  Advice is appreciated.

I cannot attach the data set; its too large.

---

Post the log entery generated when that executes.

It should have something about number of observations read and written to the output data set. If there is not indication of any read then you didn't start with a data set. If the number of observations read was 0 then the starting data set has no observations and likely have something that went wrong prior if you expect many records.

[Reeza]

Attach the log. Note in your code that's shown, MOS is empty so of course it's empty. Usually this means your code error out somewhere and SAS just gives a partial result. Always read the log. If you can't attach the data, at least show a proc contents on the data set and a proc freq of the MOS values. If it's a SAS date for example that won't work.

[AMMAN]

Attached is the log.  Uninitialized

[novinosrin]

So likely no variable by the name MOS in your input dataset

verify

proc contents data=input;

run;