Type : CREATION_INTERNE
Das Skript generiert eine leere Tabellenstruktur (DDL) über eine SQL-CREATE-TABLE-Anweisung. Es werden keine externen Daten gelesen.
| 1 | %macro _createTestDataSCN (libref=target); |
| 2 | PROC SQL NOPRINT; |
| 3 | CREATE TABLE &libref..scn(COMPRESS=CHAR) |
| 4 | ( /* test scenario */ |
| 5 | scn_id INT FORMAT=z3. /* number of scenario */ |
| 6 | ,scn_path CHAR(1000) /* path to program file */ |
| 7 | ,scn_desc CHAR(1000) /* description of program (brief tag in comment header) */ |
| 8 | ,scn_start INT FORMAT=datetime21.2 /* starting date and time of the last run */ |
| 9 | ,scn_end INT FORMAT=datetime21.2 /* ending date and time of the last run */ |
| 10 | ,scn_changed INT FORMAT=datetime21.2 /* modification date and time of the last run */ |
| 11 | ,scn_rc INT /* return code of SAS session of last run */ |
| 12 | ,scn_errorcount INT /* number of detected errors in the scenario log */ |
| 13 | ,scn_warningcount INT /* number of detected warnings in the scenario log */ |
| 14 | ,scn_res INT /* overall test result of last run: 0 .. OK, 1 .. not OK, 2 .. manual */ |
| 15 | ); |
| 16 | QUIT; |
| 17 | %mend _createTestDataSCN; |