- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-28-2022 05:45 AM
(2069 views)
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
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Check out my Jedi SAS Tricks for SAS Users