In Version 6, the SAS System's SQL procedure enabled you to retrieve and update data from DBMS tables and views. You could read and display DBMS data by specifying a ...
select employee_title as title, avg(employee_years), freq(employee_id) from sql.employee group by title order by title; where SQL is the libref for a remote SAS ...
What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check. Well, if you happen to be using Sql Server you can do that sort of ...