cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ebeth
‎11-02-2019
  • 5 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: COUNTER, RETAIN AND FIRST.

by Fluorite | Level 6 in SAS Procedures
‎11-02-2019 04:17 PM
‎11-02-2019 04:17 PM
Thank you! ... View more

Re: COUNTER, RETAIN AND FIRST.

by Fluorite | Level 6 in SAS Procedures
‎11-01-2019 04:40 PM
‎11-01-2019 04:40 PM
Yes, I want running count of non missing values of A, B and C.   This works perfectly for NUM_B and NUM_C. But NUM_A  is showing a "1" for every line on the same date. Then a 0 for the next new date. Even when there is a missing value of A it outputs 1 until new date. ... View more

Re: COUNTER, RETAIN AND FIRST.

by Fluorite | Level 6 in SAS Procedures
‎11-01-2019 03:24 PM
‎11-01-2019 03:24 PM
This worked almost perfectly. Thank you.  One odd thing though is that the very first NUM_A is a missing value. The only missing value.  Instead of zero. I thought the RETAIN statement set that to zero? ... View more

Re: COUNTER, RETAIN AND FIRST.

by Fluorite | Level 6 in SAS Procedures
‎11-01-2019 03:10 PM
‎11-01-2019 03:10 PM
I used PROC SORT to sort BY ID DATE (must have forgotten TYPE). If I do sort by TYPE as well though, my goal is to add in the 3 columns in red. The red columns are not part of the original data; I want to create those counts.    For example, NUM_A should count "1", then  "2" for the first 2 A's on the same date and ID.  or 3 if there is a 3rd A for that date and ID Then start the count over for the next A on a different date, but same ID.   ... View more

COUNTER, RETAIN AND FIRST.

by Fluorite | Level 6 in SAS Procedures
‎10-31-2019 07:18 PM
‎10-31-2019 07:18 PM
Hello, I'm a 2 month old SAS user and just started practicing COUNTER, RETAIN, FIRST. ,Last. and DO/END. I can  understand simple examples (of course) but am getting stuck when there is missing data and multiple variables involved.    For example: This data is sorted BY ID DATE TYPE already and the columns in red are what I'm trying to add in. I think Num_A should be counter+1 when the variable is the first non=missing value for A and then start over for each date. And eventually if the ID changed as well. The same for num_B and C.    ID DATE TYPE A B C NUM_A NUM_B NUM_C   1 1/1/2010 B . 10 . 0 1 0 1 1/1/2010 A 3 . . 1 0 0 1 1/1/2010 A 7 . . 2 0 0 1 1/1/2010 C . . 11 0 0 1 1 3/17/2010 B . 5 . 0 1 0 1 3/17/2010 A 4 . . 1 0 0 1 3/17/2010 C . . 3 0 0 1 1 5/1/2010 B . 7 . 0 1 0 1 5/1/2010 A 3 . . 1 0 0 1 5/1/2010 C . . 4 0 0 1   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-02-2019 09:06 PM
Likes given to
View All
Quick links