how to display in the output window?

[tianerhu]

libname certadv 'C:\SAS data and program\data\data set used in OG of SAS adv\certadv';
proc sql;
  create table work.lab1 as
    select *
	from certadv.lab3
	where name in (select name from certadv.lab12);
quit;

above is my program. How to display the result of my program in the output window?

[SASKiwi]

If you just want to see the data rows being selected in the Output window just remove the CREATE TABLE part of your query:

libname certadv 'C:\SAS data and program\data\data set used in OG of SAS adv\certadv';
proc sql;
  /* create table work.lab1 as */
    select *
	from certadv.lab3
	where name in (select name from certadv.lab12);
quit;

[tianerhu]

Thanks.

[Tom]

Your SQL code is creating a dataset.

To display a dataset use PROC PRINT.

proc print data=lab1;
run;

[tianerhu]

Thank you for your help.