Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS Visual Analytics 7.4

Reply
Contributor
Posts: 72

SAS Visual Analytics 7.4

I'm exporting excel data into SAS VA 7.4 with some duplicate records such as follows:

 

Date                   ID           Sale_Amount

12/2/2017      XM001            $10,000

12/2/2017      XM001            $12,000

12/2/2017      XM001            $  8,000

 

However, in preview section I see all the 3 records.  However, in VA Report designer (crosstab, listtable), it's just showing 1 record.  Any suggestions please ?

 

Thanks

 

PROC Star
Posts: 399

Re: SAS Visual Analytics 7.4

HI!

In the list table object there is an option "Show details" that allows you to show all records. Smiley Happy

You will find it in the properties tab to the right.

//Fredrik

Contributor
Posts: 72

Re: SAS Visual Analytics 7.4

Thanks for the response.  How About in the Crosstab ?

PROC Star
Posts: 399

Re: SAS Visual Analytics 7.4

Hi!

The purpose with the cross-tab is to do calculations (sum, avg, max, etc) across the selected dimensions.

If you want detailed information you need to add a dimension that contains the detail level (id, key or similiar).

//Fredrik

Ask a Question
Discussion stats
  • 3 replies
  • 231 views
  • 0 likes
  • 2 in conversation