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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.