topic Re: how to trim to column and concatenate in PROC SQL? in SAS Programming

how to trim to column and concatenate in PROC SQL?

devnand — Tue, 19 May 2015 21:04:00 GMT

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?

Re: how to trim to column and concatenate in PROC SQL?

Steelers_In_DC — Tue, 19 May 2015 21:20:26 GMT

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;

Re: how to trim to column and concatenate in PROC SQL?

Steelers_In_DC — Tue, 19 May 2015 21:22:00 GMT

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;

Re: how to trim to column and concatenate in PROC SQL?

slchen — Tue, 19 May 2015 22:26:39 GMT

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;

Re: how to trim to column and concatenate in PROC SQL?

devnand — Tue, 19 May 2015 23:05:44 GMT

Thanks much...