topic Re: Can't find $glcan. format in SAS Programming

Can't find $glcan. format

fuhgidabowit — Fri, 26 Jul 2019 14:32:26 GMT

Hi,

I'm trying to convert ISO-alpha-2 codes to GLC-codes in order to use the gmap procedure:

data maps;
set maps;
GLC=put(BOOK_COUNTERPARTYCOUNTRY,$glcan.);

However, I get an error that the format glcan. was not found. Any idea what could be the cause?

Thanks,

Re: Can't find $glcan. format

PaigeMiller — Fri, 26 Jul 2019 14:40:20 GMT

Before you run this code, format $glcan. must be defined in your SAS code. Or it must be in your format library.

Re: Can't find $glcan. format

Kurt_Bremser — Fri, 26 Jul 2019 14:46:08 GMT

Which type is variable BOOK_COUNTERPARTYCOUNTRY? If it is numeric, SAS will automatically look for a numeric format.

Re: Can't find $glcan. format

fuhgidabowit — Fri, 26 Jul 2019 15:19:17 GMT

Hi,

Thanks for your quick responses. I found the solution. I forgot to specify the output statements to use the code:

options fmtsearch=(sashelp.mapfmts);

However, now I run into the next issue that the gmap procedure tells me that my ID variables are of different data types. Here is my code:

data maps;
set maps;
Country_Name=put(BOOK_COUNTERPARTYCOUNTRY,$isoa2lu.);
ID=put(Country_Name,$glcsun.);
run;

proc gmap data=maps map=maps.world;
id id;
choro sum_ctry;
run;

my ID-variable is alphanumeric. What's the matter?

Thanks,

Re: Can't find $glcan. format

PaigeMiller — Fri, 26 Jul 2019 15:21:43 GMT

If Country_Name is alphanumeric, you want to use INPUT instead of PUT.

Re: Can't find $glcan. format

fuhgidabowit — Fri, 26 Jul 2019 15:32:24 GMT

I get the error message only when I use the gmap procedure, so its related to the ID variable, I guess.

Re: Can't find $glcan. format

PaigeMiller — Fri, 26 Jul 2019 15:37:56 GMT

Show us the LOG, not just the error messages but also the code.

Please paste the log into the window that appears when you click on the {i} icon. Do not show us the log any other way.

Re: Can't find $glcan. format

ballardw — Fri, 26 Jul 2019 15:53:00 GMT

@fuhgidabowit wrote:

Hi,

Thanks for your quick responses. I found the solution. I forgot to specify the output statements to use the code:

options fmtsearch=(sashelp.mapfmts);

However, now I run into the next issue that the gmap procedure tells me that my ID variables are of different data types. Here is my code:

data maps;

set maps;

Country_Name=put(BOOK_COUNTERPARTYCOUNTRY,$isoa2lu.);

ID=put(Country_Name,$glcsun.);

run;

proc gmap data=maps map=maps.world;

id id;

choro sum_ctry;

run;

my ID-variable is alphanumeric. What's the matter?

Thanks,

KS

Proc contents results for maps.world:

           Alphabetic List of Variables and Attributes

#    Variable    Type    Len    Label

1    CONT        Num       5    Numeric rep. for Continent
4    DENSITY     Num       5    Levels for Reducing
2    ID          Num       5    GLC: Country ID Number
7    LAT         Num       8    Unprojected Latitude in Radians
8    LONG        Num       8    Unprojected Longitude in Radians
3    SEGMENT     Num       5    Country Segment Number
5    X           Num       8    Projected Longitude: Cylindri
6    Y           Num       8    Projected Latitude: Cylindri

clearly shows that ID is numeric.

The PUT statement that creates ID in your MAPS data set creates a character variable. Hence the mismatch.

perhaps

data maps;
   set maps;
   Country_Name=put(BOOK_COUNTERPARTYCOUNTRY,$isoa2lu.);
   ID=input ( put(Country_Name,$glcsun. -L), 5.);
run;

to create a numeric ID.

Re: Can't find $glcan. format

fuhgidabowit — Mon, 29 Jul 2019 09:19:44 GMT

Thanks,

that seems to work. However there are few issues which I had to correct manually:

- the format of some countries like Bosnia,Russia or Taiwan for some reason is not converted from ALPHA2-Codes to GLC-Codes

- Hong-Kong does not exist in the SAS-Names list as an own country ?

Thanks,

Re: Can't find $glcan. format

ballardw — Wed, 31 Jul 2019 16:19:02 GMT

@fuhgidabowit wrote:

Thanks,

that seems to work. However there are few issues which I had to correct manually:

- the format of some countries like Bosnia,Russia or Taiwan for some reason is not converted from ALPHA2-Codes to GLC-Codes

- Hong-Kong does not exist in the SAS-Names list as an own country ?

Thanks,

KS

Check the data sets actual values and there are some "political" issues involved that you may need to address. The PRC claims that Taiwan is not a separate country but part of China so some folks take steps not to aggravate China, Or may have a different name used than Taiwan. Note that the SAS Maps.Names set has Taiwan in "Overseas Territories, Dependent Areas, Disputed Territories". Similarly Bosnia and Russia may be listed under other names dependent on source.

And the status of Hong Kong is also a tad ambiguous as to "country" status.