PING
0.9
Statistical data handling and processing in production environment
|
Provide the population of EU countries.
A table named after the value &G_PING_POPULATIONxCOUNTRY
(e.g., META_POPULATIONxCOUNTRY
) shall be defined in the library named after the value &G_PING_LIBCFG
(e.g., LIBCFG
) so as to contain for every country in the EU+EFTA geographic area:
In practice, the table (e.g., what used to be CCWGH60
) looks like this (can change owing to updates):
GEO | Y2003 | Y2004 | Y2005 | Y2006 | Y2007 | Y2008 | Y2009 | Y2010 | Y2011 | Y2012 | Y2013 | Y2014 | Y2015 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BE | 10355844 | 10396421 | 10445852 | 10511382 | 10584534 | 10666866 | 10753080 | 10839905 | 11000638 | 11094850 | 11161642 | 11203992 | 11258434 |
BG | 7845841 | 7745147 | 7688573 | 7629371 | 7572673 | 7518002 | 7467119 | 7421766 | 7369431 | 7327224 | 7284552 | 7245677 | 7202198 |
CZ | 10203269 | 10195347 | 10198855 | 10223577 | 10254233 | 10343422 | 10425783 | 10462088 | 10486731 | 10505445 | 10516125 | 10512419 | 10538275 |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
Consider an input CSV table called A.csv
, with same structure as above, and stored in a directory named B
. In order to create/update the SAS table A
in library C
, as described above, it is then enough to run:
%meta_populationxcountry(cds_zonexyear=A, cfg=B, clib=C);
Note that, by default, the command %meta_populationxcountry;
runs:
%meta_populationxcountry(cds_popxctry=&G_PING_POPULATIONxCOUNTRY, cfg=&G_PING_AGGREGATES/meta, clib=&G_PING_LIBCFG);
Generate the table META_POPULATIONxCOUNTRY
in the WORK
directory:
%meta_populationxcountry(clib=WORK);