pxmake
multilingual px files with R, 2024

Hard Facts to set stage

Worlds largest island & NOT the smallest statistical office

15 staff, masters degree & no specialized programmers, established under a Statistical Act in 1989

And so was our technology base
Local network connected PCs running SAS locally on DOS

5 years later came Windows, internet and in 2012 moved to a server based sas-language compiler (WPS/Altair)

Our workload today is; an iceberg, made of 35 years sas-programming

our toolbox

MS Office
sas
web site technology

our toolbox need a makeover

legacy tools

MS Office
sas
web site technology

To renew ourselves we have added R to our toolbox

Altair has a PROC R, to include R-language in sas-programs
& supports the parquet file format
- in R the arrow package reads and writes parquet files too

With this we are ready to dream of a better tomorrow, where all 15 staff can help and support each other - in our own pace - not sitting on a melting iceberg

The Statistical Factory Dream

Design goal: Keep It Simple & Smart

Aims to be our statistical highway bringing raw data from administrative registers to end users as high quality tables, in our favorite dissemination platform Pxweb

Standardizing production/operation, yet being flexible

We need company tools to support common tasks

General public landing page

statgl - to extract tables from our px-file based Statbank, and do presentations
Sustainable 2030
Did you ever wonder?
UN Demographic Yearbook

pxmake - multilingual px file handling in R
pxweb logfiles

statgs - for internal use only

In use

Population projections

Population projections