Date:         Thu, 31 Jul 2008 13:24:35 -0400
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     RFC822 error: <W> MESSAGE-ID field duplicated. Last occurrence
              was retained.
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: INPUT question
Comments: To: Peter Flom <peterflomconsulting@mindspring.com>
In-Reply-To:  <5369197.1217524823758.JavaMail.root@elwamui-wigeon.atl.sa.earthlink.net>
Content-Type: text/plain; charset="us-ascii"

Try

 data steph.combined;
 infile 'c:\personal\consults\stephanie\combined.txt';
  input formid 1-10 studentid 12-18  schoolid 20-29 homeroom 32-35
    gender 37  ethnic 38 age 39-40 grade 41  (q1-q37) (1.)  version 79
   year 80-81 ;
 run;

HTH,
donh

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Peter Flom
> Sent: Thursday, July 31, 2008 1:20 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: INPUT question
>
> Hi again
>
> I called SAS tech support on this one, thinking it would be
> the sort of simple answer that is great to ask for from them.
>  But the person who responded didn't know the answer, so I am
> waiting with a tracking number.  So, I'll call on the big guns! :-)
>
>
> I have a .txt file that has the following:
>
> Columns 1-10     Form ID
> Columns 12-18    Student ID
> Columns 20-29    School ID
>         32-35    Homeroom
>         37       Gender
>         38       Ethnicity
>         39-40    Age
>         41       Grade
>         42-78    Q1-Q37
>         79       Version
>         80-81    Year
>
> All are numeric.  All have blanks for missing (not .).  There
> are 364 records.
>
> I've tried various things, e.g.
>
> data steph.combined;
> infile 'c:\personal\consults\stephanie\combined.txt';
>  input formid 1-10 studentid 12-18  schoolid 20-29 homeroom 32-35
>    gender 37  ethnic 38 age 39-40 grade 41  q1-q37 1.  version 79
>   year 80-81 ;
> run;
>
>
> but I can't make SAS read q1-q37 each as one digit.  It's
> always looking for blanks, and going past the end of the
> line, and reporting the wrong number of cases, and losing a card....
>
>
> I don't really want to type in q1 42  q2 43  ...... and so on
>
> TIA
>
> Peter
>
> Peter L. Flom, PhD
> Statistical Consultant
> www DOT peterflom DOT com
>