In reply to Stephen Foerster.

HI Stephen, here are the results.

proc cas;
table.columninfo / table="B130082_OP_ORDER" ;
run ; quit ;

Results from table.columnInfo
Column Information for B130082_OP_ORDER in Caslib Public
Column Label Id Type Length Formatted
Length Format Format
Width Format
Decimal
BRANCH_ID 1 char 1 8 $F 0 0
HOSP_DATA_TYPE 2 char 3 8 $F 0 0
HOSP_CNT_TYPE 3 char 1 8 $F 0 0
HOSP_ID_PLAIN 4 char 15 15 0 0
HOSP_ABBR 5 char 30 30 0 0
FEE_YM FEE_YM 6 double 8 11 F 11 0
YR 7 double 8 12 0 0
FUNC_TYPE 8 char 22 15 $F 0 0
ORDER_CODE 9 char 22 22 0 0
TYPE_C 10 char 21 21 0 0
ORDER_QTY ORDER_QTY 11 double 8 27 F 27 2
ORDER_DOT ORDER_DOT 12 double 8 26 F 26 0
ORDER_QTY1 ORDER_QTY 13 double 8 27 F 27 2
ORDER_DOT1 ORDER_DOT 14 double 8 26 F 26 0
CURE_CNAME 15 char 60 60 0 0
ATC5 16 char 27 27 0 0
-----------------------------------------------------------------------------------------------------------------------------------------------------
proc cas;
table.columninfo / table="B130082_OP_ORDER_stg" ;
run ; quit ;
Results from table.columnInfo
Column Information for B130082_OP_ORDER_STG in Caslib Public
Column Label Id Type Length Formatted
Length Format Format
Width Format
Decimal
BRANCH_ID 1 char 1 8 $F 0 0
HOSP_DATA_TYPE 2 char 3 8 $F 0 0
HOSP_CNT_TYPE 3 char 1 8 $F 0 0
HOSP_ID_PLAIN 4 char 15 15 0 0
HOSP_ABBR 5 char 30 30 0 0
FEE_YM FEE_YM 6 double 8 11 F 11 0
YR 7 double 8 12 0 0
FUNC_TYPE 8 char 22 15 $F 0 0
ORDER_CODE 9 char 22 22 0 0
TYPE_C 10 char 21 21 0 0
ORDER_QTY ORDER_QTY 11 double 8 27 F 27 2
ORDER_DOT ORDER_DOT 12 double 8 26 F 26 0
ORDER_QTY1 ORDER_QTY 13 double 8 27 F 27 2
ORDER_DOT1 ORDER_DOT 14 double 8 26 F 26 0
CURE_CNAME 15 char 60 60 0 0
ATC5 16 char 27 27 0 0
------------------------------------------------------------------------------------------------------------------------------------------------------------------

proc cas; table.fetch /
table={name='B130082_OP_ORDER',caslib='public'}
fetchvars={{name='branch_id',format='branch_id_f'},{name='func_type',format='func_type_f'},{name='Hosp_cnt_type',format='Hosp_cnt_type_f'},{name='Hosp_data_type',format='Hosp_data_type_f'}};
format=TRUE;
quit;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc cas; table.fetch /
74 table={name='B130082_OP_ORDER',caslib='public'}
75 fetchvars={{name='branch_id',format='branch_id_f'},{name='func_type',format='func_type_f'},{name='Hosp_cnt_type',format='
75 ! Hosp_cnt_type_f'},{name='Hosp_data_type',format='Hosp_data_type_f'}};
76 format=TRUE;
NOTE: The submitted statements have been canceled.
77 quit;

NOTE: PROCEDURE CAS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

proc cas; table.fetch /
table={name='B130082_OP_ORDER_stg',caslib='public'}
fetchvars={{name='branch_id',format='branch_id_f'},{name='func_type',format='func_type_f'},{name='Hosp_cnt_type',format='Hosp_cnt_type_f'},{name='Hosp_data_type',format='Hosp_data_type_f'}};
format=TRUE;
quit;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc cas; table.fetch /
74 table={name='B130082_OP_ORDER_stg',caslib='public'}
75 fetchvars={{name='branch_id',format='branch_id_f'},{name='func_type',format='func_type_f'},{name='Hosp_cnt_type',format='
75 ! Hosp_cnt_type_f'},{name='Hosp_data_type',format='Hosp_data_type_f'}};
76 format=TRUE;
NOTE: The submitted statements have been canceled.
77 quit;

NOTE: PROCEDURE CAS used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds