BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RPYee
Quartz | Level 8

I am about as much a "newbie" to SAS as a newbie can be, so please forgive my elementary level questions.  I'm sure there will be a lot of them forthcoming since we are transitioning to this software.  I'm NOT happy, but in no position to argue 😞


I run a lot of summary reports that incorporate numeric data. The output is always given without commas and with two decimal places.  Is there a way I can set the default number format to use commas and have no decimal?  I can't seem to remember to check the format when I set up the summary definition, so I'm always backtracking once the report is complete.

 

Thanks, in advance, for any help you can provide.

Rita Yee

Project Engineer - FedEx Express

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

I see -- hopefully you'll get to have a bomb-diggity experience in your SAS life too...once you get a bit deeper.

 

If you can assign those formats as part of the query result, you might find that it carries over into your reports with no extra (forgettable) steps.

 

bombdiggity.png

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

View solution in original post

6 REPLIES 6
Reeza
Super User

Maybe...how are you running your summary reports? Code or via GUI?

 

RPYee
Quartz | Level 8
via GUI...
___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
ChrisHemedinger
Community Manager

Are you using the Query Builder for this, and then (forgetting to) set the format on the output column?  Or perhaps a task like Summary Tables, which produces a crosstab?

 

If it's a report on the same style of data (or exact same data) that you produce often, you might be able to leverage Task Templates to define the report once, save it, and reapply in subsequent projects.  The Query Builder also supports templates.  You can check the SAS Enterprise Guide help (assuming that's the GUI you're using) and learn more about task templates -- search the help index.

 

 

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
RPYee
Quartz | Level 8

I have a couple of queries whose results are joined together through a third query.  The results of that query are then "Described", as Summary Tables, several times to get varying outcomes.  It may be an archaic way of doing this, but until I am able to dive in more and understand more of what I'm looking it, it's the only way I know to get the correct results in the end, albeit the format is ugly 🙂 

 

Long story short, we currently use Hyperion Interactive Reporting Studio (purchased by Oracle) which is the absolute BOMB DIGGITY for software!  Fast, efficient, manageable, POWERFUL... Oracle is killing the support of Hyperion and pushing their own software that is mediocre at best.  As a result, we're transferring all of our reports and queries over to SAS.  There may be one or two aspects of SAS that beat Hyperion, but not enough to warrant changing.  As it is, Oracle leaves us no choice but to bid them adieu.

 

I appreciate your feedback and suggestions.  I will look into the use of templates.  I had a very basic class, but templates weren't covered.

 

Thanks again!

Rita

___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.
ChrisHemedinger
Community Manager

I see -- hopefully you'll get to have a bomb-diggity experience in your SAS life too...once you get a bit deeper.

 

If you can assign those formats as part of the query result, you might find that it carries over into your reports with no extra (forgettable) steps.

 

bombdiggity.png

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
RPYee
Quartz | Level 8
Sweet. Let me go give that a try 🙂
___________________________________
The fact that I ask for help simply means I am inexperienced and under-educated. Please don't assume I am incompetent and uneducated.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1359 views
  • 0 likes
  • 3 in conversation