morinia
asked on
Generating a column between each of the columns in a table - SAS
Experts,
I have table that had 10 columns. I may have to add a column indicator between each column. Is there an efficient way to do this?
I have table that had 10 columns. I may have to add a column indicator between each column. Is there an efficient way to do this?
ASKER
I am using Proc Sql in SAS, so I would think it is mysql.
I know how to add a column by just adding it in a
Proc Sql;
Create table B as
Select columna
, column a1 (new colulmn)
, column b
, column b1 (new column)
From Table A;
quit;
I was hoping to find a more efficient way if possible.
I know how to add a column by just adding it in a
Proc Sql;
Create table B as
Select columna
, column a1 (new colulmn)
, column b
, column b1 (new column)
From Table A;
quit;
I was hoping to find a more efficient way if possible.
That's not modifying a table, its creating a new one.
Have a look at the code on this site:
http://de.saswiki.org/wiki/PROC_SQL#Hinzuf.C3.BCgen.2C_ver.C3.A4ndern_oder_l.C3.B6schen_von_Variablen
The text is german (didn't find english/international version) but the sql code is important.
*It's SAS, not mysql. I didn't read it in your question title first, bad line breaking :-(
mySQL is another DBMS, sas seems to have/be its own sql server.
Have a look at the code on this site:
http://de.saswiki.org/wiki/PROC_SQL#Hinzuf.C3.BCgen.2C_ver.C3.A4ndern_oder_l.C3.B6schen_von_Variablen
The text is german (didn't find english/international version) but the sql code is important.
*It's SAS, not mysql. I didn't read it in your question title first, bad line breaking :-(
mySQL is another DBMS, sas seems to have/be its own sql server.
ASKER
Thanks,
I am sorry I said modifying, I can create a new table I was just hoping there was a more efficient way through array processing or something similar to loop around and add the column after each exisiting column without "hardcoding" it in a select statement.
I am sorry I said modifying, I can create a new table I was just hoping there was a more efficient way through array processing or something similar to loop around and add the column after each exisiting column without "hardcoding" it in a select statement.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Lowaloysius,
I wii try tomorrow when I get back to office. I like the challenge of getting this to work.
Thanks
I wii try tomorrow when I get back to office. I like the challenge of getting this to work.
Thanks
With microsoft sql server it works at least using the gui, never modified database structure with this dbms.
Which database software are you working with?