About shellp55

shellp55 · ‎01-12-2017

The need to do this arose from requiring a chart listing and each code of A01 etc. means something different. So if a chart had two codes then I want the chart to show up twice in the listing, once with HH = A01 and one with HH = A02. I tried as Glen suggested but because the chart is only in the main list once, the second HH would overwrite the first, not add the chart to the group. So I tried to split out so that there was one chart per HH so I could then dynamically assign HH (i.e. A01 and A02) and then merge back together to have one line per chart where an HH occurred, where a chart that had more than one HH would be in the list twice. I didn't want to have to create the HH field per the 30 datasets and then merge together due to amount of code thus my query. But if there is an easier way, I am all ears!

shellp55 · ‎01-12-2017

Hello I am using SAS 9.4. I have a dataset of wide data i.e. chart_num, acct_num, disch_date, A01, A02, A03 etc. I created datasets from if A01 > 0 then dataset A01 etc. Now I'd like to loop through the datasets and assign a field of HH = dataset name so I can merge them together. Therefore dataset A01 will have a field of HH with "A01" and dataset A02 will have a field of HH with "A02" etc. but do this programatically. How would I do this? Thanks.

shellp55 · ‎06-16-2016

Duh, stupid mistake on my part - the Ahour formula was before the field of regdttm had been created so once I put the shift after the field existed it worked. Thanks so much PG Stats!

shellp55 · ‎06-16-2016

Hi I have some hospital data and want to create a field of "Shifts" based on the registration time. I created the time by using "timepart(regdttm). For shift I specified the length as 15 and used the code: if admhour ge '7:00't and admhour le '17:00't then shift="0700 to 1700 hours"; This doesn't produce an error but doesn't have anything showing in the "shift" column even though there are cases that should be. I also tried leaving the time in its SAS format and entered as a number but that didn't work either. All assistance greatly appreciated. Thanks.

shellp55 · ‎04-13-2016

Hello BallardW Thanks for the code on this but I'm confused by the "Have" dataset because the returned dates were not what was in my dataset. For testing I extracted 1 day (April 1, 2015) of ED data. Running the "Have" dataset and the result was cases that had admit dates beyond April 1, 2015. Or should I just be running the occupancy portion? Thanks.

shellp55 · ‎04-12-2016

Thank you so much for the response, Reeza and @bballard. Nice work on the publication you shared. The woman who is the head of the Alberta Health Authority used to be my Manager in Health Records!

shellp55 · ‎04-11-2016

Hi Reeza Thanks but I'm not understanding your comments. What I was hoping to do was calculate volumes of ED patients by hour of day but not day itself. I would be interested in calculating before and after midnight as you suggested so can you please elaborate on what I have to do to for that to happen? Thanks.

shellp55 · ‎04-11-2016

Thanks very much to both of you but I think Reeza's solution is the one I'm going with. As for round up round down, since a patient with a registration time of 06:27 and a left ED time of 1130 hours would be in the ED at 0600, 0700, 0800, 0900, 1000, and 1100 I think it is safe to produce a record per hour. Or do you see a downfall of that?

shellp55 · ‎04-11-2016

Hello I am using SAS 9.3. I have a data set where one row of data is one emergency department visit. I would like to calculate number of patients in the ED during each hour of the visit. I believe this is referred to as "occupancy" calculation and I've done it before when looking for daily rates, not hourly, for inpatient stays as per below: data want; set mydata; do date=admitdate to disdate; format date ddmmyy10.; output; end; run; How would I do this hourly i.e. admitdatetime to dischdatetime but how do I specify only the hour i.e. if 13:30 then I want the hour to be 13? Thanks.

shellp55 · ‎02-29-2016

Sorry but I've just come up with a new wrinkle on this. What if the procedure date is copied down? The criteria for whether to copy the "Y" is based on whether the initial occurrence has a Y and if the date is the same. So if the 3rd procedure has a new date and the 3rd procedure doesn't have "Y" then procedure 4 won't have Y either. Thanks.

shellp55 · ‎02-22-2016

Thanks...but note that not all of the program was copied via insert code. It doesn't show all of the "want" data set program. Also, will what you've suggested work if the data does have entries? For instance, if OOH1 and OOH2 both have "Y" will the code you provide still allow OOH3 to have "Y" added? Thanks.

shellp55 · ‎02-22-2016

Thanks for your response. I found that using the same code as what is there puts "Y" in all the OOH. Note also that I tried to use the code insert but it wouldn't accept all the code, even when I split it in two so that is why I had to use as attachment. However, in future I will save to WordPad since most users will have that.

shellp55 · ‎02-22-2016

Hi Thanks for responding. The data actually isn't "inconsistent", this is the format that the data is always saved in via other software so I can't do anything about that. Is there not a way to get at the information I require? Thanks.

shellp55 · ‎02-22-2016

I am using SAS 9.3. I have some patient data where one line of code is one patient visit. In the procedure data, the field of procedure date and doctor is only entered on occurrence 1 but not for other occurrences included in the same date. The code attached fixes that except for the out of hospital field (OOH1-OOH4). The OOH field is either Y or blank and with the example attached, record 4 should have a Y for OOH2 and OOH3 but not for OOH4. So I'm trying to figure out how to copy down within the same episode but if the date changes to signify a new procedural episode and the first occurrence of that new procedural episode isn't "Y" then no others in that episode will be. Thanks for any and all assistance.

shellp55 · ‎09-10-2015

Thanks for your responses. I'll check out your suggestions and see what I can come up with. The code I have already uses /O so maybe it is sorting in that order and not in number order as I assumed.

Online Status	Offline
Date Last Visited	‎11-26-2023 11:40 PM

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Re: Exporting SAS dataset to MS-Access

Exporting SAS dataset to MS-Access

Re: Memo Field in First Row of Excel Export?

Memo Field in First Row of Excel Export?

Re: Creating Export Name from Variables?

Re: Creating Export Name from Variables?

Re: Exporting Data to Acess - Error

Re: Exporting Data to Acess - Error

Re: Rename Macro Do Loop Where Value is 1 Less than Current Occurence

Re: ODS Excel tagattr not working for data types/formats

Re: Loop Through Multiple Datasets and Create Field based on Dataset N...

Loop Through Multiple Datasets and Create Field based on Dataset Name?

Re: Referencing Time Values to Create a Group

Referencing Time Values to Create a Group

Re: One Record Per Hour of Day?

Re: One Record Per Hour of Day?

Re: One Record Per Hour of Day?

Re: One Record Per Hour of Day?

One Record Per Hour of Day?

Re: Copying Field Values Based on Another Field

Re: Copying Field Values Based on Another Field

Re: Copying Field Values Based on Another Field

Re: Copying Field Values Based on Another Field

Copying Field Values Based on Another Field

Re: Sequence File Importing Based on Text File Creation/Modified Date?