SAS

sorting html tables
Hello, I;m looking for a complete example of a a sas program that creates an ODS HTML sortable table when clicking on the headers I have found some examples but they are quite unclear to me Regards Avi ... 31 May 2010 05:26

using array variables as part of call to macro function
Hi: I have a macro function called output that takes a dataset as argument and i have datasets: dataset_1a, dataset_2a, etc, and I want to call that macro with the corresponding dataset name and store the result as new variable in xx1. data xx; set xx1; array vars{3} (1,2,3); array chars{3}$ ('a','b','... 29 May 2010 02:48

Using LIFEREG estimates for CDF/PDF
Hi all: I am using LIFEREG to estimate the distribution of the maximum move in prices in a given interval (i.e. the largest positive price change in a week from the previous Friday close, using 2 years' data). Then I'd like to use the estimated distribution to forecast the distribution of the next week's extreme v... 28 May 2010 15:57

Permute rows and columns of a rectangular matrix according to similarity
Hi guys, I have a rectangular matrix, approximately 2000x500, of response times to test questions (actually the residuals after removing the row and column effects). I want to permute the rows and columns of the matrix so similar rows are adjacent and similar columns are adjacent. I don't have access to SAS/IML ... 28 May 2010 10:25

Looking for SAS job in Canada
Hi All, I am an experienced SAS programmer with 5 years SAS experience. I am familiar with Base, Macro, ODS, SAS/Graph, and etc. I will move to Canada in 2 months. Is there any open position in Canada? Please let me know if any information. My mail address: proc.canada(at)gmail.com -Kevin ... 20 Jun 2010 20:02

How to incorporate proc univariate into proc report
Hi, Is there anyway to incorporate the results of proc univariate , specifically, the output of signed rank test, into the DEFINE section of proc report. I have spent a lot of time in writing a proc report script that generates a colored HTML output, however, proc report does not calculate signed rank test. It wo... 27 May 2010 19:15

simple do loop question
Hi, I have a dataset A which stores the daily hours and completes for 20 weeks. Now I would like to calucate for the weekly cumulative cost by a certain day (cum_week_cost). For example, for week1, day2, the cum_week_cost will be Hours(day1_WEEK1+day2_WEEK1)devided by the Cost of (Day1_WEEK1+Day2_WEEK1) For week... 27 May 2010 18:09

Converting to dates
My data consist of dates: November09 November09 November09 December09 December09 December09 December09 When I data step through, how can I convert and sort by a date format data photos; infile 'blah.txt' dsd; length billDate 11.; input billDate mmddyy10. ; run; quit; ... 29 May 2010 21:11

Emailing .xls attachments with html body
Hello, I am having some trouble emailing an xls attachment. I am sending an email with the body in html with data output, but I also want to attach an xls file in case people want to manipulate the data. The xls file is being created fine, but when I attach it is gets appended as a text file with a .xls extens... 28 May 2010 03:55

Survival plot for models with time-dependent variables (proc phreg)
Hi all, I want to get the plots for a model that I estimated using proc tphreg (using v9.1.3). The model have a time-dependent variable. Can somebody suggest how this can be done ? The regular procedure of defining a covariate dataset with values specified, doesn't work in this case. Can this be modified in s... 27 May 2010 13:43