thank U very much!!! Only the first seed encountered is used to initialize that random number stream. Any additional seeds provided are ignored. to change streams, can use the CALL RANxxx versions of the random number generators. Message was edited by: sasJunior ... View more

My bad . Let me explain again.Changed the example to make it less confusing. ID Code seq_no1 Order1 Order2 First Name LAst Name 1 A 1 seq_no1 1 A 2 seq_no1 1 B 2 FirstName Last name John Well 1 B 1 First NAme Last name Aaron Hancock Since Order1=Seq_no1, all the observations with Code=A, should be ordered by seq_no_1.So this input data is alreayd sorted. Now since, Order1= First name , and Order2 = Last name, All the observations under Code=B should be first sorted on First names and then on last names. So irrespective of seq_no , all obs under cod=b should be sorted by NAmes. If I use code as below it will not work . Sel * from table... order by Order1 I am trying to use a dynamic Order by clause But I am getting an error. Other than changing the data type, is there a way around this? order by c.id, a.code, case when &ord1_by = 'SEQ_NO' then SEQ_NO when &ord1_by = 'PD' then PD end ; ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Result of WHEN clause 2 is not the same data type as the preceding results. Thanks! Message was edited by: sasnewbee ... View more

Hi Ksharp! Thanks for your input. Right now, when I am using just CATX, it will delete the all the messages in that id. So if id=1234 has greater than 32KB chars, the output does not have this id itself. So even if I use length(char) after CATX, I do not think it will work. Is there a way we can just pass the first 32KB chars instead of just not having taht id in the output. Thanks!! ... View more

Many thanks, Ksharp. I should've looked at the options in the first place. Yan ... View more

Volumes are relativley small 10 Branches and the daily data set will contain anything between 5 and 50 policies ... View more

Hi.. Use 2 title statements : ods tagsets.excelxp file='c:\temp\testtitle.xls' style=sasweb OPTIONS( embedded_titles='yes' embedded_footnotes='yes' Autofit_Height= 'YES' ); PROC REPORT DATA=sashelp.shoes NOWINDOWS CENTER; title1 "I.L.D INSURANCE CO. LTD "; title2 "BORDERAU FOR REINSURANCE FOR MARCH"; run; ods tagsets.excelxp close; ... View more

Here is the code I have written, detailing where I am running into problems, /** combine two age groups and calculate the percentage of the poverty level with the same data set**/ data pov4; set pov; if age = 'under12' or age = 'under18' then sum_value + fpl100; run; proc print data = pov4; title '5-18fpl100test'; run; /**this is the part that the sum is coming up incorrect**/ data pov5; set pov4; if age = 'under12' or age = 'under18' then sum_value + total; run; proc print data = pov5; title 'sumtotalof5-18poptest'; run; data pov6; set pov5; percent = sum_value + fpl100 / sum_value + total * 100; run; proc print data = pov6; title 'percentage of 5-17fpl100'; run; ... View more

Hi Steve, thanks for the response. Yes, we want 6000 individual regression equations. We want to classify each subject as either decreasing, increasing or stable over time but use a pooled variance because all the subjects are in the same area so we want them to "borrow" information from each other when we decide whether or not the observed trend is significant or not. The final result will be as simple as the number of subjects that are increasing, decreasing and stable. It may be clearer if I explain the context-- each subject is a lake area that has been measured over time. We have a lot of subjects but not many observations of each subject so we want to borrow power from having many subjects. We're interested to see whether or not the lakes are changing in size over time. The lakes are all from the same area and are subject to the same climatic fluctuations, but from the data they are not obviously correlated. The proc mixed approach gave us a global mean that tells us what is happening on average, but we found that at the level of individual lakes, the trend was often incorrect because it was being biased heavily towards the mean. We'd like to keep the regression fit for each lake but get a p-value that takes into account the all the subjects-- we're hoping that pooling the variance will get us a result like this. Hope that helps-- if you have a better suggestion for how we might achieve this and still use all the data we have then it would be great to hear it too. ... View more