Search results for query: *

Hi, I have a question of how to tackle following task: A string/word, e.g. ‘ABC’, needs to be displayed with all its permutations. So from ‘ABC’ it would get me ‘ABC’, ‘ACB’, ‘BAC’, BCA’, ‘CAB’, CBA’. What is the best way of doing that? I was thinking of an array holding four variables, one...

Hi all, I've solved it with a proc means. proc means data=data1 sum; var value; by id date; output out = hlp1 sum = result; run; Thanks anyway! Gingerfish

Hi all, I have a small problem which is holding me back and I cannot figure it out. In a dataset I need to calculate the sum of variable "value" and put the result in a new variable "result". The problem is, that the calculation needs to be done by id and date. Every id can have multiple...

Hi all, I solved it! :-D what I did is the following: proc sort data=x1; by id cycle h_day; run; data x2 (drop = _fd); set x1; retain _fd; if not missing(f_day) then _fd = f_day ; else f_day = _fd ; run; proc sort data = x2; by id cycle descending h_day; run; data x3...

Hi all, I am on this for some time now and don't know how to solve it. It is actually only a small part of a much bigger task, but I am stuck and cannot go further. I have quite a large dataset (ds) with around 40 variables. To every ID there are multiple cycles. In every cycle there are...