The Language of SAS
  • Instant Response
  • Add new FAQ
  • Add question
  • Open questions
  • Sign up
  • Login
  • FAQ Home
  • All categories
  • The Language of SAS
    • Macros
    • PROC SQL
    • DATA Step
    • Procedures
1 user online | 1 Guest and 0 Registered
Advanced search

Questions in PROC SQL

  • FAQs

Coding with the SQL Procedure

Page 1 out of 2 Pages

  • Does PROC SQL support name ranges in summary functions?
    (373 views)
  • Is it possible to generate a shorthand SELECT Clause in PROC SQL with every column 'except' those listed?
    (15680 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?
    (8807 views)
  • How can I create a row count variable in DATA step and PROC SQL?
    (24731 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?
    (31174 views)
  • How can I build sample datasets to perform fuzzy matches?
    (25230 views)
  • Can I exclude certain columns from the select * clause?
    (8194 views)
  • How can I compare two datasets with similarly-named variables by joining them horizontally?
    (14949 views)
  • Is it possible to perform a merge where key values are split across two columns?
    (7726 views)
  • Is there an equivalent for the COALESCE function to find the first non-missing value in a column, rather than a row?
    (9551 views)
17
  • 1
  •   
  • 2
  •   
  • →
  •   
  • ⇥

one category up

Coding with the SQL Procedure

Tags

=* comments compile-time format into keyword order positional quoted retain separated by SOUNDEX SOUNDS LIKE work
  • Sitemap
  • Contact
  • FAQ Glossary