Date: Thu, 9 Dec 2010 14:47:55 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Frank Qin <Frank.X.Qin@KP.ORG>
Subject: How to update SAS format program with a transition file
Content-Type: text/plain; charset=US-ASCII
1. We use SAS format program (FORMATS.SAS) to create all SAS formats for
use in other SAS programs. For simplification, the FORMAT.SAS is like
'5500' ='APC A '
'5501' ='APC B '
'5502' ='APC C '
'5503' ='APC D '
'5504' ='APC E '
'5505' ='APC F '
'5506' ='APC G '
'5510' ='ADM GENERAL '
'5511' ='ADM SUB SPEC '
'5518' ='HBS CALL '
'5519' ='HBS '
'5520' ='POP MGMT '
'5530'-'5539' ='URGENT CARE '
2. Now, we have new coding system and we have transition file to convert
the old number and name into new number and name. The transition file is
Old_CC old_Name New_CC NEW_Name
5500 APC A 2265 Adult Primary Care-Unit A
5501 APC B 2266 Adult Primary Care-Unit B
5502 APC C 2267 Adult Primary Care-Unit C
5503 APC D 2268 Adult Primary Care-Unit D
5504 APC E 2269 Adult Primary Care-Unit E
5505 APC F 2270 Adult Primary Care-Unit F
5506 APC G 2271 Adult Primary Care-Unit G
5520 POP MGMT 2170 Population Management
5521 POP MGMT 2175 Population Management-Asthma
5530 POP MGMT-HEALTHY 2185 Population Mgmt-Healthy Living
5531 POP MGMT-HYPERTE 2186 Population Mgmnt-Hypertension
5532 POP MGMT-A 2171 Population Management-A
5533 POP MGMT-B 2172 Population Management-B
3. I would like to update the FORMATS.SAS with the transition file, Or to
create a new FORMATS.SAS with the existing FORMATS.SAS and transition
Since the PROTMAT.SAS is a huge file, it's time consuming to manually
update it. I would like to update with SAS program.
How can I update FORMATS.SAS or create the new one?
Any help is appreciated.
NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail,
you are prohibited from sharing, copying, or otherwise using or disclosing
its contents. If you have received this e-mail in error, please notify the
sender immediately by reply e-mail and permanently delete this e-mail and
any attachments without reading, forwarding or saving them. Thank you.