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.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.