Thats right ... View more

Thank you for your reply. I am talking about adding data validation list for a perticular cell. ... View more

I will have to create more than 4000 datasets which is am already doing and its taking lot of time to process. ... View more

Hi , I have lot of records in the dataset not just 3. It will take lot of time to process if i write a macro to subset these. Is there a way i can do it in one step.   Thank you, ... View more

  Can you help me in solving problem below. I am providing here the appropriate ancestor for each of the record.  I need to find this ancestor for each of the record by user. Can you please help.   data a;       user=1; base=4.1; cur=4.2; output; /* 4.1 to 4.2 - Ancestor here is 4.4 */       user=1; base=4.2; cur=4.4; output; /* 4.2 to 4.4 - Ancestor here is 4.4 */       user=1; base=4.6; cur=5.5; output; /* 4.6 to 5.5 - Ancestor here is 6.1 */      user=1; base=5.5; cur=6.1; output; /* 5.5 to 6.1 - Ancestor here is 6.1 */             user=2; base=4.2; cur=4.6; output; /* 4.2 to 4.6 - Ancestor here is 6.1 */       user=2; base=4.6; cur=5.5; output; /* 4.6 to 5.5 - Ancestor here is 6.1 */       user=2; base=5.5; cur=6.1; output;  /* 5.0 to 6.1 - Ancestor here is 6.1 */         user=3; base=4.0; cur=4.2; output; /* 4.0 to 4.2 - Ancestor here is 5.5 */       user=3; base=4.2; cur=4.6; output; /* 4.2 to 4.6 - Ancestor here is 5.5 */       user=3; base=4.6; cur=5.5; output; /* 4.6 to 6.1 - Ancestor here is 5.5 */ run;     I am able to achieve this if there is only one user in the dataset using code below. But its not working if there are more than one user.     data _tmp1(rename=(base=base1 cur=cur1));       set a; run;   **Repeat the training module for each of the delta version between base and current module; data _tmp2;       retain base cur;       set _tmp1; by u;         cur = cur1;       base = base1;       output;               drop base1 cur1 i; run;                                  **Get all the base version for the current modue which has training then need to check the       corresponding base version full access; data _lineage;       set _tmp2;  by u;          array hist(6);             count=1;                          hist(count)=base;                         do i=1 to last while (count<dim(hist)-1);                                                                                                set _tmp2(rename=(base=base1 cur=cur1)) nobs=last point=i;       if cur=base1 then do;         count+1;                            hist(count)=base1;         base=base1;         cur=cur1;                             i=1;       end;       end;                       count+1;       hist(count)=cur;       ancest = cur; run;       ... View more

Thank you.. I am able to solve this issue with another approach. Thanks for all your help ... View more

Thank you very much. Its kind of working. But I need to output this based on value a and c. In this case the variable value for a is 1 and c is 5.5.   data a; a=1; b=5.1; c=5.5; output; a=1; b=5.2; c=5.5; output; a=1; b=5.0; c=5.2; output; a=1; b=4.7; c=5.0; output; a=1; b=4.6; c=5.2; output; a=1; b=.; c=4.6; output;   a=2; b=5.4; c=6.1; output; a=2; b=5.3; c=6.1; output; a=2; b=5.0; c=5.3; output; a=2; b=4.7; c=5.0; output; a=2; b=4.5; c=4.7; output; run;   For the second set of record where a=2 and lets say value c is 6.1 the children output must be as below 5.4 4.5  Only these two do not have children.   I am sorry for not mentioning this case earlier.   run; ... View more

I this case the output will be    new variable 5.1 4.7 4.6  All this do not have any child nodes or children for the ancestor or parent 5.5.   Basically when user asks variable c with value 5.5 then output should be look like above.  Steps are  1. The program reads c variable where value is 5.5 and then looks for the children which is variable b and the values are 5.1 and 5.2 2. For each of b value which is 5.1 and 5.2 the program looks for children and their children are for 5.1 no children so it will appear in the report and 5.2 has children 5.0... and it goes on for all the childrens... ... View more

Thank you all. I am able to do this using findc function. ... View more