topic How to increase the length of character value in New SAS User

How to increase the length of character value

hjjijkkl — Mon, 10 May 2021 23:42:58 GMT

I am combining two dataset and some of the subjs email address "in the observation" is cutting off when I combine the data. I increased the length but, its not helping at all. the email are all fine before combining the data but, when I combine they are cutting of.

Here is an example of the code I used.

data need

length email $50;

set data1 and data2;

run;

Re: How to increase the length of character value

hjjijkkl — Mon, 10 May 2021 23:43:19 GMT

How can I fi this issue

Re: How to increase the length of character value

Tom — Tue, 11 May 2021 00:16:34 GMT

That is a way to set the length of a variable (once you fix the typos). Whether it increases the length or not depends on how it was defined before in DATA1. 50 bytes does not seem long enough for an email address.

Note that if it is already truncated in either DATA1 or DATA2 you cannot recover the lost value by just making the variable long. 🙂

But you also need to watch out if either DATA1 or DATA2 has a format attached to the variable it might be truncating the printing of the values. There is no good reason to have a $ format attached to a character variable so remove it just in case.

data need ;
  length email $200;
  set data1 data2;
  format email ;
run;

Re: How to increase the length of character value

Reeza — Tue, 11 May 2021 01:58:21 GMT

Your code is wrong as shown, assuming you remove the AND it should likely work fine. Make sure 50 is enough and verify that it wasn't truncated before hand as well.

Re: How to increase the length of character value

Patrick — Tue, 11 May 2021 02:44:54 GMT

If the issue is really that you've got a same named character variable in your two source tables but the lengths of the variable differ then one way to go in case both data sets have the exactly same variables.

proc sql;
  create table need as
  select * from data1
  union corr all
  select * from data2
  ;
quit;

A SQL UNION CORR ALL will use the max. variable lengths from the source tables to create target table need.

If you know exactly in which one of the source tables the variable has a greater length then use this source table first in your set statement. SAS creates the variables in the pdv using the first occurrence of the variable in the code. So if your variable has a greater length in data2 then your code could look like:

data need
  set data2 data1;
run;

Or then as you've done in your code set the length of the variable prior to the set statements. That works the same as above as this way the SAS compiler will encounter the variable the first time in the length statement and use this definition to create the variable in the pdv.

data need
  length email $50;
  set data1 data2;
run;

Re: How to increase the length of character value

Ksharp — Tue, 11 May 2021 12:30:51 GMT

Try SQL.

data have;
 set sashelp.class;
run;


proc sql;
alter table have
modify sex char(20),name char(100);
quit;