About adventuresinsas

Ksharp · ‎10-30-2020

Code Not Tested: proc sql; create table want as select * from have group by address having count(distinct city) > 1; quit;

ErikLund_Jensen · ‎01-13-2020

Hi @adventuresinsas I realize it cannot handle a situation, where two consecutive records for the same ID has the same month, but in different years. They will be seen as the same month. This should be failsafe: data want; set have; if lag(ID)=ID and put(lag(Month),YYMM7.)=put(Month,YYMM7.) then count + 1; else count=Var1; run;

adventuresinsas · ‎01-13-2020

Just an update to everyone: I discovered that the reason for this was because I didn't have the "Use prompt value throughout project" box selected for that particular prompt/macro variable. Checking that box solved my issue.

novinosrin · ‎07-22-2019

data want; set have; retain _id; if not missing(id) then _id=id; else id=_id; drop _id; run;

Online Status	Offline
Date Last Visited	‎10-30-2020 04:13 PM

Find rows with duplicates in one column but not another?

Re: Retain statement with two by group variables?

Re: Retain statement with two by group variables?

Re: Retain statement with two by group variables?

Retain statement with two by group variables?

Re: Global macro variable not showing up in SAS Enterprise Guide?

Global macro variable not showing up in SAS Enterprise Guide?

How to fill in missing values?

Re: Retain statement with two by group variables?

Re: Find rows with duplicates in one column but not another?

Re: Retain statement with two by group variables?

Re: Global macro variable not showing up in SAS Enterprise Guide?

Re: How to fill in missing values?