selecting Variables

[sathya66]

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;

[novinosrin]

Do you mean a shorter way?

data test(keep=COL1-COL6);

set have;

run;

[rajeshalwayswel]

data test(keep=COL:);

set have;

run;

[Reeza]

Variable Lists

data Test (keep = col1-col6);

data Test (keep = col:);

http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p0wphcpsfgx6o7n1sjtqzizp1n39.htm&docsetVer...

---

@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;

---

[sathya66]

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;

[sathya66]

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

[Reeza]

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;

---

[novinosrin · Accepted solution]

when using lists you need OF keyword to concat

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