proc append trims my text

[laiguanyu001]

Hi,

I am using proc append in a macro. 

My base data is an empty data:

data1;

input message $120;

run;

data2;

message = 'A message less than 120 characters';

run;

proc append base = data1 data = data2 force;

run;

even though I set my base data length to be a lot longer than appending data, the message after proc append force is trimmed to "A", which is the first letter in the message. Can someone explain why that happens? Thanks!

[data_null__ · Accepted solution]

---

@laiguanyu001 wrote:

Hi,

I am using proc append in a macro. 

My base data is an empty data:

data1;

input message $120;

run;

data2;

message = 'A message less than 120 characters';

run;

proc append base = data1 data = data2 force;

run;

even though I set my base data length to be a lot longer than appending data, the message after proc append force is trimmed to "A", which is the first letter in the message. Can someone explain why that happens? Thanks!

---

The code to make the empty data set is not right.  Try something like this.

data data1;
   stop;
   length message $120;
   run;

[laiguanyu001]

Thanks this works!