topic Re: formats conversion in SAS Procedures

formats conversion

deleted_user — Thu, 21 Jan 2010 18:14:08 GMT

How can a SAS formats catalog be converted to a SAS data set of variable and value labels?

Re: formats conversion

abdullala — Thu, 21 Jan 2010 18:18:21 GMT

check these functions:

proc format cntlin=

and

proc format cntlout=

for input and output of formats.

Re: formats conversion

deleted_user — Thu, 21 Jan 2010 22:09:13 GMT

This does appear to be the correct function.
Could you specify a little further for me please?

I have a formats catalog file "formats.sas7bcat" in the path "c:\"
To obtain the formats in data set "newfile.sas7bdat, would the program be something like the following?

LIBNAME PATH "C:\"
PROC FORMAT LIB = PATH CNTLOUT=NEWFILE;
RUN;

The PROC FORMAT in this case not valid, so perhaps you could advise further?

Re: formats conversion

sbb — Thu, 21 Jan 2010 22:29:00 GMT

Your code appears to be correct in its current format. You will find the SAS file WORK.NEWFILE contains your unloaded formats.

The SAS documentation on PROC FORMAT has detailed information about the CNTLOUT= file contents - documentation starts here (with focus on CNTLOUT= parameter and the Output Control Data Set discussion):

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473464.htm

Scott Barry
SBBWorks, Inc.

Re: formats conversion

deleted_user — Thu, 21 Jan 2010 22:37:51 GMT

You are very kind to reply. The program results in an error message on the PROC FORMAT line that the PROC option is not valid. I think it must probably something basic, but any advice is appreciated.

Re: formats conversion

sbb — Thu, 21 Jan 2010 22:40:26 GMT

Post a reply and PASTE the SAS log with the code and the associated error message(s). Also, provide info about your SAS version, OS where SAS is running, and whether SAS is running local on your machine or on a remote server.

Scott Barry
SBBWorks, Inc.

Re: formats conversion

Cynthia_sas — Fri, 22 Jan 2010 00:00:42 GMT

Every SAS statement ends with a semi-colon, including the LIBNAME statement. I thought I would check that your lack of a semi-colon on the LIBNAME statement was a cut and paste error.

cynthia

Re: formats conversion

deleted_user — Fri, 22 Jan 2010 14:40:13 GMT

This was the problem. Thank you.