[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: flag non-identical values in a group
From: Mark Keintz <mkeintz () OUTLOOK ! COM>
Date: 2021-10-05 18:16:52
Message-ID: BL0PR10MB28047855EEF5D8C9A858C426B6AF9 () BL0PR10MB2804 ! namprd10 ! prod ! outlook ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Do your non-identical values always occur as single observations both preceded and \
succeeded by observations in the current group?
Otherwise, will you have to check for a sequence like this (what is the minimum group \
size)?
obs grp
1 6
2 6
3 6
4 5
5 5
6 6
7 6
8 6
And what about
obs grp
1 6
2 6
3 6
4 6
5 6
6 9
7 6
8 9
9 9
10 9
11 9
12 9
Does the new group of 9 begin with observation 6, (so group 6 ends at obs 5), or \
observation 8 (and group 6 ends at obs 7)?
regards,
Mark
-----Original Message-----
From: SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU> On Behalf Of wcw
Sent: Tuesday, October 5, 2021 9:44 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: flag non-identical values in a group
I need to do a data check that will flag any numeric values that are not identical to \
others in a group, see below. The first GROUPNO value of each group will always be \
correct. Thanks so much.
OBS GROUPNO FLAG (want)
1 6
2 6
3 6
4 5 x
5 6
6 6
7 6
8 20
9 21 x
10 20
11 20
12 20
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1542937658;
mso-list-type:hybrid;
mso-list-template-ids:-896494802 -186744740 67698713 67698715 67698703 67698713 \
67698715 67698703 67698713 67698715;} @list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:23.25pt;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:59.25pt;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:95.25pt;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:131.25pt;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:167.25pt;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:203.25pt;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:239.25pt;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:275.25pt;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:311.25pt;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoPlainText">Do your non-identical values always occur as single \
observations both preceded and succeeded by observations in the current \
group?<o:p></o:p></p> <p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Otherwise, will you have to check for a sequence like this \
(what is the minimum group size)?<o:p></o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p class="MsoPlainText">obs \
grp<o:p></o:p></p> <p class="MsoPlainText">1 6<o:p></o:p></p>
<p class="MsoPlainText">2 6<o:p></o:p></p>
<p class="MsoPlainText">3 6<o:p></o:p></p>
<p class="MsoPlainText">4 5 <o:p></o:p></p>
<p class="MsoPlainText">5 5<o:p></o:p></p>
<p class="MsoPlainText">6 6<o:p></o:p></p>
<p class="MsoPlainText">7 6<o:p></o:p></p>
<p class="MsoPlainText">8 6<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">And what about<o:p></o:p></p>
<p class="MsoPlainText">obs grp<o:p></o:p></p>
<p class="MsoPlainText">1 6 <o:p></o:p></p>
<p class="MsoPlainText"> 2 6<o:p></o:p></p>
<p class="MsoPlainText">3 6<o:p></o:p></p>
<p class="MsoPlainText">4 6<o:p></o:p></p>
<p class="MsoPlainText">5 6<o:p></o:p></p>
<p class="MsoPlainText">6 9<o:p></o:p></p>
<p class="MsoPlainText">7 6<o:p></o:p></p>
<p class="MsoPlainText">8 9<o:p></o:p></p>
<p class="MsoPlainText">9 9<o:p></o:p></p>
<p class="MsoPlainText">10 9<o:p></o:p></p>
<p class="MsoPlainText">11 9<o:p></o:p></p>
<p class="MsoPlainText">12 9<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Does the new group of 9 begin with observation 6, (so group 6 \
ends at obs 5), or observation 8 (and group 6 ends at obs 7)?<o:p></o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText">regards,<o:p></o:p></p> <p \
class="MsoPlainText">Mark<o:p></o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p class="MsoPlainText">-----Original \
Message-----<br>
From: SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU> On Behalf Of wcw<br>
Sent: Tuesday, October 5, 2021 9:44 AM<br>
To: SAS-L@LISTSERV.UGA.EDU<br>
Subject: flag non-identical values in a group</p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I need to do a data check that will flag any numeric values \
that are not identical to others in a group, see below. The first GROUPNO value of \
each group will always be correct. Thanks so much.<o:p></o:p></p> <p \
class="MsoPlainText"><o:p> </o:p></p> <p \
class="MsoPlainText">OBS \
GROUPNO FLAG (want) <o:p></o:p></p> <p \
class="MsoPlainText">1 \
6 \
<o:p></o:p></p> <p class="MsoPlainText">2 \
6 & \
nbsp; \
<o:p></o:p></p> <p class="MsoPlainText">3 \
6 \
<o:p></o:p></p> <p class="MsoPlainText">4 \
5 \
x
<o:p></o:p></p>
<p class="MsoPlainText">5 \
6 \
<o:p></o:p></p> <p class="MsoPlainText">6 \
6 \
<o:p></o:p></p> <p class="MsoPlainText">7 \
6 \
<o:p></o:p></p>
<p class="MsoPlainText">8 \
20 \
<o:p></o:p></p> <p class="MsoPlainText">9 \
21 \
x
<o:p></o:p></p>
<p class="MsoPlainText">10 \
20 \
<o:p></o:p></p> <p class="MsoPlainText">11 \
20 <o:p></o:p></p> <p \
class="MsoPlainText">12 \
20 <o:p></o:p></p> </div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic