I didn't really understand that much ... View more

I'm sorry for contacting you so much, but my question is if the same thing is possible, just not in PROC SQL? The code I build before is with a loop written in the SAS language. thank you. ... View more

Hey The input is very long and not everything is relevant, I will send what is relevant. I have 2 variables - One called A runs from 1 until the variable B changes B is a variable that changes every random number. I need C to either give me the higher number of A or count B for me every time. (option for 2 different methods) The problem is that I create and need to create A and B in the same command/table (necessary for other things) so I also need to create C together with them. ;data_work1 set work2 b= ... if b = lag (a) then a+1; else a=1; here i need your code run; It's easiest to understand from the table that looks like this:   Thank you very much for your help!   A B C 1 XXX 9 2 XXX 9 3 XXX 9 4 XXX 9 5 XXX 9 6 XXX 9 7 XXX 9 8 XXX 9 9 XXX 9 1 BB 11 2 BB 11 3 BB 11 4 BB 11 5 BB 11 6 BB 11 7 BB 11 8 BB 11 9 BB 11 10 BB 11 11 BB 11 1 A 7 2 A 7 3 A 7 4 A 7 5 A 7 6 A 7 7 A 7 1 CC 6 2 CC 6 3 CC 6 4 CC 6 5 CC 6 6 CC 6                                           ... View more

Hi, the business is working. But I have something I need to change and would appreciate your help. I create variable A in the same table that I create variable B (its must be like this) , and if I do your actions in a separate table it works, and if I want it in the same table it causes disruptions, jumping numbers, etc. Is there an option to write a command that will work in the same table? Thank you very much in advance for the help ... View more

work perfect !!! thank_you!! ... View more

If it's easier for you, then there is an option like this:   a                     b 1                     5 2                     5 3                     5 4                     5 5                     5 1                     4 2                     4 3                     4 4                     4   i have a i need b thank you!!! ... View more

Hi first of all thank you very much Do you know how to do it by chance without BY? Because I write it inside an existing command and it doesn't accept BY on my value because it wasn't arranged before in this way. ... View more

Thanks, but that's still not what I meant. In your command between 5-7 he will put the value that was before -5 I want him to apply 6, a linear increase/decrease in this case an increase. ... View more

Actually yes, I would love an example. I'm new with sas, thank you very very 🙂 ... View more

I need the missing values to be automatically linear, for example everything between 1 and 12 should be 0.91   thanks evryone ; ... View more

I need the missing values to be automatically linear, for example everything between 3 and 6 should be 0.91               ... View more

Hi, first of all, thank you very much for your reply. I did not find a place that explains how to fill in the gaps with a linear change. In the examples you sent, I saw that they show how to return the previous figure, average, value 0, etc. Thanks, Ziv ... View more