topic Re: Whats Wrong with my code in SAS Programming

Whats Wrong with my code

Mike7 — Sat, 06 May 2017 02:13:01 GMT

Proc SQL;
create table moth as
Select distinct a.motherid, a.perid as kidid,
a.tage as kidage, a.esex as kidgender, a.EHLTSTAT as kid_currhealth ,
a.EHOSPNIT as kid_nightsinhosp, a.EVISDOC as kid_docvisit
from momkid a, wave5top b
where a.motherid=b.perid
and a.tage lt 18
order by a.motherid, a.tage;
Quit;

Th log is not showing any errors its just showing 0 observations

0 rows 7 columns

Re: Whats Wrong with my code

Tom — Sat, 06 May 2017 02:23:01 GMT

No records met your WHERE criteria. Without seeing the data hard to tell if there is any error or not.

Re: Whats Wrong with my code

robert215 — Sat, 06 May 2017 15:24:58 GMT

Check if you have kidid in table momkid ? (a.kidid = b.kidid)

Re: Whats Wrong with my code

ballardw — Mon, 08 May 2017 15:04:21 GMT

Some Possible causes

1) No matching Momid = Perid

2) no tage lt 18

3) None of the matching Momid=Perid have tage lt 18