How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

There's your SQL. If you need to run a bunch of queries / actions, you can either save them in code or save them as Access queries. You can then link them into a macro or call them directly from code.

See the SAS Guide to Macro Processing for complete documentation on the SAS COUNTM macro. Input Table data survey; input id $ diet $ exer $ hours xwk educ; datalines; 1001 yes yes 1 3 1 1002 no yes 1 ...