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
@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.
Missed SAS Innovate in Orlando?
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.