proc sql

  1. S

    PROC SQL macro into an ARRAY

    I am trying to create a macro (&varlist) using proc sql ---> then putting the variable into the array item[3]. But I get the error "Too few variables defined for the dimension(s) specified for the array item" What's wrong here? Any help would be greatly appreciated. proc sql noprint...
  2. A

    voiding data set merging problems when by-variable has different lengths.

    When merging 2 tables on a common by-variable you run the risk of having a different length on this (or these) by variable(s). If this is the case, SAS will casually inform you with the following warning: WARNING: Multiple lengths were specified for the BY variable mergevar by input data...
  3. G

    Want to learn Data step vs. Proc SQL, try this free webinar to keep yourself updated

    This free webinar is Presented by Piyush Neupane. Scheduled to happen on Monday, August 22, 2011 - 07.00 to 07.45 P.M PST To register - http://www.corp-corp.com/blog/data-step-proc-sql/?aid=orbacceforum You'll learn: - Subsetting Data - Summarizing Data - Conditional Statements -...
  4. K

    Using Proc SQL within a SAS Macro

    Hello, I am an amateur SAS programmer. I just encountered a problem using the Proc SQL statement within a macro. I am using the Proc SQL to connect to the orcle database and pull out a value from a table. I am posting the code that I have written below. Any help will be greatly appreciated...