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;

 

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.

Register now!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 1 reply
  • 714 views
  • 3 likes
  • 2 in conversation