BookmarkSubscribeRSS Feed
RichardDeVen
Barite | Level 11

I do not work for JCP nor own stock in JCP.  June 4, 2020 I saw various news feeds reporting JCP was planning to close stores in 2020.

 

From the company blog 

JCPenney made the difficult decision to close 154 stores. 

What does that look like from a mapping standpoint ?

 

JCP store closings announced June 4, 2020JCP store closings announced June 4, 2020

 

Attached program shows how the data for the map was retrieved from public information, matched and classified

  • Store locator
    • Scrape and crawl
      • Proc HTTP, INPUT @, PRXCHANGE
      • No external HTML DOM parsing
    • Addresses, Latitude and Longitude
  • Company blog list of closings
    • Addresses
  • The match for 'closing' status assigned using SQL UPDATE and existential where sub-query

Map drawn with snippet

    proc sgmap plotdata=plotdata;
      openstreetmap;
      bubble x=x y=y size=bubble_size / group=status;
    run;

 

The store data is attached for later use when web content may no longer be present, accessible or contextually accurate (this post wise).

 

1 REPLY 1
DanH_sas
SAS Super FREQ

One suggestion:

 

Looks nice!

 

One thought: Since the bubble_size has no contribution from the original data, perhaps use a SCATTER plot instead, with a symbol of CIRCLEFILLED. You can use the SIZE option in MARKERATTRS to adjust the size like you want.

 

    proc sgmap plotdata=plotdata;
      openstreetmap;
      scatter x=x y=y / group=status markerattrs=(symbol=circlefilled);
    run;

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 1 reply
  • 517 views
  • 3 likes
  • 2 in conversation