topic Selection of variables in a PROC SQL in SAS Programming

Selection of variables in a PROC SQL

sasuser_8 — Wed, 18 Oct 2023 20:37:39 GMT

From this example,

PROC SQL;

SELECT
CODE_VAR1,
CODE_VAR2,
CODE_VAR3,
CODE_VAR4,
CODE_VAR5,
VAR1,
VAR2,
VAR3,
VAR4,
VAR5

FROM SALE;

QUIT;
RUN;

I would like to know if it is possible not to repeat the name of the variables, as we can do with a KEEP in a DATA step: CODE_VAR1-CODE_VAR15 VAR1-VAR5 ?

Re: Selection of variables in a PROC SQL

A_Kh — Wed, 18 Oct 2023 20:48:39 GMT

Hi,
I think this paper can answer your question.

Re: Selection of variables in a PROC SQL

SASKiwi — Wed, 18 Oct 2023 20:53:23 GMT

Just add a KEEP = option to your SALE dataset and change your SELECT to SELECT *.

Re: Selection of variables in a PROC SQL

Reeza — Wed, 18 Oct 2023 20:56:06 GMT

See my answer here under the FEEDBACK option.

https://communities.sas.com/t5/SAS-Programming/Feedback-Option-in-Proc-SQL/td-p/419909

Re: Selection of variables in a PROC SQL

PaigeMiller — Wed, 18 Oct 2023 21:00:21 GMT

Why would you want to use SQL to select specific columns from an existing data set and do nothing else in SQL?

If you are planning to run the data through another PROC after SQL.

proc means data=sale(keep=code_var1-code_var5 var1-var5);
/* More PROC MEANS code */
run;

As always, context is important, the best approach depends on context, and you haven't given us the slightest hint about why you are doing this.