topic PROC SQL COLUMN SEQUENCE in SAS Procedures

PROC SQL COLUMN SEQUENCE

JasonNC — Fri, 07 Dec 2012 03:45:06 GMT

Hi,

If we have columns which are in sequence then how can we use it in select statement

For example

If i have id1-id24 then in proc sql how to use the sql statement

proc sql noprint;

create table test as

select id1-id24

from dummy;

quit;

i want to use some thing like that.Can any one let me know how can i use that in sql select statement.

Re: PROC SQL COLUMN SEQUENCE

art297 — Fri, 07 Dec 2012 04:51:20 GMT

proc sql noprint;

create table test as

select *

from dummy (keep=id1-id24);

quit;

Re: PROC SQL COLUMN SEQUENCE

JasonNC — Fri, 07 Dec 2012 05:06:37 GMT

Hi,

I am also having an inner join with other table and i am picking some other values as well in this table

instead of writing dumm1,dumm2,dumm3 i want to write like dumm1-dumm24 in sql.

proc sql

create table test as

select dumm1.info,dummy1.pro

dumm2.peter,dumm2.marta,dumm1-dumm24

from
dummy1 innre jon dummy2

on (dumm1=dumm2);

Re: PROC SQL COLUMN SEQUENCE

art297 — Fri, 07 Dec 2012 14:08:53 GMT

Your proc sql statement has too many errors and ambiguities to show a correct example, but you can use select * and then, on the 2nd from the bottom line, add (keep=) statements after each filename.