SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

In Office Analytics, has anyone created a geo-graphic report on groups of Zipcode?

Reply
Contributor
Posts: 23

In Office Analytics, has anyone created a geo-graphic report on groups of Zipcode?

Hi everyone,

 

I would like to do a visual report of sales by areas:

area1, $100

area2, $300

area3, $200

etc.

 

Area1 has a set of Zipcodes, area2 has another set of Zipcodes, so as area3... All of the areas are mutually exclusive.

 

Is this possible in OA? Ideally each area will have its own shape.

What kind of geo-shapes does OA have internally?  It would be helpful if you can direct me to some documentaions.

 

Thanks,

Jane

Contributor
Posts: 23

Re: In Office Analytics, has anyone created a geo-graphic report on groups of Zipcode?

To make it simpler, we can assume the area to be DMA. I found the DMA in maps.usaac.

 

However when using "Edit" to bring in the maps.usaac, it complains "The map data set is required to have an X and Y variable", not sure what the X and Y means.  I thought the X is the DMA variable, the Y as the response variable (sales) will come from my dataset.

 

Here is how my data set look like:

DMA, stname, sales

698, Alabama, $100

503, Georgia, $200

679, Iowa, $300

 

I would like to have a choropleth graph, with colors showing diferrent sales for each DMA, the mouse tip shows the actual sales $.

 

I am curious if anyone else had similar issues, please let me know what went wrong in my case.

 

Thanks,

Ask a Question
Discussion stats
  • 1 reply
  • 230 views
  • 0 likes
  • 1 in conversation