Hi All,

Can some give some advice on the problem outlined below.

Robert

Jesse Chittams wrote:

> Hi Robert, > > Please forward this to the SAS discussion group. > > Thanks, > -Jesse C. > ---------------------------------------------------------------- > > Subject: Big data users > Resent-From: bac@cceb.upenn.edu > Date: Thu, 27 Apr 2000 10:50:17 -0400 > From: "Jill Santanna" <jsantann@cceb.upenn.edu> > To: Anita Weber <aweber@cceb.upenn.edu> > , Colleen Brensinger <cbrensin@cceb.upenn.edu> > , Jill Santanna <jsantann@cceb.upenn.edu> > , Stephen Durborow <sdurboro@cceb.upenn.edu> > , Warren Bilker <wbilker@cceb.upenn.edu> > , bac <bac@cceb.upenn.edu> > > Hi Big Data Users!! > > I've been pulling records from the DUR database and after six months > I've finally come to the conclusion that there has got to be a more > time efficient way than how I'm doing this. > > What I'm trying to do is pull all of the cancer records. I want any > record that has an icd-9 code between 140 and 238.9. Is there a way > to create a view to do that instead of having to do the work in SAS? > Can you use the between statement in the Proc Access step to deal with > the character icd-9 codes as well? I've used it for dates but never > character strings. > > Any direction you could give me to improve this process would be > helpful. It took 7 days of real time (5 hrs CPU) to do this the last > time!! > > Thanks! > > Jill