Styjun

How to travel to Japan while expressing milk?

How can a day be of 24 hours?

How to remove border from elements in the last row?

How can I prove that a state of equilibrium is unstable?

How to prevent "they're falling in love" trope

Why were 5.25" floppy drives cheaper than 8"?

Why was Sir Cadogan fired?

Can I hook these wires up to find the connection to a dead outlet?

Could the museum Saturn V's be refitted for one more flight?

If a warlock makes a Dancing Sword their pact weapon, is there a way to prevent it from disappearing if it's farther away for more than a minute?

Was the Stack Exchange "Happy April Fools" page fitting with the '90's code?

How to coordinate airplane tickets?

Did 'Cinema Songs' exist during Hiranyakshipu's time?

What is the fastest integer factorization to break RSA?

Do Iron Man suits sport waste management systems?

Why didn't Boeing produce its own regional jet?

How exploitable/balanced is this homebrew spell: Spell Permanency?

Why is the sentence "Das ist eine Nase" correct?

How to install cross-compiler on Ubuntu 18.04?

Finding the reason behind the value of the integral.

Convert seconds to minutes

Does int main() need a declaration on C++?

Knowledge-based authentication using Domain-driven Design in C#

Can a virus destroy the BIOS of a modern computer?

How to count the length of a nonzero sequence in SAS

Change variable length in SAS datasetChanging values in previous and post records when a numerical condition is met using SASHow to create dummy variables to indicate two values are the same using SASHow to roll-up a column of data and separate values by a delimiter?Bring the length of an array to another array in SAS?Conditionally Counting a Response Across Multiple Variables in SASHow to count observations in a SAS dataset using proc sql?hLookup for the first non-zero value in SASCount the length of a chain in SQLSAS Counting Keywords Across Columns

0

I'd like to count the length of the non zero sequence in a data as below:

ID Value 
1 0 
1 0 
1 2.5 
1 3 
1 0 
1 4 
1 2 
1 5 
1 0 

So here the length of the first non zero sequence is 2 and the length of the second non zero sequence is 3. The new data will look like this:

ID Value Length 
1 0 0 
1 0 0 
1 2.5 2 
1 3 2 
1 0 0 
1 4 3 
1 2 3 
1 5 3 
1 0 0 

How can I write SAS code to accomplish this task with a large data like this. Thanks!

sas

share|improve this question

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you need to store each of the lengths? What is your desired output? A new dataset with a variable representing these lengths (down the column), or something else?
  
  – AlexK
  Mar 21 at 21:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. I need to store the length in a new variable. I edited my question as above.
  
  – Tammy
  Mar 21 at 21:46
  
  

  
  
  
  

add a comment | 

0

I'd like to count the length of the non zero sequence in a data as below:

ID Value 
1 0 
1 0 
1 2.5 
1 3 
1 0 
1 4 
1 2 
1 5 
1 0 

So here the length of the first non zero sequence is 2 and the length of the second non zero sequence is 3. The new data will look like this:

ID Value Length 
1 0 0 
1 0 0 
1 2.5 2 
1 3 2 
1 0 0 
1 4 3 
1 2 3 
1 5 3 
1 0 0 

How can I write SAS code to accomplish this task with a large data like this. Thanks!

sas

share|improve this question

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you need to store each of the lengths? What is your desired output? A new dataset with a variable representing these lengths (down the column), or something else?
  
  – AlexK
  Mar 21 at 21:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. I need to store the length in a new variable. I edited my question as above.
  
  – Tammy
  Mar 21 at 21:46
  
  

  
  
  
  

add a comment | 

I'd like to count the length of the non zero sequence in a data as below:

ID Value 
1 0 
1 0 
1 2.5 
1 3 
1 0 
1 4 
1 2 
1 5 
1 0 

So here the length of the first non zero sequence is 2 and the length of the second non zero sequence is 3. The new data will look like this:

ID Value Length 
1 0 0 
1 0 0 
1 2.5 2 
1 3 2 
1 0 0 
1 4 3 
1 2 3 
1 5 3 
1 0 0 

How can I write SAS code to accomplish this task with a large data like this. Thanks!

sas

share|improve this question

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

ID Value 
1 0 
1 0 
1 2.5 
1 3 
1 0 
1 4 
1 2 
1 5 
1 0 

ID Value Length 
1 0 0 
1 0 0 
1 2.5 2 
1 3 2 
1 0 0 
1 4 3 
1 2 3 
1 5 3 
1 0 0 

share|improve this question

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

share|improve this question

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

edited Mar 22 at 0:05

AlexK

392111

edited Mar 22 at 0:05

AlexK

392111

asked Mar 21 at 20:38

TammyTammy

12

asked Mar 21 at 20:38

TammyTammy

12

1 Answer
1

active

oldest

votes

0

Here is one possible solution. It assumes there are no missing values in the Value variable and that your ID variable does not have any significance for this problem.

*creates new length variable that starts at 1 and increments by 1 from start to end of every non-zero sequence;
data step_one (drop=prev_val);
 set orig_data;
 retain prev_val length 0;
 indx = _n_;
 if value ne 0 and prev_val ne 0 then length = length + 1;
 else if value ne 0 then length = 1;
 else if value = 0 then length = 0;
 prev_val = value;
run;

*sorts dataset in reverse order;
proc sort data=step_one;
 by descending indx;
run;

*creates modified length variable that carries maximum length value for each sequence down to all observations included in that sequence;
data step_two (drop=length prev_length rename=(length_new=length));
 set step_one;
 retain length_new prev_length 0;
 if length = 0 then length_new = 0;
 else if length ne 0 and prev_length = 0 then
 length_new = length;
 prev_length = length;
run;

*re-sorts dataset back to its original order and outputs final dataset with just the needed variables;
proc sort data=step_two out=final_result (keep=ID value length);
 by indx;
run;

share|improve this answer

answered Mar 21 at 22:51

AlexKAlexK

392111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works like a charm. Thank you so much!
  
  – Tammy
  Mar 22 at 14:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You are welcome. Please mark the answer as accepted in that case.
  
  – AlexK
  Mar 22 at 18:57
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55288885%2fhow-to-count-the-length-of-a-nonzero-sequence-in-sas%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Here is one possible solution. It assumes there are no missing values in the Value variable and that your ID variable does not have any significance for this problem.

*creates new length variable that starts at 1 and increments by 1 from start to end of every non-zero sequence;
data step_one (drop=prev_val);
 set orig_data;
 retain prev_val length 0;
 indx = _n_;
 if value ne 0 and prev_val ne 0 then length = length + 1;
 else if value ne 0 then length = 1;
 else if value = 0 then length = 0;
 prev_val = value;
run;

*sorts dataset in reverse order;
proc sort data=step_one;
 by descending indx;
run;

*creates modified length variable that carries maximum length value for each sequence down to all observations included in that sequence;
data step_two (drop=length prev_length rename=(length_new=length));
 set step_one;
 retain length_new prev_length 0;
 if length = 0 then length_new = 0;
 else if length ne 0 and prev_length = 0 then
 length_new = length;
 prev_length = length;
run;

*re-sorts dataset back to its original order and outputs final dataset with just the needed variables;
proc sort data=step_two out=final_result (keep=ID value length);
 by indx;
run;

share|improve this answer

answered Mar 21 at 22:51

AlexKAlexK

392111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works like a charm. Thank you so much!
  
  – Tammy
  Mar 22 at 14:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You are welcome. Please mark the answer as accepted in that case.
  
  – AlexK
  Mar 22 at 18:57
  

  
  
  
  

add a comment | 

0

Here is one possible solution. It assumes there are no missing values in the Value variable and that your ID variable does not have any significance for this problem.

*creates new length variable that starts at 1 and increments by 1 from start to end of every non-zero sequence;
data step_one (drop=prev_val);
 set orig_data;
 retain prev_val length 0;
 indx = _n_;
 if value ne 0 and prev_val ne 0 then length = length + 1;
 else if value ne 0 then length = 1;
 else if value = 0 then length = 0;
 prev_val = value;
run;

*sorts dataset in reverse order;
proc sort data=step_one;
 by descending indx;
run;

*creates modified length variable that carries maximum length value for each sequence down to all observations included in that sequence;
data step_two (drop=length prev_length rename=(length_new=length));
 set step_one;
 retain length_new prev_length 0;
 if length = 0 then length_new = 0;
 else if length ne 0 and prev_length = 0 then
 length_new = length;
 prev_length = length;
run;

*re-sorts dataset back to its original order and outputs final dataset with just the needed variables;
proc sort data=step_two out=final_result (keep=ID value length);
 by indx;
run;

share|improve this answer

answered Mar 21 at 22:51

AlexKAlexK

392111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It works like a charm. Thank you so much!
  
  – Tammy
  Mar 22 at 14:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You are welcome. Please mark the answer as accepted in that case.
  
  – AlexK
  Mar 22 at 18:57
  

  
  
  
  

add a comment | 

Here is one possible solution. It assumes there are no missing values in the Value variable and that your ID variable does not have any significance for this problem.

*creates new length variable that starts at 1 and increments by 1 from start to end of every non-zero sequence;
data step_one (drop=prev_val);
 set orig_data;
 retain prev_val length 0;
 indx = _n_;
 if value ne 0 and prev_val ne 0 then length = length + 1;
 else if value ne 0 then length = 1;
 else if value = 0 then length = 0;
 prev_val = value;
run;

*sorts dataset in reverse order;
proc sort data=step_one;
 by descending indx;
run;

*creates modified length variable that carries maximum length value for each sequence down to all observations included in that sequence;
data step_two (drop=length prev_length rename=(length_new=length));
 set step_one;
 retain length_new prev_length 0;
 if length = 0 then length_new = 0;
 else if length ne 0 and prev_length = 0 then
 length_new = length;
 prev_length = length;
run;

*re-sorts dataset back to its original order and outputs final dataset with just the needed variables;
proc sort data=step_two out=final_result (keep=ID value length);
 by indx;
run;

share|improve this answer

answered Mar 21 at 22:51

AlexKAlexK

392111

*creates new length variable that starts at 1 and increments by 1 from start to end of every non-zero sequence;
data step_one (drop=prev_val);
 set orig_data;
 retain prev_val length 0;
 indx = _n_;
 if value ne 0 and prev_val ne 0 then length = length + 1;
 else if value ne 0 then length = 1;
 else if value = 0 then length = 0;
 prev_val = value;
run;

*sorts dataset in reverse order;
proc sort data=step_one;
 by descending indx;
run;

*creates modified length variable that carries maximum length value for each sequence down to all observations included in that sequence;
data step_two (drop=length prev_length rename=(length_new=length));
 set step_one;
 retain length_new prev_length 0;
 if length = 0 then length_new = 0;
 else if length ne 0 and prev_length = 0 then
 length_new = length;
 prev_length = length;
run;

*re-sorts dataset back to its original order and outputs final dataset with just the needed variables;
proc sort data=step_two out=final_result (keep=ID value length);
 by indx;
run;

share|improve this answer

answered Mar 21 at 22:51

AlexKAlexK

392111

answered Mar 21 at 22:51

AlexKAlexK

392111

answered Mar 21 at 22:51

AlexKAlexK

392111