topic Re: How Truncate the length of values of variables? in SAS Enterprise Guide

How Truncate the length of values of variables?

Rakesh93 — Tue, 26 Nov 2019 18:58:46 GMT

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

Re: How Truncate the length of values of variables?

PGStats — Tue, 26 Nov 2019 19:44:02 GMT

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;

Re: How Truncate the length of values of variables?

Rakesh93 — Tue, 26 Nov 2019 19:36:18 GMT

Pls tell me any macro available for trucation??

Re: How Truncate the length of values of variables?

PaigeMiller — Tue, 26 Nov 2019 19:46:31 GMT

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

Re: How Truncate the length of values of variables?

PGStats — Tue, 26 Nov 2019 19:46:35 GMT

No macro needed, please refer to edited message above.

Re: How Truncate the length of values of variables?

Kurt_Bremser — Wed, 27 Nov 2019 09:20:16 GMT

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

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