topic Re: sql: create table with new column-attributes in SAS Programming

sql: create table with new column-attributes

Konkordanz — Tue, 20 Sep 2022 07:43:57 GMT

Hi,

with SQL I want to create a new table from another and want to add a emtpy character-column. That works. But: The length is only 1 and only the first letter appears. Question: Does the sql-step has the option to define the length? For example like that (doesnt work):

proc sql;
create table test as select 
"" char(20) as GKL2,sum(bev) as bev 
from XY;
quit;

Thank you!

Re: sql: create table with new column-attributes

FreelanceReinh — Tue, 20 Sep 2022 07:49:33 GMT

Hi @Konkordanz,

Replace char(20) with length=20 and it will work. You can also put the length specification after the variable name and either way length 20 works as well.

Re: sql: create table with new column-attributes

Konkordanz — Tue, 20 Sep 2022 07:52:21 GMT

Great, Thx!