topic Re: proc append trims my text in New SAS User

proc append trims my text

laiguanyu001 — Tue, 16 Jul 2019 13:31:46 GMT

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!

Re: proc append trims my text

data_null__ — Tue, 16 Jul 2019 13:39:09 GMT

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

Re: proc append trims my text

laiguanyu001 — Tue, 16 Jul 2019 13:44:18 GMT

Thanks this works!