topic Re: Conversion of numeric to Character in a concatenate in SAS Programming

Conversion of numeric to Character in a concatenate

Jyuen204 — Tue, 01 Sep 2020 14:41:14 GMT

I have a data set that has been compiled and I have to concatenate 3 of the fields.

1 field is a character field : CUST-123

2nd Field is numeric: 56789

3rd field is a date field: 01/Sep/2020

proc sql;
select CUSTID||''||put(NUMBER_ID,10.)||''||put(CREATION_DATE_TIME,10.) from TABLE;
run;

Using the Put it changes the 2 non character fields to character but my result set comes out as:

CUST-123 6523574 22159

I tried trim but that doesnt work. I want the result set but without any spaces

Re: Conversion of numeric to Character in a concatenate

PeterClemmensen — Tue, 01 Sep 2020 14:43:56 GMT

What does your desired result look like?

Where does 6523574 come from?

Re: Conversion of numeric to Character in a concatenate

Jyuen204 — Tue, 01 Sep 2020 14:48:37 GMT

My end result that i want would be

CUST-123652357422159

6523574 is just an arbitrary number in my data

Re: Conversion of numeric to Character in a concatenate

PeterClemmensen — Tue, 01 Sep 2020 14:52:42 GMT

See if this works for you.

data _null_;
   _1 = "CUST-123";
   _2 = 56789;
   _3 = '01sep2020'd;

   want = cats(_1, _2, _3);
   put want=;
run;

Re: Conversion of numeric to Character in a concatenate

Jyuen204 — Tue, 01 Sep 2020 15:00:01 GMT

Would i just be using the field names ?

_1 = CUST_ID etc?

Re: Conversion of numeric to Character in a concatenate

Reeza — Tue, 01 Sep 2020 16:06:45 GMT

You can use CATT() instead which will trim all trailing spaces. Did you want the date as the SAS date value or a number such as 20200901?

proc sql;
select 
catt(custid, put(number_id, z10.), put(creation_date_time, yymmddn10.)) as want from table;
quit;
run;

@Jyuen204 wrote:

I have a data set that has been compiled and I have to concatenate 3 of the fields.

1 field is a character field : CUST-123

2nd Field is numeric: 56789

3rd field is a date field: 01/Sep/2020

proc sql;
select CUSTID||''||put(NUMBER_ID,10.)||''||put(CREATION_DATE_TIME,10.) from TABLE;
run;

Using the Put it changes the 2 non character fields to character but my result set comes out as:

CUST-123 6523574 22159

I tried trim but that doesnt work. I want the result set but without any spaces

Re: Conversion of numeric to Character in a concatenate

Jyuen204 — Tue, 01 Sep 2020 16:15:15 GMT

Thanks i will give that a try. I used Compress() and that seems to have done the trick as well. Always good to have multiple solutions! Cheers everyone!

Re: Conversion of numeric to Character in a concatenate

Reeza — Tue, 01 Sep 2020 16:34:11 GMT

COMPRESS will remove any internal spaces as well so it's not a robust solution IMO.