BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ari2495
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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

View solution in original post

4 REPLIES 4
ari2495
Obsidian | Level 7
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
Super User
format commax22.2
----->
format=commax22.2
Tom
Super User Tom
Super User

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 233 views
  • 3 likes
  • 4 in conversation