proc sql trim

tmm — Mon, 30 Apr 2012 21:00:15 GMT

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;

Re: proc sql trim

Tom — Mon, 30 Apr 2012 21:11:00 GMT

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.