Several Screen Control Language (SCL) methods are available that enable you to use the SQL Query Window in SAS/AF applications. Refer to SAS Component Language: Reference for more information on SCL ...

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 ...