topic Re: selecting Variables in SAS Programming

selecting Variables

sathya66 — Tue, 17 Apr 2018 16:41:01 GMT

Hi All,

I have columns 1-n in have table ( like COL1 COL2 COL3 COL3 COL4 COL5 COL6). I want to write like this (keep=COL(1-n). Instead of writing (keep=COL1 COL2 COL3 COL3 COL4 COL5 COL6).

because I want to select 3 columns in 1 table and 10 columns in another table.

data test(keep=COL1 COL2 COL3 COL3 COL4 COL5 COL6);

set have;

run;

Re: selecting Variables

novinosrin — Tue, 17 Apr 2018 16:44:08 GMT

Do you mean a shorter way?

data test(keep=COL1-COL6);

set have;

run;

Re: selecting Variables

rajeshalwayswel — Tue, 17 Apr 2018 16:45:17 GMT

data test(keep=COL:);

set have;

run;

Re: selecting Variables

Reeza — Tue, 17 Apr 2018 16:45:47 GMT

Variable Lists

data Test (keep = col1-col6);

data Test (keep = col:);

http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p0wphcpsfgx6o7n1sjtqzizp1n39.htm&docsetVersion=9.4&locale=en

@sathya66 wrote:

Hi All,

I have columns 1-n in have table ( like COL1 COL2 COL3 COL3 COL4 COL5 COL6). I want to write like this (keep=COL(1-n). Instead of writing (keep=COL1 COL2 COL3 COL3 COL4 COL5 COL6).

because I want to select 3 columns in 1 table and 10 columns in another table.

data test(keep=COL1 COL2 COL3 COL3 COL4 COL5 COL6);

set have;

run;

Re: selecting Variables

sathya66 — Tue, 17 Apr 2018 16:51:04 GMT

Thanks,
data Test (keep = col:); this way
and also I want to concatenate the variables in a single variable .

data cc(keep=COL:);
set x;
a=cat(COL:); /*error */
run;

Re: selecting Variables

sathya66 — Tue, 17 Apr 2018 16:52:46 GMT

data cc(keep=COL:);
set x;
a=cat(COL:); /*error */
run;

Re: selecting Variables

Reeza — Tue, 17 Apr 2018 16:53:21 GMT

Please paste your code into a code box, otherwise emojis invade.

Check the link I included in my answer for examples to your new question.

@sathya66 wrote:
Thanks,
data Test (keep = col:); this way
and also I want to concatenate the variables in a single variable .

data cc(keep=COL:);
set x;
a=cat(COL:); /*error */
run;

Re: selecting Variables

novinosrin — Tue, 17 Apr 2018 16:53:29 GMT

when using lists you need OF keyword to concat

data cc(keep=COl: )
set x;
a=cat(of col: )
ru