CREATE NULL SQL

/*create null table*/
proc sql;
create table employ (eid num,des char(10),salary num);
quit;
/*insert values*/
proc sql;
create table employ (eid num,des char(10),salary num);
insert into employ
values(101,'tester',3400)
values(102,'analyst',4000);
insert into employ
set eid=103,des='programer',salary=5000
set eid=104,des='programer',salary=6000;
quit;
proc sql;
select*from employ;
quit;
/*nonstandard data*/
proc sql;
create table medi(pid num,sdate num,stime num,edime num);
insert into medi
values(101,'13jan2005'd,'14:23:23't,'16mar2003:10:24:34'dt);
quit;
proc sql;
select pid,
sdate format=ddmmyyd10.,
stime format=timeampm12.,
edime format=datetime18. from medi;
quit;