Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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