| Date: | Tue, 2 Oct 2007 11:38:28 -0700 |
|---|
| Reply-To: | "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV> |
|---|
| Subject: | Re: Messy Data |
|---|
| In-Reply-To: | <1191349677.643030.123010@n39g2000hsh.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=iso-8859-1 |
|---|
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of mholmes@CUESTA.EDU
> Sent: Tuesday, October 02, 2007 11:28 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Messy Data
>
> Hello all,
> I am relatively new to SAS and am trying to read into SAS a text
> file that has three variables (carbon monoxide levels, source, and
> date). Here is an example of a few of the data lines:
> 15 BAAQMD 09/10/92
> 20 BAAQMD 09/22/92
> 15 BAAQMD 03/30/93
> 45 refinery 04/16/93
> 30 refinery 04/17/93
> My code is as follows:
>
> data oil ;
> infile "Z:\MHolmes\STAT 530\Unzipped Files\data_refinery.dat" ;
> input Monox source :$8. date mmddyy. ;
> run ;
>
> Proc print data.oil ;
> run ;
>
> My output is indicating that some of my dates are missing (ie a period
> shows up). Any idea how to fix this problem? Thanks.
>
> Mike
>
Mike,
Change your date informat to mmddyy8.
Hope this helps,
Dan
Daniel J. Nordlund
Research and Data Analysis
Washington State Department of Social and Health Services
Olympia, WA 98504-5204
|
