commax format error

[ari2495]

Hi, I used commax format to format some numeric variables. Nevertheless, running the code I got an error: "character expression requires character format"

proc sql;
	create table 
	table
	as select 
		variable1,
		variable2   		format commax22.2
	from source;
quit;

I'm sure variable 2 is numeric, why do I get the error? thanks anyone for help

[Kurt_Bremser]

Why are you "sure"? Did you run PROC CONTENTS?

[ari2495]

Yes, i've just run, and i found out the format is "best". Can you suggest me what to do? thanks and excuse me, i'm a new user

[Ksharp]

format commax22.2
----->
format=commax22.2

[Tom · Accepted solution]

---

@ari2495 wrote:
Yes, i've just run, and i found out the format is "best". Can you suggest me what to do? thanks and excuse me, i'm a new user

---

Note the question is not what format is ATTACHED to the variable.  The question is what TYPE is the variable.