topic Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes? in SAS Programming

Is there an in-built SAS format to apply iso3166alphatwo for country codes?

kkk9 — Sat, 23 Sep 2023 18:18:56 GMT

Is there an in-built SAS format to apply iso3166alphatwo for country codes?

If so, I would appreciate it if you could provide me an example code.

Thanks!

Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes?

Tom — Sat, 23 Sep 2023 19:13:15 GMT

You can try making one from mapsgfk.world_attr.

data format;
  fmtname='$ISO1366ALPHATWO';
  set mapsgfk.world_attr(keep=ISOALPHA2 isoname);
  where not missing(isoalpha2);
  rename ISOALPHA2=start isoname=label;
run;

proc format cntlin=format /* fmtlib */;
run;

Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes?

kkk9 — Sun, 24 Sep 2023 18:54:20 GMT

Thank you for the reply. I would appreciate it if could explain the code and where "mapsgfk.world_attr" is located.

Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes?

Tom — Sun, 24 Sep 2023 19:07:12 GMT

@kkk9 wrote:

Thank you for the reply. I would appreciate it if could explain the code and where "mapsgfk.world_attr" is located.

MAKSGFK libref is part of SAS install. I am not sure if you have to have licensed SAS/Graph to have it.

The data step creates a dataset in the style needed for defining a format. It creates the minimum required variables of FTMNAME, START and LABEL. The PROC FORMAT step then creates the format as defined by the dataset.

If you do not have the dataset then just copy the code/name pairs off of the internet and make your own code to create the format. either directly in PROC FORMAT syntax. Or by first making a dataset like my code did.

Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes?

SASKiwi — Sun, 24 Sep 2023 19:09:48 GMT

The MAPSGFK data library is provided by SAS as part of the SAS/GRAPH product. It includes datasets for mapping most countries and includes the WORLD_ATTR dataset. It will be available to you automatically if you have SAS/GRAPH installed. Have you tried running @Tom 's program?

Re: Is there an in-built SAS format to apply iso3166alphatwo for country codes?

Patrick — Mon, 25 Sep 2023 03:34:57 GMT

To add to what @Tom and @SASKiwi already shared:

If you have SAS Graph licensed then there is also already a macro library with country formats available. Using Formats for Traditional Map Data Set Variables

Below code demonstrates how to get access to these formats.

options insert=(fmtsearch=sashelp.mapfmts);
data _null_;
  iso=364;
  put iso ison2a.;
run;