topic Re: Compute IQR and STD per record to proc gmap in SAS Programming

Compute IQR and STD per record to proc gmap

Cruise — Tue, 16 Jun 2020 01:48:19 GMT

Hi Folks:

I'd like to describe the extent of inequality in health behavior in Korea using descriptive statistics.The variable is continuous and the data is attached to this post. I already mapped actual health behavior using proc gmap approach shown in the code below.

But, I also would like to map the standard deviation and inter-quartile difference of each observation (each district and 250 districts in total) of the variable using the same gmap approach. Since mapping IQR diff and STD maybe more meaningful than visualizing actual variable given the purpose is to show disparity in the spatial distribution of the variable.

Could you please help me compute inter-quartile difference and STD of the variable for each observation in the data?

I greatly appreciate any hints or suggestions.

Thanks in advance.

proc gmap data=have map=mapsgfk.south_korea;
id id;
choro health_behavior/ legend=legend1;
legend1 position=(bottom center inside) across=1 mode=reserve 
label=(position=top j=c);
format std_health_behavior comma5.;
run;
quit;

Re: Compute IQR and STD per record to proc gmap

Reeza — Tue, 16 Jun 2020 01:50:55 GMT

IQR and STD are not record level data, they're aggregate statistics that represent a group of data not a single point.

Can you explain in more detail what you're looking for?

If you could provide your data as a data step that's appreciated as well.

Re: Compute IQR and STD per record to proc gmap

Cruise — Tue, 16 Jun 2020 10:07:30 GMT

@Reeza

Hi Reeza, thanks for asking. I'm trying to come up with a map presenting the inter-quintile differences in health behavior in 250 districts of Korea. Inter-quintile or standard deviation of each observation would present the gap in health behavior across the 245 districts.

Re: Compute IQR and STD per record to proc gmap

Reeza — Tue, 16 Jun 2020 15:47:37 GMT

Inter-quintile differences is not a term I'm familiar with, I'm assuming it's from economics? You'll need to match the papers definition but I only quickly skimmed it and couldn't find an obvious definition in the supplement. Unfortunately I cannot take that time this week to deep dive into a paper. Good Luck.

Re: Compute IQR and STD per record to proc gmap

Cruise — Tue, 16 Jun 2020 17:48:52 GMT

I had same exact thought process. Thanks Reeza. This helps. By the way, I decided to map the value itself which leads to a meaningful interpretations that makes sense given the country's local health and economic contexts. Thanks again for taking your time and responding to me.