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;
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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.