You can either create a new dataset with a LENGTH statement for your variable, or use the ALTER TABLE statement in PROC SQL with the MODIFY clause to change the variable length in your original table.
Example:
/* create example table */
data class; set sashelp.class; run;
/* Modify length of variable NAME */
proc sql;
alter table class
modify name character(6);
quit;
@Rakesh93 wrote:
Pls tell me any macro available for trucation??
Are you asking about macros because you have a lot of variables to truncate? If so, please explain further.
No macro needed, please refer to edited message above.
@Rakesh93 wrote:
Pls tell me any macro available for trucation??
No macro needed. Just run the code you were already given.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.