insert into stkcd_data
set stkcd='000001', date=2018-11-29, wrt=0.11,riskfrt=0.13
set stkcd='000002', date=2018-11-28;
insert into stkcd_data
values ('000003', '29-11-2018', 0.15, 0.22)
values ('000004', 2018-11-27, 0.11, 0.21)
values ('000005', 2018-11-29, 0.11, .)
values ('000006', 2018-11-25, 0.15, 0.22)
values ('000007', 2018-11-30, 0.20, 0.28)
values ('000008', 2018-11-26, 0.11, 0.42)
values ('000009',2018-11-27, 0.15, 0.22)
values ('000010',' ', 0.11, 0.19);
delete from stkcd_data where date is missing;
quit;