topic Re: combine this into single variable in SAS Programming

combine this into single variable

animesh123 — Tue, 02 Aug 2022 09:13:06 GMT

ID NAME
1 FirstName

1 LastName

1 ABC

How to combine this into single variable

Output :-FirstName LastName ABC

Re: combine this into single variable

Adriaan_Gouws — Tue, 02 Aug 2022 09:23:08 GMT

Good day

Please give the below a go.

DATA WANT;
  SET HAVE;
  BY ID;
  LENGTH COMBINED $200;
  RETAIN COMBINED;
  COMBINED=IFC(FIRST.ID,NAME,CATX('-',COMBINED,NAME));
  IF LAST.ID THEN OUTPUT;
RUN;

Re: combine this into single variable

PeterClemmensen — Tue, 02 Aug 2022 10:57:25 GMT

data have;
input ID NAME :$10.;
datalines;
1 FirstName 
1 LastName  
1 ABC       
;

data want;
   do until (last.id);
      set have;
      by id;
      length comb $ 200;
      comb = catx(' ', comb, name);
   end;
run;

Re: combine this into single variable

animesh123 — Tue, 02 Aug 2022 11:37:53 GMT

Thanks. I have tried executing the same but the output is different then i have expected

Output will be :-

e.g:

1 FirstName LastName ABC

1 Daniel Riccardo ABC

Re: combine this into single variable

PeterClemmensen — Tue, 02 Aug 2022 11:44:02 GMT

I don't understand this. Do you want the values in a single variable or multiple variables.

Please be more specific.

Re: combine this into single variable

Tom — Tue, 02 Aug 2022 13:59:47 GMT

@animesh123 wrote:

Thanks. I have tried executing the same but the output is different then i have expected

Output will be :-

e.g:

1 FirstName LastName ABC

1 Daniel Riccardo ABC

That output does not look like it could have been generated from the input you provided in your question. There was no Daniel in your original data for example.

Provide a more complete example input. Provide the output that you expect from that input. Provide both as actual working data steps that create SAS datasets so there are no questions about the names, types, lengths, etc of the variables you have and the variables you want.