Date:         Wed, 13 Oct 1999 11:06:44 -0400
Reply-To:     Bernard Tremblay <bernard@CAPITALE.QC.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: Kevin Brunson <kbrunson@nd.edu>
From:         Bernard Tremblay <bernard@CAPITALE.QC.CA>
Organization: Imaginasys enr.
Subject:      Re: reading date values Solaris v. NT
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset=us-ascii

Kevin,

        I tried your program on a SUN with SAS 6.12 ts020.  I changed
the following things to it:

        1- Specify option DSD on the infile statement;

        2- add an informat for the date:  informat date mmddyy8.;

        3- take off the mmddyy8 on the input statement;


        Now it works like a charm on UNIX,  I guess it should be
the same on your NT platform.  I think the problem lies with
the "input date mmddyy8.",  SAS really expect 8 digits for the
date and picks up the comma.

        Give it a try and let me know...

                Bernard Tremblay
--
         \\\|///
       \\  - -  //
        (  @ @  )
+-----oOOo-(_)-oOOo-------+--------------------------------------+
| Bernard Tremblay        |                                      |
|          La Capitale    | Tel: (418) 646-2401                  |
|                         | Fax: (418) 646-5960                  |
|                         | Int: Bernard.Tremblay@capitale.qc.ca |
+-------------------------+--------------------------------------+
|          Imaginasys enr | Res: (418) 658-1411                  |
|                         | Int: bertrem@quebectel.com           |
+--------------Oooo-------+--------------------------------------+
       oooO   (   )
      (   )    ) /
       \ (    (_/
        \_)
Kevin Brunson wrote:
>
> A user reported a problem reading date values running the same program with
> the same data on 2 different computers with v. 6.12, TS060.  He claims that
> the data is read correctly on a machine running NT but is incorrect on Win98.
>
> To test I ran the program on Solaris and NT; SAS is v. 6.12 on both, TS045 on
> Solaris and TS060 on NT.  Below I listed the input file, a few lines from the
> listings and logs from both OS's, and the SAS program.  Solaris reads the date
> values as desired but NT fails when the month is a single digit.
>
> Should the SAS format behave differently on the two systems? Is there a format
> that will read the dates correctly on NT--I can't find one.  The user wants to

  <snip...>
>
> SAS program (Solaris version):
> data dindex;
>   infile "indxrat2.csv" dlm=',' missover;
>   input date mmddyy8. ipcend ipcbeg ufend ufbeg igpaend igpabeg ipsaend
>         ipsabeg strat  rfrate medrate;
>
> yr = year(date);
> mo = month(date);
> dy = day(date);
>
> proc print data = dindex;
>   var date yr mo dy;