topic Re: my sas give me wrong output!!!!!!!!! in SAS Enterprise Guide

my sas give me wrong output!!!!!!!!!

amitosi — Thu, 18 Oct 2012 06:17:30 GMT

hi ,

im writing this

data aosi.BDI59_PITUACHreg2;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then shiuch_m1=1;

else shiuch_m1=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then test_mira=1;

else test_mira=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then www=1;

else www=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then mir=1;

else mir=0;

set aosi.BDI59_PITUACH;

run;

proc sql ;

title "shiuch_m1";

select shiuch_m1,sum(keshel) as keshel

from aosi.BDI59_PITUACHreg2

group by 1;

quit;

proc sql ;

title "test_mira";

select test_mira,sum(keshel) as keshel

from aosi.BDI59_PITUACHreg2

group by 1;

quit;

proc sql ;

title "mir";

select mir,sum(keshel) as keshel

from aosi.BDI59_PITUACHreg2

group by 1;

quit;

proc sql ;

title "www";

select www,sum(keshel) as keshel

from aosi.BDI59_PITUACHreg2

group by 1;

quit;

the output is this

shiuch_m1

shiuch_m1	keshel
0	7
1	57

test_mira

test_mira	keshel
0	0
1	64

mir

mir	keshel
0	7
1	57

www

www	keshel
0	7
1	57

please , i think my sas go crazy and im losing my mind

help?

thanks a lot

Re: my sas give me wrong output!!!!!!!!!

RichardinOz — Thu, 18 Oct 2012 06:36:36 GMT

Try putting the set statement before the if statements.

data aosi.BDI59_PITUACHreg2;

set aosi.BDI59_PITUACH;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then shiuch_m1=1;

else shiuch_m1=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then test_mira=1;

else test_mira=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then www=1;

else www=0;

if shiuch in (0,2750,2921,4532,5077,5078,5083,5901,5902,6300,6305,9698) then mir=1;

else mir=0;

run;

Re: my sas give me wrong output!!!!!!!!!

Haikuo — Thu, 18 Oct 2012 13:43:07 GMT

If possible, please attach the dataset you were using. you could only post those involving variables.

From first look, it does look bizzar.

Haikuo

Re: my sas give me wrong output!!!!!!!!!

Astounding — Thu, 18 Oct 2012 13:59:46 GMT

When something unexplainable occurs (and this really does fall into that category), it often helps to narrow down where the problem is occurring. In this case, is it the DATA step, or is it the SQL steps? Here is one preliminary step you could take to narrow down the issue:

proc freq data=aosi.BD159_PITUACHreg2;

tables shiuch_m1 * test_mira * www * mir / list missing;

run;

Good luck.

Re: my sas give me wrong output!!!!!!!!!

amitosi — Thu, 18 Oct 2012 14:19:32 GMT

thx

RichardinOz!!

it's working now.

Re: my sas give me wrong output!!!!!!!!!

Astounding — Thu, 18 Oct 2012 18:41:49 GMT

Aha! And has anybody figured out why that would make it work? (answer below)

Answer:

When the SET statement is in the wrong position, the answer will clearly be wrong. But why should they results be different for one variable out of the four?

One of the variables (test_mira) was created by the programming statements. But the other three were already part of the original data set. Placing the SET statement in the wrong place would overwrite the three variables that already existed, but would not overwrite test_mira.

Re: my sas give me wrong output!!!!!!!!!

Haikuo — Thu, 18 Oct 2012 18:45:47 GMT

That is an 'Aha' moment! Thanks, Astounding. I think I will stop pulling hair now.

Haikuo

Re: my sas give me wrong output!!!!!!!!!

moorsd — Thu, 18 Oct 2012 19:29:37 GMT

computer says 'no'..