topic Re: how ro merge a dataset with a format folder in New SAS User

how ro merge a dataset with a format folder

Jannie_D — Wed, 09 Dec 2020 14:22:59 GMT

I have a problem that I have worked on for days now.

I Have a big SAS dataset that has a corresponding formatfolder. I have tried to run the dataset without merging it with the formatfolder first. But I keep on getting errors or notes that the format was not found, which is prohibiting the results in showing. I have even tried to start with the options=nofmterr statement but without success.

I think I need to merge the format folder with my dataset to make it work, but I have no idea how to.

I can not make a merge statement as there are no common variables. The only common parameter is that the label in dataset corresponds with the variable Label_name in the formatfolder.

I have tried to make a fmtlibname statement, but could not make it work.

What do I do?

Re: how ro merge a dataset with a format folder

Tom — Wed, 09 Dec 2020 14:30:41 GMT

What do you mean by a "format folder"?

SAS stores formats in catalogs. The default name for the catalog is FORMATS, but you can use any valid member name for the name of the catalog that contains the formats. So if you have a file named formats.sas7bcat then that is a format catalog. To reference that catalog make a libref that points to the directory (aka "folder") where the file exists.

libname myfmts 'my format folder';
options insert=(fmtsearch=(myfmts.formats));

If instead you have some SAS code that runs PROC FORMAT and creates the formats then just run the code.

%include "my format folder/formats.sas";

If mean something else then explain in more detail what it is that you have.

Re: how ro merge a dataset with a format folder

Kurt_Bremser — Wed, 09 Dec 2020 14:43:24 GMT

I suspect that you have datasets that can be used as CNTLIN datasets for PROC FORMAT. Such datasets would contain columns named fmtname, start, label, type.

Re: how ro merge a dataset with a format folder

ballardw — Wed, 09 Dec 2020 15:28:27 GMT

@Jannie_D wrote:

I have a problem that I have worked on for days now.

I Have a big SAS dataset that has a corresponding formatfolder. I have tried to run the dataset without merging it with the formatfolder first. But I keep on getting errors or notes that the format was not found, which is prohibiting the results in showing. I have even tried to start with the options=nofmterr statement but without success.

I think I need to merge the format folder with my dataset to make it work, but I have no idea how to.

I can not make a merge statement as there are no common variables. The only common parameter is that the label in dataset corresponds with the variable Label_name in the formatfolder.

I have tried to make a fmtlibname statement, but could not make it work.

What do I do?

Please run this code:

proc options option=fmtsearch;
run;

Your log will show something like:

 FMTSEARCH=(WORK LIBRARY)
                   Specifies the order in which format catalogs
                   are searched.

Copy the result similar to above from your Log and paste into a code box opened on the forum with the </>.

Then show use the library name and details about your "format folder".

If you do not have 1) the library appear in the FMTSEARCH path as shown in the code then you need to add it as @Tom shows.

FMTSEARCH is where SAS looks for Formats. If your formats are not in one of the places listed it cannot find them.