topic Re: Create Unique ID based on two variables in SAS Programming

Create Unique ID based on two variables

Prateek1 — Sat, 18 Jun 2016 18:23:04 GMT

hi,

i just want to know that how to create a Unique ID in the data set using two variables in the data set using TRIM and double pipe function ?

please give me the code ?

thanks

sas_learner

Re: Create Unique ID based on two variables

Reeza — Sat, 18 Jun 2016 18:24:59 GMT

I'm confused, it sounds like you know what you want, are you having issues creating the variable?
If so, post the code you've used and are having issues with. I'm also uncertain as to what you mean by double pipe function.

There is a double pipe that is used to represent concatenation, but in my opinion, the CAT family of functions are better, especially since they'll do things like trim by default (CATT).

Re: Create Unique ID based on two variables

PGStats — Sat, 18 Jun 2016 20:34:21 GMT

Find a character which doesn't occur in your vaiables, such as "@", and create your unique ID as

length uniqueID $20; /* To be adjusted */

uniqueID = catx("@", var1, var2);

Re: Create Unique ID based on two variables

Prateek1 — Mon, 20 Jun 2016 11:43:53 GMT

hi,

using when-select statements, how can we define a new variable providing the country of each model based on the manufacturer.??

thanks ,

Re: Create Unique ID based on two variables

Reeza — Mon, 20 Jun 2016 12:32:24 GMT

@Prateek1 Please post your question as a new topic.