05-09-2018 09:09 PM
Some body had written a proc sql code in a macro
What is "obs.*". I know '*' means all. Does it mean all observations. Please suggest any example i can read. Thank you.
05-09-2018 09:17 PM - edited 05-09-2018 09:20 PM
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.
05-10-2018 01:16 AM
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;