topic Re: proc format in SAS Procedures

proc format

sam369 — Mon, 26 Aug 2013 16:01:44 GMT

Hi All,

i have a question on formats. we created som formate in 2009 version on sas is 8.2. now we are using sas9.2. now i am unable to read those formats

test code

libname data "newdata" access=readonly;

libname form "oldformatpath/formats' access=readonly;

proc format lib=work cntlin=form.formats;

options fmtsearch=(work);

getting error on log:

error:File form.formats.data does not exits.

How to read those old formats on new version. Any thoughts on this

Thanks

Sam

Re: proc format

ballardw — Mon, 26 Aug 2013 16:15:32 GMT

You probably need to create an output file from the formats in the FORM library first:

proc format library=form cntlout=work.cntlin; run; /8 actually I would put this in a permanent library but since the only ones you reference you have made readonly the dataset can't be created there*/

proc format library= work cntlin=work.cntlin;run;

You don't mention if the OS for the 8.2 version was the same as current. If not, there will be some other issues.

Re: proc format

sam369 — Mon, 26 Aug 2013 18:06:34 GMT

Hi ballardw,

Thank you for your response , i applied what you suggested. i am getting error like

ERROR: File FORM.FORMATS.CATALOG was created for a different operating system.

now i am using on Unix. how to resolve this format issue

Thanks

Sam

Re: proc format

Tim_SAS — Mon, 26 Aug 2013 19:28:12 GMT

This note looks like it will help:

34443 - Determine the operating system in which a format catalog was created

Re: proc format

ballardw — Mon, 26 Aug 2013 20:26:16 GMT

If you have a machine with the previous OS and a SAS license, then use that to create the CNTLOUT output data set from the library. Then create a transport data set and import to the Unix systm. Or find the code that created the formats.

I'm sure there are other methods as well.