topic Re: Format $[name] was not found or could not be loaded in SAS Programming

Format $[name] was not found or could not be loaded

amin1234 — Fri, 08 Jun 2018 14:50:05 GMT

I created and user defined format but when I run data step to apply format the log reads Format $disf was not found or could not be loaded. I am using SAS University Edition. Engine V9. Below is the full code. Any ideas will be appreciated.

libname abc "/folders/myfolders/xyz";

Proc import datafile="/folders/myfolders/xyz/document.xlsx"

out=doc1

dbms=xlsx;

run;

proc format;

value disf 0='No' 1='Yes';

run;

data doc2; set doc1;

format diseased disf.;

run;

Re: Format $[name] was not found or could not be loaded

novinosrin — Fri, 08 Jun 2018 14:54:49 GMT

You need to examine your dataset doc1 thoroughly and properly. Your code works fine for my example:

proc format;

value disf 0='No' 1='Yes';

run;

 

data w;
do i=1 to 10;
 do j=0 to 1;
output;
end;
end;
format j disf.;
drop i;
run;

Re: Format $[name] was not found or could not be loaded

PaigeMiller — Fri, 08 Jun 2018 14:55:43 GMT

Is the variable DISEASED numeric or character?

Re: Format $[name] was not found or could not be loaded

amin1234 — Fri, 08 Jun 2018 15:00:59 GMT

It's a character variable.

Re: Format $[name] was not found or could not be loaded

novinosrin — Fri, 08 Jun 2018 15:13:56 GMT

Ok so add a $ to format name and try again

proc format;

value $disf 0='No' 1='Yes';

run;

Re: Format $[name] was not found or could not be loaded

ballardw — Fri, 08 Jun 2018 15:28:42 GMT

@novinosrin wrote:

Ok so add a $ to format name and try again
proc format;

value $disf 0='No' 1='Yes';

run;

AND use the new format:

data doc2; set doc1;

format diseased $disf.;

run;

Re: Format $[name] was not found or could not be loaded

amin1234 — Fri, 08 Jun 2018 15:31:17 GMT

Thank you! @ballardw @novinosrin @PaigeMiller