DATA Step, Macro, Functions and more

proc sql question

Reply
Super Contributor
Posts: 316

proc sql question

Dear,

 

Some body had written a proc sql code in a macro

 

porc sql;

select distinct
obs.*,

What is "obs.*". I know '*' means all. Does it mean all observations. Please suggest any example i can read. Thank you.

 

Super User
Posts: 3,870

Re: proc sql question

[ Edited ]
Posted in reply to knveraraju91

Where is the rest of your query? "obs" is a short way of identifying a table if your query looks like this:

 

proc sql;
  create table want as
  select obs.*
  from MyLongTableName as obs
  ;
quit;

So the query means select all columns from the table referenced by "obs". BTW "obs" has no special meaning. You can use any character or characters to reference the table: ABC, XYZ etc.

Esteemed Advisor
Posts: 5,487

Re: proc sql question

Posted in reply to knveraraju91

As @SASKiwi said, obs could be a table alias name or it could be the table name itself, as in the query:

 

proc sql;
select 
    obs.*,
    have.age
from obs, have
where obs.id=have.id;
quit;
PG
Ask a Question
Discussion stats
  • 2 replies
  • 115 views
  • 2 likes
  • 3 in conversation