How Truncate the length of values of variables?

[Rakesh93]

While validating my dataset, it's showing Variable length is too long for actual data.

[PGStats]

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]

Pls tell me any macro available for trucation??

[PaigeMiller]

---

@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.

[PGStats]

No macro needed, please refer to edited message above.

[Kurt_Bremser]

---

@Rakesh93 wrote:
Pls tell me any macro available for trucation??

---

No macro needed. Just run the code you were already given.