proc sql trim

[tmm]

I want to trim the end 2 numbers from a column and normally can just do a trim statement but not working right.

Here is my code:

proc sql;

create table implants.alldrgs_sum as

(select distinct

trim(left(clm_aud_nbr),10) as ClaimNum,

sys_drg,

drg_desc,

alloc_rvnu_cd,

funding,

alloc_allw_amt,

epd_calc_allw_amt,

alloc_net_pd_amt

from implants.implants_aso_alldrgs_copy

group by clm_aud_nbr);

run;

[Tom · Accepted solution]

The TRIM() function does not take any numeric parameters.  What is it you want to do?

If CLM_AND_NBR is a character variable then use SUBSTR() function to take the first 10 characters.

If CLM_AND_NBR is a number what do you want to do?  Convert it to a string?  You could use the PUT() function.