It is not just lines 7-8-9 it is the whole program,  You need someone with logic ability to do this simple steps.  We do not sum then set the sum to 0 then re-sum the same variables.  That just doesn't make since. 12-13-14 and 17-18-19 and so on in the log.   The cost of hiring someone with logic ability should not be that hard nor costly.    ... View more

@wagdy  how many records do you think you should have?   129   DATA XXX.YAYA; 130   MERGE XXX.orignal4 XXX.KARIMI2; BY SS_; RUN;   NOTE: There were 856 observations read from the data set XXX.ORIGNAL4. NOTE: There were 388 observations read from the data set XXX.KARIMI2.   NOTE: The data set XXX.YAYA has 857 observations and 402 variables. try this is that what you are expecting?   DATA XXX.YAYA; MERGE XXX.orignal4 (in=ina) XXX.KARIMI2; BY SS_; if ina; RUN;   I don't think you want to do this but if you are just trying to stack the 2 datasets together  data xxx.yaya; set xxx.orignal4 xxx.karimi2; run; proc sort data=xxx.yaya; by SS_; run;   ... View more

please post sample data in the form of a datastep with datalines that represents what you have and want you want. include as many examples that show differences in the date problem you are trying to solve. Thank you.   ... View more

Not knowing the policies of you servers, one reason is that those tables could be restricted to your access level, or they could be lookup tables containing meta data for the server.   you should ask your servers admin why you don't have access to them to confirm if you should have access to the tables.   ... View more

based on the 2 samples that @Matos has provided I do not see any relationship in the samples.  My reasoning is because A is a child to E in sample one, then in sample 2 E is the child to A.  If A is representing the same company in both samples then maybe you want to rethink the process and setup multipedal formats that you would call append based on the incoming dataset. ... View more

If your problem has been solved please mark the solution that applies. Thank You.  ... View more

How does interval get assigned?  your sample reflects that interval is char based on the sample being left justified. ... View more

looking at your hierarchical order company ownership has nothing to do with the decision making process.   if company = 'E' then hierarchical_order = 1; else if company in ('A','C','G') then hierarchical_order = 2; else if company in ('B','H') then hierarchical_order = 3; else if company in ('D','F'') then hierarchical_order = 4; else if company in ('J','I') then hierarchical_order = 5;  else hierarchical_order = .;    You could also use a format statement to assign the hierarchical_order ... View more

because of the by 3 statement.   change the by 3 to by 2 and it may make since to you.  Put a debugger into the datastep maybe like this. data WORK.LOOP / debug; X = 0; do Index = 1 to 5 by 3; X = Index; end; run; then try this data WORK.LOOP / debug; X = 0; do Index = 1 to 5 by 2; X = Index; end; run; ... View more