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

[amin1234]

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;

[novinosrin]

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;

[PaigeMiller]

Is the variable DISEASED numeric or character?

[amin1234]

It's a character variable. 

[novinosrin · Accepted solution]

Ok so add a $ to format name and try again

proc format;

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

run;

[ballardw]

---

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

[amin1234]

Thank you! @ballardw @novinosrin @PaigeMiller