Date:         Thu, 9 Dec 2010 14:47:55 -0800
Reply-To:     Frank.X.Qin@KP.ORG
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

Hi,


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

PROC FORMAT;

 VALUE $CCMUDS
      '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      '
;

........


RUN;

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
like

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
file.

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.

Thanks,

Frank



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.