topic Location of user defined format in SAS Programming

Location of user defined format

David_Billa — Thu, 09 Jun 2022 09:38:54 GMT

In one of our program, they have called the user defined format as shown below. Program is working fine and they have not created the format in that program. But I could not locate where this format is created. Any help?

type = put(material, $mattype.);
Category = put(type,$type.);

Re: Location of user defined format

Kurt_Bremser — Thu, 09 Jun 2022 09:53:30 GMT

Query DICTIONARY.FORMATS:

proc sql;
select libname, memname, path
from dictionary.formats
where fmtname in ('$MATTYPE','$TYPE')
;
quit;

Re: Location of user defined format

Ksharp — Thu, 09 Jun 2022 11:42:10 GMT

As Kurt said. use DICTIONARY, and get the path name by PATHNAME() .

proc format ;
value fmt
1='asf';
run;


proc sql;
select * from dictionary.formats where source='C';
quit;

%let path=%sysfunc(pathname(WORK));
%put &=path.;

Re: Location of user defined format

David_Billa — Thu, 09 Jun 2022 11:49:14 GMT

@Kurt_Bremser It's blank in path name, no values.

Re: Location of user defined format

Kurt_Bremser — Thu, 09 Jun 2022 12:09:05 GMT

@David_Billa wrote:

@Kurt_Bremser It's blank in path name, no values.

And what is in LIBNAME and MEMNAME?

Re: Location of user defined format

David_Billa — Thu, 09 Jun 2022 12:48:13 GMT

@Kurt_Bremser Library Name - WORK and MEMBER NAME - FORMATS

Re: Location of user defined format

Kurt_Bremser — Thu, 09 Jun 2022 13:13:40 GMT

@David_Billa wrote:

@Kurt_Bremser Library Name - WORK and MEMBER NAME - FORMATS

Then the formats were created by code you ran in your current session. You need to work through all the codes you ran after starting your session.

Re: Location of user defined format

AllanBowe — Sun, 12 Jun 2022 11:32:07 GMT

For info, this macro will query the dictionary table and return details of the attributes of all the formats in a table (including path): https://core.sasjs.io/mp__getformats_8sas.html