Reading data from into SAS

The code below lets you read data from into SAS. is an api provided by Statistics Denmark (Danmarks Statistik) for reading their public data.

The code below gets it’s data from the table FOLK1. You can get a list of avaliable tables from this url – The code also sets some filters on the tables, some of the information used in this post comes from here.

filename dst
                        proxy='http://<your proxy:and port>/'
                        puser="<your userid to proxy>"
                        ppass="<your password to proxy>";

data test;
        infile dst dlm=';' encoding="utf-8";
        format Quarter Sex Municipality Age $50.;
        input Quarter $ Sex $ Municipality $ Age $ Count;