Usage Note 7488: Instructions for setting up Geographic Analysis in SAS Human Capital
Management
Geographic Analysis Global Setup instructions for SAS Human Capital
Management Software (formerly HR Vision):
-Should a customer site wish to display the Geographic Analysis in a
global view, there are various tasks to complete.
-In review, the purpose of the analysis is to present data in a
geographic manner allowing a user to see information or trends based
on location. A map is displayed where those geographic areas with
data are color filled. As the user mouses over a color filled state,
a floating information box is displayed. This box contains
information fields such as the name of the state and statistical data
for that state.
-Since a global map is not shipped with SAS Human Capital Management,
one must be created which is tailored to the site's country field
values. The country column in the data table must have data values
that match the geographic id column in the map data set and the
columns should share the same name (ie. country).
-Beginning with the SAS Human Capital Management 2.05 codes table and
projected world map, the following DATA step program creates a global
map data set merging the country abbreviation on to the map data set.
/*output codes data set with abbr as country and upcase name as
cntrynme*/
data cntrycd(rename=(start=country
label=cntrynme)
drop=fmtdesc);
set library.codes(drop=fmtname);
label = upcase(label);
run;
proc sort data=cntrycd;
by cntrynme;
run;
/*output country name data set with upcase name as cntrynme and num
code as id*/
libname HRVMAPS 'C:\HR_VIS\HRVMAPS'; /* HCM Vision 2.05 path */
proc sort data=HRVMAPS.cntrynme out=cntrynme(rename=(country=id));
by cntrynme;
run;
/*merge the cntrynme data with the cntrycd data by cntrynme(upcase
country name) if the country field is blank copy the cntrynme
into it*/
data cd_name(drop=cntrynme);
merge cntrynme(in=a)
cntrycd;
by cntrynme;
if a;
if country = '' then country = cntrynme;
run;
proc sort;
by id;
run;
proc sort data=HRVMAPS.worldprj out=worldprj;
by id;
run;
data work.HRV_gbl;
merge worldprj(in=a)
cd_name;
by id;
if a;
if country = '' then delete;
run;
-Once the global map data set is created, it must be copied into the
SAS installation maps folder.
-Now, log into SAS Human Capital Management as Sysadm and either
change the properties on the shipped version of the analysis or make
a copy and change the properties on it.
-Sysadm has the ability to change the properties on the public versions
of the analysis. Users may edit the properties on their private
versions of the analysis.
-The properties key to defining a global version of the analysis are
included in the Level specific properties:
- Map - Change the map selection to the newly created global
map data set.
- Link Field - The geographic field the map data set and the data
table have in common. If there is only one such field
it will automatically be selected. In this example
the link field is country.
-If a site is interested in a drill to a "country" level from the world
map, a data set will have to be provided which contains the
coordinates for the necessary countries. The data set would be
similar in structure to the HRV_state data set. It would contain a
collection of coordinates for each "state" region within each country
region. Obviously, this data set could be quite large; therefore it
would be best to include only those countries where the site is known
to have data.
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft Windows NT Workstation | 3.0 | | | |
| Microsoft Windows 2000 Professional | 3.0 | | | |
| HP-UX | 3.0 | | | |
| 64-bit Enabled Solaris | 3.0 | | | |
| Solaris | 3.0 | | | |
| 64-bit Enabled HP-UX | 3.0 | | | |
| AIX | 3.0 | | | |
| 64-bit Enabled AIX | 3.0 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Date Modified: | 2002-05-22 14:31:50 |
| Date Created: | 2002-05-09 16:13:10 |