About Mick_bill

ballardw · ‎02-07-2023

I agree that it is incomprehensible what you actually have or want to display. You show code: If X > 1 then Var1 = 1; If Y > 250 then Var 2 = 1; but your data set Original has no variable X or Y. You aren't particularly clear about what should happen with X is <= to 1, or Y<=250. You have tabulate code using variables E1_A_01_HIT E1_A_02_HIT E1_A_03_HIT which are also not in "Original" data. Which do not have any obvious correlation with the data that you do show. And where are you setting the "flag" variable get Yes No Maybe Potential? Your "data" has 3 values for the Flag but you show 5 rows of output. Plus tabulate would group the first Yes with the second Yes values.

yabwon · ‎02-03-2022

SAS has arrays: data have; input ID (var1-var13)($); cards; 1 Y Y N N Y Y Y N Y Y Y N Y 2 Y Y Y Y Y Y Y Y Y Y N N N 3 Y N N N N Y N N Y Y Y Y Y ; run; data want; set have; array A{*} var1-var13; Consecutive_Y_from_Var13 = 0; do _N_ = dim(A) to 1 by -1; if a[_N_] = "N" then leave; else Consecutive_Y_from_Var13 + 1; end; run; Bart

Ksharp · ‎01-27-2022

data have; input (var1-var13)($); cards; Y Y N N Y Y Y N Y Y Y N N Y Y Y Y Y Y Y Y Y Y N N N Y N N N N Y N N Y Y Y N N ; run; data want; set have; length temp $ 2000; temp=cats(of var1-var10); pid=prxparse('/Y+/o'); s=1;e=length(temp);want=0; call prxnext(pid,s,e,temp,p,l); do while(p>0); want=max(want,l); call prxnext(pid,s,e,temp,p,l); end; drop temp pid s e p l ; run;

s_lassen · ‎01-18-2022

Instead of splitting your data and renaming the variables, why don't you use arrays to get the result you want? data want; set original_All; array periods(*) 8 period1-period4; array invars(*) z1-z3; do _N_=1 to dim(invars); periods(_N_+period-1)=invars(_N_); end; rename period=start_period; drop z1-z3; run;

Mick_bill · ‎02-02-2021

thank you, this is perfect.

ballardw · ‎10-22-2020

@Mick_bill wrote: The conditions are : IF Number <55 AND Type = "Foot" = 1 IF Type = "Foot" and Code = "Slow" = 2 IF Code = "Slow" = 3 IF Number > 5 = 4 The final result are if it hit ones of the rules or multiple. The outcome is just the name of the variable. This could be named anything as long as it is number 1 to 4. So an account may hit no conditions, one condition or multiple conditions. Depending what it hits then depends what is populated in the outcome variable. thanks. So what do you want when Number < 55 , Type='Foot' and Code='Slow'? If you want the 1 then you need to think in terms of ELSE IF Number <55 AND Type = "Foot" then Variable = 1; Else IF Type = "Foot" and Code = "Slow" then Variable = 2; Else IF Code = "Slow" = 3 then Variable=3; Else IF Number > 5 then Variable = 4 ; Otherwise regardless of the value of Type or Code when Number > 5 you will get a result of 4.

Astounding · ‎02-14-2019

Given that you have created your original data set, the programming should be short: data first_restricted all_others; set original; by key outcome notsorted; if first.outcome and outcome = "RESTRICTED" then output first_restricted; else output all_others; run;

Mick_bill · ‎07-13-2018

thank you this works great and makes sense about not using a macro and keeping it as an array. thanks,

Mick_bill · ‎03-07-2017

Thank @gamotte and @RW9they have both worked perfectly!! A transpose was the way forward rather than trying to use a reversal within the array itself. Thanks., Michael

Online Status	Offline
Date Last Visited	‎02-07-2023 08:14 AM

Re: Proc Tabulate - Some records were not included because of missing ...

Proc Tabulate - Some records were not included because of missing valu...

Counting Horizontal backwards

Horizontal count of Number of variables criteria consecutively

Re: %macro naming variables within a do loop

%macro naming variables within a do loop

Re: Proc Tabulate Percent

Proc Tabulate Percent

Re: Multiple and Different Outcomes - Single Observation

Re: Multiple and Different Outcomes - Single Observation

Re: Proc Tabulate - Some records were not included because of missing ...

Re: Counting Horizontal backwards

Re: Horizontal count of Number of variables criteria consecutively

Re: %macro naming variables within a do loop

Re: Proc Tabulate Percent

Re: Multiple and Different Outcomes - Single Observation

Re: Multiple data outcomes retained - Same ID

Re: Macros and Arrays - Manipulating data

Re: Selecting accounts to reverse within an Array