topic Re: Creating new variable with IF/THEN in New SAS User

Creating new variable with IF/THEN

AMMAN — Wed, 31 Oct 2018 19:19:27 GMT

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.

Re: Creating new variable with IF/THEN

tomrvincent — Wed, 31 Oct 2018 19:23:57 GMT

if you comment it out do you get anything?

Re: Creating new variable with IF/THEN

novinosrin — Wed, 31 Oct 2018 19:30:07 GMT

or leading blanks/ case sensitivity issue perhaps?

Try

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

Re: Creating new variable with IF/THEN

AMMAN — Wed, 31 Oct 2018 19:30:52 GMT

Tried this. Same result: one line with missing values

Re: Creating new variable with IF/THEN

novinosrin — Wed, 31 Oct 2018 19:32:56 GMT

lets debug

proc sql;

select distinct mos

from have;

quit;

Let us know the above report

Re: Creating new variable with IF/THEN

tomrvincent — Wed, 31 Oct 2018 19:37:27 GMT

so claims is empty.

Re: Creating new variable with IF/THEN

ballardw — Wed, 31 Oct 2018 19:42:13 GMT

@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.

Re: Creating new variable with IF/THEN

Reeza — Wed, 31 Oct 2018 20:00:16 GMT

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.

Re: Creating new variable with IF/THEN

AMMAN — Wed, 31 Oct 2018 20:30:18 GMT

Attached is the log. Uninitialized

Re: Creating new variable with IF/THEN

novinosrin — Wed, 31 Oct 2018 20:31:53 GMT

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

verify

proc contents data=input;

run;