SAS Macro for standard SQL query

By kmacdonald ·
I am new to SAS but have a VB background.

Looking to set up a Proc SQL which is fed arrays X, Y and Z (each with a number of elements).

The SQL query would be 'Select X From Y Where X'

I want to be able to call the query and just send the arrays of criteria.

Does anyone know if this is something that can work or have I been banging my head against my desk all day for no reason :). Any help is appreciated.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

You might have more luck

by Dr Dij In reply to SAS Macro for standard SQ ...

on the
tek-tips forums.
They have one specifically for SAS.

Have you tried sas site also?

also, if your company or you have subscription to, 106 of the SAS books and manuals are readable online.

One of them seems to be just this topic:
Chapter 4 - Coding PROC SQL Logic
Bookmark this location
Bookmark this location and attach a Note
Add to Personal Folders
Purchase Hardcopy
PROC SQL: Beyond the Basics Using SAS
by Kirk Paul Lafler
SAS Publishing ? 2004

Related Discussions

Related Forums