topic Re: using retain for multiple variables in SAS Programming

using retain for multiple variables

icecubescb — Mon, 10 Dec 2018 02:38:30 GMT

Hi,

I have data just like below

and I wanto to give them ID like this

Please help

Thanks

r_behata — Mon, 10 Dec 2018 02:47:58 GMT

data want; 
Set have; 
ID=_n_;
Run;

icecubescb — Mon, 10 Dec 2018 02:49:37 GMT

hi behata,

if I want same ID for same name and DOB, I can't use _n_.

do you have any idea?

Thanks

novinosrin — Mon, 10 Dec 2018 02:56:56 GMT

data want;

set have;

by name dob notsorted;

if first.dob then id+1;

run;

icecubescb — Mon, 10 Dec 2018 03:05:16 GMT

novinosrin...
Thank you

Reeza — Mon, 10 Dec 2018 03:46:48 GMT

@icecubescb please mark @novinosrin solution as the correct answer if it answers your question.

I would consider if NOTSORTED is good usage in this case but otherwise is pretty much the standard response.