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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.