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 (August 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 23 Aug 2006 10:33:44 -0400
Reply-To:   "Mackin, John" <John.Mackin@BCBSFL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Mackin, John" <John.Mackin@BCBSFL.COM>
Subject:   THINKING CAP QUESTION FOR SASL
Content-Type:   text/plain; charset=us-ascii

PAT ID CPT INCR_DT PRF_PROV PAID

987123456219770912 36415 2005-10-17 16577 0.00 KEEP 987123456219770912 36415 2005-10-18 94351 0.00 KEEP 987123456229770912 36415 2005-10-25 16577 0.00 DROP 987123456229770912 36415 2005-10-31 16577 0.00 DROP 987123456219770912 36415 2005-12-05 16577 0.00 DROP 987123456219770912 36415 2006-02-20 94351 10.00 KEEP 987123456219770912 36415 2006-02-20 16577 10.00 KEEP 987123456219770912 36415 2006-02-22 16577 0.00 KEEP 987123456219770912 36415 2005-10-17 16577 8.00 DROP 987123456219770912 45678 2005-10-17 16577 0.00 DROP 987123456219770912 80099 2005-10-17 94351 18.00 KEEP 987123456219770912 80099 2005-10-17 16577 11.00 KEEP 987123456219770912 80127 2005-10-18 16577 0.00 KEEP 987123456219770912 36415 2005-10-20 12345 5.00 DROP 987123456219770912 80125 2006-06-09 16577 0.00 KEEP 987123456219770912 80215 2006-06-09 94351 40.00 KEEP 987123456219770912 80215 2006-06-12 16577 40.00 KEEP

Above is a small sample of the data I extracted for labs. The ones in I wish to keep are marked KEEP and in bold.

What I need to keep is the same patid, same cpt, same incurred date or incurred date within a four (4) day tolerance from the first date of service, but any performing provider or paid amounts.

I can't seem to get the four day tolerance to work, not included in coding at this time. Any assistance Or coding changes will be appreciated. THANKS

/*SLIMS down the file and sorts it */ proc sql; create table sasuser.pickmefirst as select distinct * from sasuser.mikesstuff order by pat_id, incr_dt, cpt, prf_prov; quit;

/* gets rid of records with only one provider performing the cpt service */ /* and leaves you with the duplicate providers you are looking for! */ data sasuser.pickmenext; set sasuser.pickmefirst; by pat_id incr_dt cpt prf_prov; if first.cpt and last.cpt then delete; run;

OUTPUT FROM CODING:

PAT ID CPT INCR_DT PRF_PROV PAID

987123456219770912 36415 2005-10-17 16577 0.00 KEPT 987123456219770912 36415 2005-10-18 94351 0.00 KEPT 987123456219770912 36415 2006-02-20 94351 10.00 KEPT 987123456219770912 36415 2006-02-20 16577 10.00 KEPT 987123456219770912 36415 2006-02-22 16577 0.00 MISSING 987123456219770912 80099 2005-10-17 94351 18.00 KEPT 987123456219770912 80099 2005-10-17 16577 11.00 KEPT 987123456219770912 80127 2005-10-18 16577 0.00 MISSING 987123456219770912 80125 2006-06-09 16577 0.00 KEPT 987123456219770912 80215 2006-06-09 94351 40.00 KEPT 987123456219770912 80215 2006-06-12 16577 40.00 KEPT

Mike Mackin Senior Health Care Data Analyst Blue Cross Blue Shield of Florida Data Intelligence Unit DCC-6 FL-1 Phone: 904-905-4541

Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. The information contained in this document may be confidential and intended solely for the use of the individual or entity to whom it is addressed. This document may contain material that is privileged or protected from disclosure under applicable law. If you are not the intended recipient or the individual responsible for delivering to the intended recipient, please (1) be advised that any use, dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender immediately by telephone and destroy the document. THANK YOU.


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