how to trim to column and concatenate in PROC SQL?

[devnand]

PROC SQL;

  CREATE TABLE work.test

  AS SELECT DISTINCT TRIM(acct_ID) || "  " || TRIM(acct_num) AS CUST_ID

  FROM work.test_account

  ORDER BY CUST_ID;

  QUIT;

Basically i am trying to trim the account_id and account num and concatenate with a space in between them.

How can I do it through PROC sql?

[Steelers_In_DC]

Here you go:

data have;

infile cards dsd dlm=',';

input one two;

cards;

500,600

200,100

;

run;

proc sql;

create table want as

select distinct *, cat(one,' ',two) as cust_id

from have;

[Steelers_In_DC]

If it's all characters try this:

data have;

infile cards dsd dlm=',';

input one $ two $;

cards;

500  ,  600

200  ,  100

;

run;

proc sql;

create table want as

select distinct *, cat(strip(one),' ',strip(two)) as cust_id

from have;

[slchen]

PROC SQL;

  CREATE TABLE work.test

  AS SELECT catx(' ',  DISTINCT acct_ID,acct_num) AS CUST_ID

  FROM work.test_account

  ORDER BY CUST_ID;

  QUIT;

[devnand]

Thanks much...