MEMORIZE USING ACRONYMS/FIGURES

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