topic commax format error in New SAS User

commax format error

ari2495 — Mon, 07 Aug 2023 10:29:49 GMT

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

Re: commax format error

Kurt_Bremser — Mon, 07 Aug 2023 10:47:43 GMT

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

Re: commax format error

ari2495 — Mon, 07 Aug 2023 10:57:44 GMT

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

Re: commax format error

Ksharp — Mon, 07 Aug 2023 12:00:09 GMT

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

Re: commax format error

Tom — Mon, 07 Aug 2023 13:23:18 GMT

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