auto increment data new; input id transaction \$; datalines; 101 x 101 a 101 s 102 w 102 e 103 f 104 f 105 g 105 h 108 q 108 w 108 f ; run; this is the data set and i need 1st 2 transaction from every id for the whole data..using sas or procsql ... 12 Jul 2010 11:48 Need to find a value that can make the equation's value = 0 like Solver in Excel Hi dear all, I am looking for any function I can use to solve the following equation: Mi,t  Bi,t  (ROEi,t+1  Ri)*Bi,t/(1+Ri) - (ROEi,t+2  Ri)*Bi,t+1/ (1+Ri)^2 - (ROEi,t+3  Ri)*Bi,t+2/(1+Ri)^3 = 0 I have all values except Ri which is the value I want to find to make this equation = 0. i refers to fi... 11 Jul 2010 20:27 ODF RTF output and issues with Word Hi there, I am generating hundreds of documents with output in Word so that staff can add comments. However, in some cases people are having issues saving and updating. We use Office 2007 but my ODS RTF statements save to .doc files. Should I change the code to .docx? Thanks for the help. Paula ... 9 Jul 2010 20:32 proc report - general strategy - rows and conditional formatting Hi All, I'm trying to use PROC REPORT to create a complex report using already summarized input data (example code and data, links to reports belwo). The general problem is that most of the control in PROC REPORT is focused on COLUMNS, whereas I also need absolute control over ROWS. For example, I'd like to format ... 12 Jul 2010 19:37 title statement in proc print Please help me in solving this question Data work.one; a = 10; run; proc print data = work.one; title1 ..; title2 ..; run; However, title1 should be, Hello World (There are 15 spaces between the word Hello and World) Title2 should be, Hello World (Ther... 9 Jul 2010 11:38 Difference between QUIT and RUN Hello, people! I'm quite new to SAS programming, and recently were surprised by some inconsistency in SAS proc calls. Some of them (like PROC DATASETS or PROC SQL) seem to require QUIT instead of usual RUN. Is this the matter of some sense or just an ugly SAS programming language implementation? ... 9 Jul 2010 16:05 Expand Results Tree Hi All, I am trying to 'expand' the results tree in the Results window so that I don't have to 'drill' down and THEN click on the result table or chart that I would like to see. I know there is a way to do this because I have done it before with the help of SAS support but do not remember... Any ideas, Cheers... 12 Jul 2010 15:09 functions and PROCs Hi All, Can somebody explain me the difference between functions and PROCs that calculate the same simple descriptive statistics? Thanks ... 8 Jul 2010 15:51 ETS Time Series log messages I can get an html graph on plot of my Actural vales but does not seem to give me a forecast graph which is what I am looking for I am using Enterprise Guide...can anyone give me some insight as to what my notes are telling me and how I could get a forecast graph? 7 ODS _ALL_ CLOSE; 8 ODS PRO... 9 Jul 2010 03:59 binomial function in proc model Hi All, Can anyone tell me the right way to use binomial function in proc model? The following did not work for me. data s; _name_ = "z"; z = 1; y = .5; /* first row */ output; _name_ = "y"; z = .5; y = 1; /* Second row */ output; run; data all ; y = 0 ; ... 8 Jul 2010 13:37