[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: counter
From: "Whitworth, William C. (Kit) (CDC/DDID/NCHHSTP/DTE)" <0000097ec04c0710-dmarc-req
Date: 2021-10-04 18:59:31
Message-ID: SA1PR09MB796870F5D49D660D2C3D1D259FAE9 () SA1PR09MB7968 ! namprd09 ! prod ! outlook ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Nice, thank you Nat!
From: Nat Wooding <nathani@verizon.net>
Sent: Monday, October 4, 2021 2:45 PM
To: sas-l@listserv.uga.edu; Whitworth, William C. (Kit) (CDC/DDID/NCHHSTP/DTE) \
<wcw2@cdc.gov>
Subject: Re: counter
This should be close to what you need
Data Want;
set have;
by notsorted ind;
if first.ind then want = .;
If ind = 'x' then want + 1;
run;
On Monday, October 4, 2021, 02:30:01 PM EDT, wcw \
<0000097ec04c0710-dmarc-request@listserv.uga.edu<mailto:0000097ec04c0710-dmarc-request@listserv.uga.edu>> \
wrote:
I need to add a sequential counter, wherever the indicator = 'x'.....see "(want)" \
below. thanks
seq ind (want)
1
2 x 1
3
4 x 1
5 x 2
6 x 3
7
8 x 1
9 x 2
[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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span \
style="font-family:"Arial",sans-serif;color:black">Nice, thank you \
Nat!<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Nat Wooding <nathani@verizon.net> <br>
<b>Sent:</b> Monday, October 4, 2021 2:45 PM<br>
<b>To:</b> sas-l@listserv.uga.edu; Whitworth, William C. (Kit) (CDC/DDID/NCHHSTP/DTE) \
<wcw2@cdc.gov><br> <b>Subject:</b> Re: counter<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">This should be \
close to what you need<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Data \
Want;<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">set \
have;<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">by notsorted \
ind;<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">if first.ind \
then want = .;<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">If ind = 'x' \
then want + 1;<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">run;<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
</div>
<div id="ydpb5282a48yahoo_quoted_3411731567">
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">On \
Monday, October 4, 2021, 02:30:01 PM EDT, wcw <<a \
href="mailto:0000097ec04c0710-dmarc-request@listserv.uga.edu">0000097ec04c0710-dmarc-request@listserv.uga.edu</a>>
wrote: <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">I \
need to add a sequential counter, wherever the indicator = 'x'.....see \
"(want)" below. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">thanks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">seq \
ind (want)<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">1 \
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">2 \
x 1<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">3 \
<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">4 \
x 1<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">5 \
x 2<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">6 \
x 3<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">7<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">8 \
x 1<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">9 \
x 2<o:p></o:p></span></p> </div>
</div>
</div>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic