So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

SELECT options refine results As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. These options ...

The value is returned through the macro variable SQLRC (a short form for SQL return code). For example, if a SELECT statement is valid, the macro variable SQLRC returns a value of 0. See Using Macro ...

PROC SQL allows you to specify the ORDER BY clause in the CREATE ... The USING clause must be the last clause in the SELECT statement. Multiple LIBNAME statements can be specified, separated by commas ...