topic Re: How to combine two variables into one with a certain format in New SAS User

How to combine two variables into one with a certain format

BLT2023 — Mon, 06 Nov 2023 18:29:26 GMT

Hello,

I am working on a homework assignment, and part of the assignment is to take two variables 'FirstNm' and 'LastNm' and combine them into one variable titled 'Name' with the format last name, first name. How do I do this?

Re: How to combine two variables into one with a certain format

Reeza — Mon, 06 Nov 2023 18:39:51 GMT

Look up the CATX() function.

Re: How to combine two variables into one with a certain format

ballardw — Mon, 06 Nov 2023 21:27:34 GMT

One thing you need to be very aware of with SAS is that FORMAT has a very specify meaning related to display of values using a defined Format (read up on the procedure). The format at display time applies rules for displaying a value.

You are discussing layout or order, not format.

That involves concatenation in this case, the formal term for "sticking text together".

You should define the length of the new variable before assigning values as the approach chosen could create extremely long values.

You aren't clear whether the result should have a comma, a space or a comma and a space as a result.

It is best to provide an actual example. Such as Firstnm='Bob' , Lastnm='Smith' and want Name='Smith, Bob'. Now we can see that you want to insert a comma and a space (if that is in fact the desired result).

What have you tried so far? I should think that your instructor provided at least some clues.

If not, one clue: CATX function would be my preferred tool.

Re: How to combine two variables into one with a certain format

Reeza — Mon, 06 Nov 2023 18:51:15 GMT

https://communities.sas.com/t5/SAS-Communities-Library/How-to-concatenate-values-in-SAS/ta-p/494125

Re: How to combine two variables into one with a certain format

BLT2023 — Mon, 06 Nov 2023 20:00:27 GMT

I have tried:

data WORK.stjohns;
FirstNm = 'Daniel';
LastNm = 'Taylor';
length Name $ 12;
Name = catx(',', LastNm, FirstNm);
put _all_;
run;

It gave me nothing in my new variable. I am looking for Firstnm='Daniel' , Lastnm='Taylor' and want Name='Taylor, Daniel'.

Re: How to combine two variables into one with a certain format

PaigeMiller — Mon, 06 Nov 2023 20:24:26 GMT

Your length statement is shorter than the desired character string. Change the length statement to allow bigger character strings.

Re: How to combine two variables into one with a certain format

BLT2023 — Mon, 06 Nov 2023 20:26:30 GMT

Thank you! I guess I miscounted. The output came out as "Taylor,Daniel"- how do I get a space in between the comma and the D?

Re: How to combine two variables into one with a certain format

BLT2023 — Mon, 06 Nov 2023 20:29:36 GMT

Also, a follow-up question: How do I do this for more than one name?

Re: How to combine two variables into one with a certain format

PaigeMiller — Mon, 06 Nov 2023 20:36:14 GMT

@BLT2023 wrote:

Thank you! I guess I miscounted. The output came out as "Taylor,Daniel"- how do I get a space in between the comma and the D?

I give you a hint: it is a tiny change to the CATX function first argument. I give another hint, which was previously given by @Reeza: really, look at the documentation for CATX, its all explained in there.

a follow-up question: How do I do this for more than one name?

This is simply done in a DATA step, where you use the SET command to allow it to work on another SAS data set with lots of names.

Re: How to combine two variables into one with a certain format

BLT2023 — Mon, 06 Nov 2023 20:54:10 GMT

I am a bit confused by what you mean when you say (in reference to SET) 'allow it to work on another SAS data set with lots of names.' It is the same data set (I'musing data lines), but there are 2 more names within the data lines. that need catx. Does your statement about SET still apply? Thank you for clarifying.

Re: How to combine two variables into one with a certain format

Reeza — Mon, 06 Nov 2023 21:44:16 GMT

data class;
set sashelp.class (keep=name rename=name=first_name); *this is your input data set;

last_name = "Flinstone"; *make a fake last name as there's no names in the data;

name = catx(", ", last_name, first_name); *create full name;

run;

proc print data=class;
run;

Re: How to combine two variables into one with a certain format

PaigeMiller — Wed, 08 Nov 2023 12:18:49 GMT

@BLT2023 wrote:

I am a bit confused by what you mean when you say (in reference to SET) 'allow it to work on another SAS data set with lots of names.' It is the same data set (I'musing data lines), but there are 2 more names within the data lines. that need catx. Does your statement about SET still apply? Thank you for clarifying.

Show us the SAS data set you are working with. (We don't need all of it, for example 5 lines ought to be good enough)