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.
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.