LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 7 Jan 2011 14:13:59 -0500
Reply-To:     Arthur Tabachneck <art297@ROGERS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@ROGERS.COM>
Subject:      Re: Calculating Readmissions
Comments: To: Shelley Perritt <hims.sperritt@SYMPATICO.CA>


Since your macro variables aren't data dependent, as I recall, move them to the start of your code. They don't have to be in a datastep.

Then, after running your code, look at the files created and see if the data at least looks like you would expect.

Do some frequency distributions on some of them, especially the site and other variables that for which you've already indicated observing discrepancies.

The extra dates in the array shouldn't be too much of a bother but, without sample data, don't really know.

HTH, Art -------- On Fri, 7 Jan 2011 14:06:25 -0500, HIMS <hims.sperritt@SYMPATICO.CA> wrote:

>Hi > >Thanks very much for replying so quickly. > >You are correct, I only want when chartno isn't missing. > >The portion about dates was for what was provided to me in the original >response. The data actually only has data from 4/1/2005 to 3/31/2010 so I'm >assuming I can just change that? > >The macro variables were also provided in the original post so what should >they be? Note that the original database has 8938 abstracts and one would >assume that I should have the same volumes resulting but I actually only get >6019 which is why some cases aren't showing up. Any assistance in fixing >this would be greatly appreciated. > >Shelley > >-----Original Message----- >From: Arthur Tabachneck [mailto:art297@ROGERS.COM] >Sent: Friday, January 07, 2011 1:34 PM >To: SAS-L@LISTSERV.UGA.EDU; Shelley Perritt >Subject: Re: Calculating Readmissions > >Shelly, > >Without some sample data it's really difficult to say. However, I did >notice some things that are/may be contributing factors. > >First, you use: where chartno NE " "; >Is that really what you want or do you just want: > where not missing(chartno) > >Second, you define your array to include all dates from Jan 1 1990 thru Dec >31 2020 > >Is that what you intended to do? > >Finally, and probably the cause, you create macro variables bh and eh, and >then attempt to use them in the same datastep. > >HTH, >Art

Back to: Top of message | Previous page | Main SAS-L page