About Kelly_S

Kelly_S · ‎07-28-2019

Historically i wanted to see how many times the pair gets repeated for each month . I am still thinking about my output. But I am trying to output somewhat like this, 2017 2018 Jan Feb Mar Apr May June

Kelly_S · ‎07-28-2019

something like this, Below code picks the one's that has pairs repeated, but i cant group by month. I also have another variable called id's, its unique to each pair for each month. proc sql; create table want as select col 1, col 2, count(distinct id) as ct from have group by col1,col2 having count(distint id) >=2;run;

Kelly_S · ‎07-28-2019

Hello, I need help in building a code for a specific criteria. I have a very huge dataset with lots of variables and observations. I need to identify the repetitive pair of observations/values in 2 columns by month/year In this given dataset, the column 1 AND column 2 is a character Variable contains either name or id. Jan Month have these values get repeated in Feb month, (a,b) , (c,e or e,c) , (7,p or p,7), (6, u or u,6) . Also Jan month and April month have a pair (1,2 or 2,1) and so do March.. I need to pick only these pair matches in any of the months and store it in different datasets. I am trying my code in Proc Sql. Thanks for looking. Given Dataset: year Months Column 1- Name or ID Column2- Name or ID 17 Jan a b 17 Jan 1 2 17 Jan c e 17 Jan 5 9 17 Jan g h 17 Jan 7 p 17 Jan u 6 17 feb a b 17 feb 11 2 17 feb e c 17 feb 7 p 17 feb 6 u 17 Mar c e 17 Mar 6 u 17 Apr 2 1 18 Jan 1 2 18 Jan g h 18 feb a b 18 mar 5 b

Online Status	Offline
Date Last Visited	‎07-30-2019 12:08 AM

Re: Identify match in 2 column

Re: Identify match in 2 column

Identify match in 2 column

Re: Identify match in 2 column

Re: Identify match in 2 column

Identify match in 2 column