topic proc format & stored format in library in New SAS User

proc format & stored format in library

anming — Tue, 08 Dec 2020 03:20:14 GMT

libname myfmts "/folders/myfolders/formats";

will create a format library myfmts and format file will be saved as formats.sas7bdat in the formats folder.

you can define a format name as $genderf in the format file

PROC FORMAT library=myfmts;
	VALUE $genderf 'm'='Male' 'f'='Female';
run;

you can further write the second format names as group into the same format file.

PROC FORMAT library=myfmts;
	VALUE asgroup 0-<60='F' 60-<70='D' 70-<80='C' 80-<90='B' 90-High='A' 
		Other='Missing';
run;

the format file can be checked by

proc format library=myfmts fmtlib;
run;

libname myfmts "/folders/myfolders/formats" ;
options fmtsearch=(myfmts work library);

proc print data = dataset1;
	format gender $genderf. averagescore asgroup.;
run;

any misunderstanding?

Re: proc format & stored format in library

SASKiwi — Tue, 08 Dec 2020 03:58:56 GMT

SAS formats are stored in SAS catalogs which have a file extension of sas7bcat.

If you want to call your SAS FORMATS catalog other than FORMATS then use LIBRARY = MyLib.MyFormats on your PROC FORMAT statement.

Re: proc format & stored format in library

ballardw — Tue, 08 Dec 2020 17:29:54 GMT

And if the name of the format catalog is other than Formats you need to reference it in the FMTSEARCH with libname.myfmts or what ever.