Thank you so much, PG.  I'll investigate as per your suggestion. ... View more

perhaps by sorting by chartno admdate descending and then processing similarly? ... View more

shellp55,      DBailey's approach should work. Below is the solution I offer.      If death_indicator = (0 : lived, 1 : died), then the following approaches should clean your dataset of deceased patients: data patients; input card_number visit death_indicator 8.; datalines; 1 1 0 1 2 0 1 3 0 2 1 0 2 2 1 3 1 0 3 2 0 ; run; APPROACH ONE proc sql; create table living_patients as select a.* from patients as a left join (select distinct * from patients where death_indicator = 1) as b on a.card_number = b.card_number where b.death_indicator ne 1; quit; APPROACH TWO proc sort data=patients; by card_number descending death_indicator; run; data living_patients; set patients; by card_number descending death_indicator; retain deceased_card_number; if first.card_number and death_indicator = 1 then deceased_card_number = card_number; if card_number ne deceased_card_number; drop deceased_card_number; run; Hope this helps, Huey ... View more

Try this 31244 - SASZIPAM access method - use at your own risk. ... View more

Hi Reeza I'll provide some sample data soon but just to clarify, I used as you suggested but found that it wasn't calculating the different readmit status of 7, 14, 21 and 30 days, only showing the date_diff time.  Also, the readmit information is attached to the readmit case, not the original case. This is still somewhat useful but what I really want is that the initial case for this doctor/procedure (which I'm calling the index case) has the readmit information attached to it which is why I was wondering whether there should be two data sets merged. So if chartno 555555 has the criteria of doctor/procedure, then attached to that record is a series of data elements from the 1st readmission, then the second readmission etc. I don't know if this makes sense and I apologize if it doesn't.  I'll post sample data soon..... ... View more

I must bow to this demonstration and vow never to use this function again! Thanks Tom. PG ... View more

Hi Just an FYI that the software to use the x command for WinZip is a free download so I tried that.  Based on the information, including the syntax to do so, I ran the program below but it isn't extracting from the text file portion.  The log doesn't indicate any errors, just that "0 records were read from the infile testing". Can someone please advise why this isn't working?   Any and all assistance greatly appreciated. filename testing pipe '"C:\Program Files\WinZip\wzunzip.exe" -vb F:\myfolder\Test.zip test.txt'; data work.import_test; infile testing truncover LRECL = 5000 firstobs=10; input @1 Prov   $1.    @2 Inst   $4.    @6 Fyear   $4.    @10 Period   $2.    @12 Batch   $2.    @14 AbsNo      $3.    @18  Coder   $2.    @20 ChartNo   $10.    @30 RegNo   $7.    @37 SecChartNo  $10.    @47 MatNBChart  $10.    @57 HCN   $12.    @69 Postal   $6.    @75 Rescode   $7.    @82 Sex   $1.    @83 ProvHCN   $2.    @85 RFP   $2.; run; ... View more

Ksharp: Quote from OP's first post: "What I want to do is search through the data and find the diagnosis that is the type of "M", make it the first occurrence and resequence all other diagnoses within the abstract after that." Looks like that OP only cares about first 'M', then resequence rest of whatever. Haikuo ... View more