data da;
length a $20;
a = 'asd';
run;
proc sql noprint;
update da set a = (select cats(max(age), '.') from sashelp.class);
update da set a = (select substrn(cats(max(age), '.'), 1, 20) from sashelp.class);
update da set a = (select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class);
update da set a = substrn((select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class), 1, 20);
quit;
All statements above produce a warning about truncation. Does anyone know how to get rid of them?
Thanks & KR
You can avoid the $200 length by NOT using the cat family of functions. e.g.:
data da; length a $20; a = 'asd'; run; proc sql noprint; update da set a = (select strip(put(max(age),2.))||'.' from sashelp.class) /* update da set a = (select substrn(cats(max(age), '.'), 1, 20) from sashelp.class) */ /* update da set a = (select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class) */ /* update da set a = substrn((select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class), 1, 20) */ ; quit;
Art, CEO, AnalystFinder.com
If you do just
proc sql;
create table a as
select cats(max(age), '.') as myvar from sashelp.class;
quit;
by itself, and then look at the attributes of myvar you will see that it is $200, which is likely some sort of default length.
You can make the length of a in da longer or perhaps ALTER da with SQL.
EDIT:
this
data da;
length a $220;
a = 'asd';
run;
proc sql noprint;
update da set a = (select cats(max(age), '.') from sashelp.class);
update da set a = (select substrn(cats(max(age), '.'), 1, 20) from sashelp.class);
update da set a = (select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class);
update da set a = substrn((select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class), 1, 20);
quit;
proc sql;
alter table da
modify a varchar(20);
quit;
doesn't throw any errors and may give you something to work with.
You can avoid the $200 length by NOT using the cat family of functions. e.g.:
data da; length a $20; a = 'asd'; run; proc sql noprint; update da set a = (select strip(put(max(age),2.))||'.' from sashelp.class) /* update da set a = (select substrn(cats(max(age), '.'), 1, 20) from sashelp.class) */ /* update da set a = (select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class) */ /* update da set a = substrn((select substrn(cats(max(age), '.'), 1, 20) length=20 from sashelp.class), 1, 20) */ ; quit;
Art, CEO, AnalystFinder.com
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.