hey guys, what does select *,do in the above example? Can someone please explain i mean i know about select var1,var2,..... from table or select*from table but i haven't seen this above before ... View more

yaa thanks ... View more

and the value of d was set to  missing from before already and that's way that change reflects in the last output too. Thank you both for lengthy bother ... View more

i could get the results using different methods but i wanted to understand how loop works with set and at the end i got stuck. ok,a not 999 so sas writes the observation same for b and c.Then d=999 so it gets set to missing and sas writes that observation too then when the loops checks for e,last element not 999 nothing changes and sas writes the 5th observation but with the missing value for d again.So it looked like the loop checked 10 20 30 . 50 for the value of d and not 10 20 30 999 50. Probably i am missing something huge about do loops and the output statement.                             1 10 20 30 999 50                             2 10 20 30 999 50                             3 10 20 30 999 50                             4 10 20 30  . 50                             5 10 20 30  . 50                             6 50 40 999 20 10                             7 50 40 999 20 10                             8 50 40  . 20 10                             9 50 40  . 20 10                            10 50 40  . 20 10                            11 . 1  1  1 999                            12 . 1  1  1 999                            13 . 1  1  1 999                            14 . 1  1  1 999                            15 . 1  1  1  . ... View more

i mean 10  20  30 999  50 or 10  20  30 .  50? ... View more

ok ,when the loop checks for x(5) or "e" he checks into 10  20  30 999  50 or into 10  20  30 0  50? ... View more

i changed the missing value to a "0" value and same scenario.So looks like for x(5) the loop checks the if statement against observation #4 not #1.Thank you guys ... View more

probably  a stupid question but otherwise if the observation is 10  20  30 999  50 and if statement not true then i dont see why x(4) would be till missing. ... View more

right right,x(5) was not changed i just made  a  typo posting my message ... View more

oh wait ,when the loop checks the if statement does it check it against the original observation or each time it checks it against the last observation written out? ... View more

i mean if x(5) =50 and not 999 does not that mean x(5)  is different then missing based on the if statement or does the missing values overrules the if statement? ... View more

i do get the right result without the "output" but i just wanted to play with it and understand it more.So i realize that once a value is set to missing it remains missing till the loop hits another observation  but it just did not make sense to me .Is this because of the "output" statement? ... View more

once the x(i) hits the missing value it never changes during each observation regardless of whether the if statement is true or not.Why is that so? ... View more

sorry,i dont understand ... View more