a month ago - last edited a month ago
is the same as
specifying all the variables in the select statement
basically as short cut
select Name, Sex, Age ,Height ,Weight
to notice the result
a month ago
Mostly because programmers are lazy and if there's a shorter way its much easier.
Please note that I've rewritten your subject line to be more descriptive. This will help anyone else looking for the same answer in the future.
The SAS SQL documentation is here:
And has plenty of examples that you can use. Your question would be covered here:
represents all columns in the tables or views that are listed in the FROM clause.
4 weeks ago
whenever you use * in the select clause of sql, it always means selecting all columns. In the contradictory you can also select particular columns.
Select * from table will select all coulmns
select col1,c0l2 from table
Need further help from the community? Please ask a new question.