Coding with the SQL Procedure

Page 1 out of 2 Pages

• Is it possible to generate a shorthand SELECT Clause in PROC SQL with every column 'except' those listed?
  (8729 views)
• Is there a facility in PROC SQL to repeat a value down a BY-GROUP in a column, similar to the RETAIN Statement in DATA Step?
  (5459 views)
• How can I create a row count variable in DATA step and PROC SQL?
  (16665 views)
• Can I stop the "WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem" message when creating a table in PROC SQL?
  (16586 views)
• How can I build sample datasets to perform fuzzy matches?
  (17286 views)
• Can I exclude certain columns from the select * clause?
  (4510 views)
• How can I compare two datasets with similarly-named variables by joining them horizontally?
  (7867 views)
• Is it possible to perform a merge where key values are split across two columns?
  (4501 views)
• Is there an equivalent for the COALESCE function to find the first non-missing value in a column, rather than a row?
  (4753 views)
• Can I use the FIRSTOBS= and OBS= options in PROC SQL?
  (8529 views)

one category up