Information Technology Reference
In-Depth Information
data
nis.code5;
set nis.died;
DX=substr(DX5,
1
,
3
);
data
nis.code6;
set nis.died;
DX=substr(DX6,
1
,
3
);
data
nis.code7;
set nis.died;
DX=substr(DX7,
1
,
3
);
data
nis.code8;
set nis.died;
DX=substr(DX8,
1
,
3
);
data
nis.code9;
set nis.died;
DX=substr(DX9,
1
,
3
);
data
nis.code10;
set nis.died;
DX=substr(DX10,
1
,
3
);
data
nis.code11;
set nis.died;
DX=substr(DX11,
1
,
3
);
data
nis.code12;
set nis.died;
DX=substr(DX12,
1
,
3
);
data
nis.code13;
set nis.died;
DX=substr(DX13,
1
,
3
);
data
nis.code14;
set nis.died;
DX=substr(DX14,
1
,
3
);
data
nis.code15;
set nis.died;
DX=substr(DX15,
1
,
3
);
run
;
This next part of the code creates a new dataset for each column of diagnosis code. In addition, it
relabels the column to be consistent across each of these datasets. The purpose is so that the columns
can be stacked (ie, easily appended).
PROC SQL;
CREATE TABLE SASUSER.APPEND_TABLE_0009 AS
SELECT * FROM NIS.CODE1
OUTER UNION CORR
SELECT * FROM NIS.CODE10
Search WWH ::
Custom Search