Location of user defined format

[David_Billa]

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.);

[Kurt_Bremser]

Query DICTIONARY.FORMATS:

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

[David_Billa]

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

[Kurt_Bremser]

---

@David_Billa wrote:

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

---

And what is in LIBNAME and MEMNAME?

[David_Billa]

@Kurt_Bremser  Library Name - WORK and MEMBER NAME - FORMATS

[Kurt_Bremser · Accepted solution]

---

@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.

[Ksharp]

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.;

[AllanBowe]

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