The macro variable's content is inserted as is in the place where you call it, including the brackets. This causes SQL to expect a sub-select.
Remove the brackets in the %LET statement.
... View more
Hi ballardw, thanks for replying. I had thought that was the case too, but when I check there are no missing variables - every row of data has a value for that column. But thanks for the suggestion!
... View more
Your resulting file only contains the column named COLUMN because you told SAS to ONLY keep that column
data WANT (keep=Column);
If you wanted to keep everything, just use:
data WANT;
Art, CEO, Analyst Finder.com
... View more
