1

if, in proc sql in SAS I create a table and write:

<<
proc sql;

create table work.mytabbi as

select c.*
 ,o.dldl
 ,o.dldl;

quit;
>>

what does "c.*" mean in this program?

Thank you in advance!

Paul Maxwell
  • 33,002
  • 3
  • 32
  • 51
Anton Amirkhanov
  • 21
  • 1
  • 2

1 Answers1

2

c is the alias for a table used in the join and .* means all columns of that table. Your query selects all columns of table c and other columns from table o

Hesam Eivazy
  • 61
  • 5