I have used the following code and it has actually completed what i wanted to achieve. Thanks everyone for your help PROC SQL;
CREATE TABLE Work.Test AS
SELECT /* INV_NUMBER */
(INPUT(t1.INV_NUMBER, best32.))format=best32. informat=best32. LENGTH=8 LABEL="INV_NUMBER" AS INV_NUMBER,
/* INV_BILLING_PERIOD_YEAR */
(INPUT(t1.INV_BILLING_PERIOD_YEAR, best32.)) format=best32. informat=best32. LENGTH=8 LABEL="INV_BILLING_PERIOD_YEAR" AS
INV_BILLING_PERIOD_YEAR,
/* INV_BILLING_PERIOD_MONTH */
(INPUT(t1.INV_BILLING_PERIOD_MONTH, best32.)) format=best32. informat=best32. LENGTH=8 LABEL="INV_BILLING_PERIOD_MONTH" AS
INV_BILLING_PERIOD_MONTH,
/* NMR_METER_POINT_REFERENCE */
(INPUT(t1.NMR_METER_POINT_REFERENCE, best32.)) format=best32. informat=best32. LENGTH=8 LABEL="NMR_METER_POINT_REFERENCE" AS
NMR_METER_POINT_REFERENCE,
/* RCH_RECONCILIATION_QTY */
(INPUT(t1.RCH_RECONCILIATION_QTY, Best32.)) format=best32. informat=best32. LENGTH=8 LABEL="RCH_RECONCILIATION_QTY" AS
RCH_RECONCILIATION_QTY,
/* LDZ_IDENTIFIER */
(t1.LDZ_IDENTIFIER) FORMAT=$CHAR15. informat=$CHAR15. LENGTH=15 LABEL="LDZ_IDENTIFIER" AS LDZ_IDENTIFIER,
/* RVE_START_DATE */
(t1.RVE_START_DATE) FORMAT=YYMMDD10. informat=YYMMDD10. LENGTH=8 LABEL="RVE_START_DATE" AS RVE_START_DATE,
/* RVE_END_DATE */
(t1.RVE_END_DATE) FORMAT=YYMMDD10. informat=YYMMDD10. LENGTH=8 LABEL="RVE_END_DATE" AS RVE_END_DATE,
/* NMR_END_METER_READ_DATE */
(t1.NMR_END_METER_READ_DATE) FORMAT=YYMMDD10. informat=YYMMDD10. LENGTH=8 LABEL="NMR_END_METER_READ_DATE" AS
NMR_END_METER_READ_DATE,
/* NMR_START_METER_READ_DATE */
(t1.NMR_START_METER_READ_DATE) FORMAT=YYMMDD10. informat=YYMMDD10. LENGTH=8 LABEL="NMR_START_METER_READ_DATE" AS
NMR_START_METER_READ_DATE
FROM Work.Test1;
QUIT;
... View more