 |
PING
0.9
Statistical data handling and processing in production environment
|
|
PING
0.9
Statistical data handling and processing in production environment
|
Test dataset #0.
%_dstest0; %_dstest0(lib=, _ds_=, verb=no, force=no);
_dstest0 is an empty table.
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the name (library+table) of the dataset _dstest0.
In practice, it runs:
DATA _dstest0; STOP; RUN;
To create dataset #0 in the WORKing directory and print it, simply launch:
%_dstest0; %ds_print(_dstest0);
Test dataset #1.
%_dstest1; %_dstest1(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest1:
| a |
|---|
| . |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest1.
In practice, it runs:
DATA _dstest1;
a=.;
run;
To create dataset #1 in the WORKing directory and print it, simply launch:
%_dstest1; %ds_print(_dstest1);
Test dataset #2.
%_dstest2; %_dstest2(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest2:
| a |
|---|
| 1 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest2.
In practice, it runs:
DATA _dstest2;
a=1;
run;
To create dataset #2 in the WORKing directory and print it, simply launch:
%_dstest2; %ds_print(_dstest2);
Test dataset #5.
The following table is stored in _dstest5:
| f | e | d | c | b | a |
|---|---|---|---|---|---|
| . | 1 | 2 | 3 | . | 5 |
Generate dataset #5 for testing.
%_dstest5(lib=, _ds_=, verb=no, force=no);
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest5.
To create dataset #5 in the WORKing directory and print it, simply launch:
%_dstest5; %ds_print(_dstest5);
Test dataset #6.
%_dstest6; %_dstest6(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest6:
| a | b | c | d | e | f | g | h |
|---|---|---|---|---|---|---|---|
| . | 1 | 2 | 3 | . | 5 | 6 | . |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest6 storing the following table:
To create dataset #6 in the WORKing directory and print it, simply launch:
%_dstest6; %ds_print(_dstest6);
Test dataset #20.
%_dstest20; %_dstest20(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest20:
| breakdown | variable | start | end | fmt1_dummy | fmt2_dummy | fmt3_dummy | fmt4_dummy |
|---|---|---|---|---|---|---|---|
| label1 | DUMMY | 1 | 5 | 1 | 0 | 1 | 0 |
| label2 | DUMMY | 1 | 3 | 1 | 1 | 0 | 0 |
| label2 | DUMMY | 5 | 5 | 1 | 1 | 0 | 0 |
| label2 | DUMMY | 8 | 10 | 1 | 1 | 0 | 0 |
| label2 | DUMMY | 12 | 12 | 1 | 1 | 0 | 0 |
| label3 | DUMMY | 1 | 10 | 0 | 1 | 1 | 0 |
| label3 | DUMMY | 20 | HIGH | 0 | 1 | 1 | 0 |
| label4 | DUMMY | 10 | 20 | 0 | 0 | 0 | 1 |
| label5 | DUMMY | 10 | 12 | 0 | 1 | 1 | 0 |
| label5 | DUMMY | 15 | 17 | 0 | 1 | 1 | 0 |
| label5 | DUMMY | 19 | 20 | 0 | 1 | 1 | 0 |
| label5 | DUMMY | 30 | HIGH | 0 | 1 | 1 | 0 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table).
To create dataset #20 in the WORKing directory and print it, simply launch:
%_dstest20; %ds_print(_dstest20);
Test dataset #25.
%_dstest25; %_dstest25(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest25:
| geo | value | time | unrel | unit |
|---|---|---|---|---|
| BE | 1 | 2014 | 1 | EUR |
| BE | 2 | 2013 | 2 | EUR |
| BE | 3 | 2012 | 0 | EUR |
| AT | 1 | 2013 | 1 | EUR |
| AT | 2 | 2012 | 0 | EUR |
| AT | 3 | 2011 | 2 | EUR |
| AT | 4 | 2010 | 0 | EUR |
| BG | 1 | 2013 | 0 | EUR |
| BG | 2 | 2012 | 2 | EUR |
| LU | 1 | 2014 | 0 | EUR |
| LU | 2 | 2013 | 0 | EUR |
| LU | 3 | 2012 | 1 | EUR |
| FR | 1 | 2014 | 2 | EUR |
| FR | 2 | 2013 | 0 | EUR |
| FR | 3 | 2012 | 1 | EUR |
| IT | 1 | 2013 | 2 | EUR |
| IT | 2 | 2012 | 1 | EUR |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest25.
To create dataset #25 in the WORKing directory and print it, simply launch:
%_dstest25; %ds_print(_dstest25);
Test dataset #26.
%_dstest26; %_dstest26(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest26:
| geo | time |
|---|---|
| BE | 2014 |
| AT | 2013 |
| BG | 2012 |
| LU | 2014 |
| IT | 2013 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest26.
To create dataset #26 in the WORKing directory and print it, simply launch:
%_dstest26; %ds_print(_dstest26);
Test dataset #27.
%_dstest27; %_dstest27(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest27:
| geo | time |
|---|---|
| BE | 2014 |
| AT | 2013 |
| BG | 2012 |
| LU | 2014 |
| FR | 2013 |
| IT | 2013 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest27.
To create dataset #27 in the WORKing directory and print it, simply launch:
%_dstest27; %ds_print(_dstest27);
Test dataset #28.
%_dstest28; %_dstest28(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest28:
| geo | value |
|---|---|
| AT | 1 |
| '' | . |
| BG | 2 |
| '' | 3 |
| FR | . |
| IT | 4 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest28.
To create dataset #28 in the WORKing directory and print it, simply launch:
%_dstest28; %ds_print(_dstest28);
Test dataset #29.
%_dstest29; %_dstest29(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest29:
| geo |
|---|
| BE |
| AT |
| BG |
| '' |
| FR |
| IT |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest29.
To create dataset #29 in the WORKing directory and print it, simply launch:
%_dstest29; %ds_print(_dstest29);
Test dataset #30.
%_dstest30; %_dstest30(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest30:
| geo | value |
|---|---|
| BE | 0 |
| AT | 0.1 |
| BG | 0.2 |
| '' | 0.3 |
| FR | 0.4 |
| IT | 0.5 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest30.
To create dataset #30 in the WORKing directory and print it, simply launch:
%_dstest30; %ds_print(_dstest30);
Test dataset #31.
%_dstest31; %_dstest31(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest31:
| geo | value | unit |
|---|---|---|
| BE | 0 | EUR |
| AT | 0.1 | EUR |
| BG | 0.2 | NAC |
| LU | 0.3 | EUR |
| FR | 0.4 | NAC |
| IT | 0.5 | EUR |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest31.
To create dataset #31 in the WORKing directory and print it, simply launch:
%_dstest31; %ds_print(_dstest31);
Test dataset #32.
%_dstest32; %_dstest32(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest32:
| geo | value |
|---|---|
| BE | 0 |
| AT | 0.1 |
| BG | 0.2 |
| LU | 0.3 |
| FR | 0.4 |
| IT | 0.5 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest32.
To create dataset #32 in the WORKing directory and print it, simply launch:
%_dstest32; %ds_print(_dstest32);
Test dataset #33.
%_dstest33; %_dstest33(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest33:
| geo | value |
|---|---|
| BE | 1 |
| AT | . |
| BG | 2 |
| LU | 3 |
| FR | . |
| IT | 4 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest33.
To create dataset #33 in the WORKing directory and print it, simply launch:
%_dstest33; %ds_print(_dstest33);
Test dataset #34.
%_dstest34; %_dstest34(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest34:
| geo | year | value |
|---|---|---|
| EU27 | 2006 | 1 |
| EU25 | 2004 | 2 |
| EA13 | 2001 | 3 |
| EU27 | 2007 | 4 |
| EU15 | 2004 | 5 |
| EA12 | 2007 | 6 |
| EA12 | 2002 | 7 |
| EU15 | 2015 | 8 |
| NMS12 | 2015 | 9 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest34.
To create dataset #34 in the WORKing directory and print it, simply launch:
%_dstest34; %ds_print(_dstest34);
Test dataset #35.
%_dstest35; %_dstest35(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest35:
| geo | time | EQ_INC20 | RB050a |
|---|---|---|---|
| BE | 2009 | 10 | 10 |
| BE | 2010 | 50 | 10 |
| BE | 2011 | 60 | 10 |
| BE | 2012 | 20 | 20 |
| BE | 2013 | 10 | 20 |
| BE | 2014 | 30 | 20 |
| BE | 2015 | 40 | 20 |
| IT | 2009 | 10 | 10 |
| IT | 2010 | 50 | 10 |
| IT | 2011 | 50 | 10 |
| IT | 2012 | 30 | 20 |
| IT | 2013 | 30 | 20 |
| IT | 2014 | 20 | 20 |
| IT | 2015 | 50 | 20 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) set for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest35.
To create dataset #35 in the WORKing directory and print it, simply launch:
%_dstest35; %ds_print(_dstest35);
Test dataset #36.
%_dstest36; %_dstest36(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest36:
| geo | time | value |
|---|---|---|
| EU27 | 2006 | 1 |
| EU25 | 2004 | 2 |
| EA13 | 2001 | 3 |
| EU27 | 2007 | 4 |
| EU15 | 2004 | 5 |
| EA12 | 2007 | 6 |
| EA12 | 2002 | 7 |
| GR | 2005 | 8 |
| EL | 2003 | 9 |
| GR02 | 2003 | 10 |
| EU15 | 2015 | 11 |
| NMS12 | 2015 | 12 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest36.
To create dataset #36 in the WORKing directory and print it, simply launch:
%_dstest36; %ds_print(_dstest36);
Test dataset #1000.
%_dstest1000; %_dstest1000(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest1000:
| i |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| ... |
| 999 |
| 1000 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest1000.
To create dataset #1000 in the WORKing directory and print it, simply launch:
%_dstest1000; %ds_print(_dstest1000);
Test dataset #1001.
%_dstest1001; %_dstest1001(lib=, _ds_=, verb=no, force=no);
The following table is stored in _dstest1001:
| i | strata |
|---|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| ... | ... |
| 100 | 1 |
| 101 | 2 |
| 102 | 2 |
| ... | ... |
| 200 | 2 |
| 201 | 3 |
| 202 | 3 |
| ... | ... |
| 900 | 9 |
| 901 | 10 |
| 902 | 10 |
| ... | ... |
| 999 | 10 |
| 1000 | 10 |
lib : (option) output library; default: lib is set to WORK;verb : (option) boolean flag (yes/no) for verbose mode; default: no;force : (option) boolean flag (yes/no) set to force the overwritting of the test dataset whenever it already exists; default: no._ds_ : (option) the full name (library+table) of the dataset _dstest1000.
To create dataset #1001 in the WORKing directory and print it, simply launch:
%_dstest1001; %ds_print(_dstest1001);
1.8.13