BookmarkSubscribeRSS Feed
Malarkey
Obsidian | Level 7

forAll -

I'm new to EG - using EG 5.1.  I've been using base SAS for a loooonnnngg time, so maybe I'm missing something in the translation...

I'm trying to set EG up so my boss can use it.  He LOVES the characterize data task, but the univariate report output for date fields only shows a two digit year.  As a work-around, I tried just making the datasets and using the list report task.  When I do that, the date fields just print the SAS date number.  Is there a way to apply a format in the list report task?  Or to change the date format in the characterize data task?

Thanks!

2 REPLIES 2
ChrisHemedinger
Community Manager

Malarkey,

Yes, you can change the formats in the List Report task.  On page 2 of the wizard, select Edit and then Column Formats.  You'll then have a window that allows you to specify formats for each of the columns in your report.

lrf.png

Chris

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
Malarkey
Obsidian | Level 7

Thanks, Chris!

The problem is, if I do that for the output from the characterize task, proc univariate, the non-date fields end up as dates.  I suppose I could add a task to split the univariate file into dates and non-dates and then do a list report...

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1194 views
  • 3 likes
  • 2 in conversation