Date:         Tue, 11 Sep 2007 19:51:58 -0700
Reply-To:     Patrick <patrick.matter@GMX.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrick <patrick.matter@GMX.CH>
Organization: http://groups.google.com
Subject:      Re: How to deal with a .LST text file and a data prep ?
Comments: To: sas-l@uga.edu
In-Reply-To:  <20070912014847.E466A23548F@p3fed1.frb.org>
Content-Type: text/plain; charset="us-ascii"

On Sep 12, 11:48 am, Jack.A.Wo...@BOS.FRB.ORG (Jack Wozek) wrote:
>   Hi.
>
> I received a data file in a .LST format.  Would someone tell me what this
> is and how can I get it into a SAS dataset?
>
> Another question.  The data look like this....
>
> 011001275  S  067066762  R  061956766
>            S  067026762  R  067017224
>            S  322050239
>            S  322060598
>
> 011102632  S  011101667
>
> 011401380  S  211272546
>
> 011211432  R  211473115  R  211478867
>            R  211470135  R  211779743
>            S  211770141  R  011405876
>            S  211770151  R  211471186
>
> 011205458  R  011260337
>            R  011291085
>            S  011201396
>            S  211274596  R  211274309
>
> But I really need them to look like this (basically, the entry in the
> first column needs to be repeated for its related rows):
>
> 011001275  S  067066762  R  061956766
> 011001275  S  067026762  R  067017224
> 011001275  S  322050239
> 011001275  S  322060598
> 011102632  S  011101667
> 011401380  S  211272546
> 011211432  R  211473115  R  211478867
> 011211432  R  211470135  R  211779743
> 011211432  S  211770141  R  011405876
> 011211432  S  211770151  R  211471186
> 011205458  R  011260337
> 011205458  R  011291085
> 011205458  S  011201396
> 011205458  S  211274596  R  211274309
>
> Help would be greatly appreciated!

Hi Jack
From: http://asellus.cee.odu.edu/sas/sas_gen.php
"Output file for your SAS source code (if your SAS source code has no
error). This could be a listing of a data set, the calculated means of
your variables, or a myriad of other possibilities. If you have
error(s) in your SAS source code, no output file will be generated. It
has a file extention of '.lst' For example, 'abc.lst' or 'median.lst',
etc. "

Need a bit more time to come up with a solution for your second
"problem".
Patrick