Date: Mon, 21 Jan 2002 11:20:08 -0800
Reply-To: WCheng@ISISPH.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Wei Cheng <WCheng@ISISPH.COM>
Subject: Re: collapsing records and indexing
Content-Type: multipart/alternative;
Dave,
1) Yes, SAS has the index ability. But you need to make your questions
more clear so that SAS-Lers can give your more specific help.
2) proc sql;
select member, min(start_date), max(end_date), dob
from olddata
group by member;
3) You can search the SAS-L archive for the SUGI question, I remember the
subject is "How to get the best from SUGI" last year. If you do not know
how to search the archive, please take a look at my web site:
http://www.geocities.com/prochelp. Under the SAS-L category, you should
find the answer.
HIH,
Wei
Dave Meyer <dmeyer@HOAGHOSPITAL.ORG>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
01/21/02 10:50 AM
Please respond to Dave Meyer
To: SAS-L@LISTSERV.UGA.EDU
cc:
Subject: collapsing records and indexing
Hi everyone,
New SAS programmer Dave (6 months ? "I am but an egg") with a couple of
quick questions for you SAS geniuses out there:
1) My boss (an MD) was asking me if SAS had indexing capability like
Access does (he is interested in run times for some of the ouput I have
been getting him - they are big files and it sometimes takes me multiple
hours to complete the run) - I told him that I wasn't sure off hand, but
that I was sure that either: a) SAS does, or b) it has something better
(smile) - Did I lie?? I have just started to look through my books and
the on-line documentation - any ideas anyone has will be appreciated.
2) I have just hit what is my trickiest problem to far with SAS - I need
have to collapse line item (record level) transaction items and return
the member specific earliest "start date" and latest "end date" along
with the detail that is identical from line to line -
Data example:
MEMBER START DATE END DATE DOB
John Q 15280 15283 -3287
John Q 15280 15284 -3287
John Q 15278 15280 -3287
So really John Q was in the hospital from 15278 to 15284 (6 days) and
had 3 doc's billing for different services over the time - - so I am
trying to be able to return the following:
MEMBER START DATE END DATE DOB
John Q 15278 15284 -3287
Any suggestions anyone?
3) I have decided that if I am going to be serious about joining the SAS
cult, that I should plan to go to SUGI in FL - - Does anyone have any
advice for a guy going to their first SAS conference - any types of
sessions help anyone out more then others...etc??? I am looking forward
to it.
Thanks everyone - Dave
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
[text/html]
