Solved: proc sql output to a dataset - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

proc sql output to a dataset

Posted 09-03-2012 04:35 PM (37416 views)

Hi,

I'm new to SAS. Is there a way to output a PROC SQL query to a SAS dataset rather than a report?

1 ACCEPTED SOLUTION

Accepted Solutions

Opal | Level 21

Opal | Level 21

Re: proc sql output to a dataset

Posted 09-03-2012 05:42 PM (37312 views) | In reply to andreww

Yes, of course. For example :

proc SQL;

create table myTable as

select * from SASHELP.CLASS;

quit;

PG

PG

View solution in original post

2 REPLIES 2

Opal | Level 21

Opal | Level 21

Re: proc sql output to a dataset

Posted 09-03-2012 05:42 PM (37313 views) | In reply to andreww

Yes, of course. For example :

proc SQL;

create table myTable as

select * from SASHELP.CLASS;

quit;

PG

PG

Calcite | Level 5

Calcite | Level 5

Re: proc sql output to a dataset

Posted 09-04-2012 12:15 PM (37312 views) | In reply to andreww

Thank you very much PG!