Date: Wed, 6 May 1998 08:25:17 -0400
Reply-To: Lary Jones <ljones@BINGHAMTON.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Lary Jones <ljones@BINGHAMTON.EDU>
Subject: Re: data manipulation
In-Reply-To: <6a46aa88.3550513f@aol.com>
Content-Type: text/plain; charset="us-ascii"
At 08:02 AM 5/6/98 EDT, MelliJ wrote:
>I have a data set that I have been trying to manipulate into a more useable
>form for my project. I'm not entirely sure my problem can even be solved, so
>I'll post it here for assistance.
Melanie,
Your situation is not clear to me from the description below. I do not
see a common identifier for lines 1,4,7,8 and they were not highlighted
in my mail. Please note that many mail programs only display messages
in plain text. I am sure I could provide some assistance if you tell me
1) how one knows what data to include (what is the code or flag for
inclusion), and
2) what is the maximum number of data points for each case (identifier).
-lary jones
_______________________________________________________
Lary Jones % Statistical Computing Analyst
Computing Services % ..........................
Binghamton University % LJones@Binghamton.EDU
Binghamton, NY 13902-6000 % (607) 777-2879
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>I have a data set with multiple observations per identification number. In
>most cases, I need only a few of the observations, not all of them, and
only a
>few of the variables. What I'm trying to do is combine the observations I
>need into one single observation per identification number. Here is an
>example:
>
>OBS DATE PROC DIAG
>
> 1 6/12/98 6 7
> 2 6/12/98 8 8
> 3 6/12/98 1 2
> 4 6/12/98 3 4
> 5 6/14/98 9 2
> 6 6/14/98 8 8
> 7 6/14/98 6 7
> 8 6/15/98 2 3
>
>I only want the highlighted observations, #'s 1,4,7, and 8. Then, I want to
>put them all in one line, renaming the variables date1-date4, proc1-proc4,
and
>diag1-diag4.
| 
