topic how to display in the output window? in SAS Programming

how to display in the output window?

tianerhu — Thu, 07 Jul 2022 01:24:43 GMT

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?

Re: how to display in the output window?

SASKiwi — Thu, 07 Jul 2022 02:14:03 GMT

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;

Re: how to display in the output window?

Tom — Thu, 07 Jul 2022 03:00:40 GMT

Your SQL code is creating a dataset.

To display a dataset use PROC PRINT.

proc print data=lab1;
run;

Re: how to display in the output window?

tianerhu — Thu, 07 Jul 2022 03:05:23 GMT

Thank you for your help.

Re: how to display in the output window?

tianerhu — Thu, 07 Jul 2022 03:06:07 GMT

Thanks.