PROC SQL - CREATE NEW TABLE DOES NOT WORK

[lyth_abb]

Hi - I'm trying to create new table with proc sql as below (I take it from sas guideline:

https://documentation.sas.com/doc/ja/vdmmlcdc/8.1/sqlproc/n1ncn0pznd8wrln1tnp3xdxjz9xz.htm )

The query run successfully without no error, but when I refresh the libname 'proclib' created in the code, it keeps refreshing and hasn't stopped for 3-4 hours. Can someone please explain me what's wrong here? Many thanks

Code:

libname proclib 'SAS-library';
proc sql;
   create table proclib.paylist
       (IdNum char(4),
        Gender char(1),
        Jobcode char(3),
        Salary num,
        Birth num informat=date7.
                  format=date7.,
        Hired num informat=date7.
                  format=date7.);
insert into proclib.paylist
    values('1639','F','TA1',42260,'26JUN70'd,'28JAN91'd)
    values('1065','M','ME3',38090,'26JAN54'd,'07JAN92'd)
    values('1400','M','ME1',29769.'05NOV67'd,'16OCT90'd)
values('1561','M',null,36514,'30NOV63'd,'07OCT87'd)
    values('1221','F','FA3',.,'22SEP63'd,'04OCT94'd);
title 'Proclib.Paylist Table';
select *
   from proclib.paylist;
proc printto; run;

The 'proclib' keeps refreshing:

[Patrick · Accepted solution]

Your code works "as is" in my SAS9.4 M7 environment under RHEL. 

Always finish a Proc SQL with a QUIT  - may-be that's the issue in your environment.

Here what I've run without any issues.

libname proclib "%sysfunc(pathname(work))";

proc sql;
  create table proclib.paylist
    (IdNum char(4),
    Gender char(1),
    Jobcode char(3),
    Salary num,
    Birth num informat=date7.
    format=date7.,
    Hired num informat=date7.
    format=date7.);
  insert into proclib.paylist
    values('1639','F','TA1',42260,'26JUN70'd,'28JAN91'd)
    values('1065','M','ME3',38090,'26JAN54'd,'07JAN92'd)
    values('1400','M','ME1',29769.'05NOV67'd,'16OCT90'd)
    values('1561','M',null,36514,'30NOV63'd,'07OCT87'd)
    values('1221','F','FA3',.,'22SEP63'd,'04OCT94'd);
  title 'Proclib.Paylist Table';
  select *
    from proclib.paylist;
quit;

[lyth_abb]

Oh many thanks for your quick reply, it works perfectly!!