Date:         Sat, 3 Dec 2005 23:47:23 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: No Rows Selected
Comments: To: Carol Srna <csrna@FORD.COM>

Your code works for me.

   data _null_;
   file dcol;
   put 'aaa AAAA' @80 '12032005  12042005';
   put 'bbb     ' @80 '12032005  12042005';
   put 'ccc CCCC' @80 '12032005  12042005';
   run;

   DATA IN01;
   INFILE DCOL;
   INPUT @1 _SYSTEM $3.
         @5 _type    $4.
         @80 d1    mmddyy8.
         @90 d2    mmddyy8.  ;
   format d1 d2 mmddyy8.;
   Run;

   proc sql;
   select _system, _type
       from IN01
       where _type is missing;
   Quit;

Result:

   _SYSTEM  _type

   bbb

Your difficulty would seem to be a data issue.

On Fri, 2 Dec 2005 15:02:56 -0500, Srna, Carol (C.) <csrna@FORD.COM> wrote:

>Hi.
>
>   DATA IN01;
>   INFILE DCOL;
>   INPUT @1 _SYSTEM $3.
>         @5 _type    $4.
>         @80 d1    mmddyy8.
>         @90 d2    mmddyy8.  ;
>  format d1 d2 mmddyy8.;
> Run;
>
> proc sql;
> select _system, _type
>       from IN01
>       where _type is missing;
>Quit;
>
>Anything special I should look for?
>
>Thanks In Advance
>~~Carol
>