Create table like

aloou — Mon, 28 Mar 2022 09:45:46 GMT

Hello,

i would like to create a table using proc fedsql but i can not find how.

same like this procedure

proc sql;

create table casuser.x like biblio.y;

quit;

thank you

Re: Create table like

SASJedi — Sun, 03 Apr 2022 19:42:52 GMT

The code you proposed would create a new table but without any rows. Consider:

proc sql;
create table work.cars like sashelp.cars;
quit;

A peek at the WORK library will reveal a table named cars, but there are no data rows in the table - just the table structure.

To make a COPY of the table, including some of the data from the original table:

proc sql;
create table cars as
select * from sashelp.cars where Make='Audi';
quit;

Now a peek at the WORK library will reveal a table named cars with all of the columns from the original table, but only rows where the Make is Audi.

topic Re: Create table like in SAS Programming

Create table like

Re: Create table like