If you don’t use PROC SQL that often then you might tend to forget some of the commands, try to create figure or some acronym you can remember to associate with this kind of information.
FIGURE 1: Statements used in PROC SQL to create/delete table or to manipulate table rows/columns.
| CREATE TABLE : To create a table DROP TABLE: To delete a table | | |||
| | | ALTER…DROP: To delete a column | ALTER …ADD: To add a column | ALTER … MODIFY: To update a column |
| DELETE FROM: To delete a row | | | | |
| INSERT INTO: To add a row | | | | |
| UPDATE ... SET: To update a row | | | | |
FIGURE 2: Sequence in which clauses appear in a SELECT statement of PROC SQL.
| So | Few | Workers | Get | Home | On-time |
| SELECT | FROM | WHERE | GROUP BY | HAVING | ORDER BY |
Base certification does not ask question on PROC SQL but I got what you are trying to say, is to make some kind of acronym or figure to remember certain things. Thanks for the tip.
ReplyDelete