SAS

Count of distinct records using SQL
Hi, I want to find count of distinct records for a dataset based on some conditions and used the syntax "Select count(distinct *)" but SAS doesnt seem to like it? Proc SQL; 16 Select count(distinct *) as CntDisSalesTransactions 17 from ProjRaw.Sales (keep = ID PURCHASE_DATE SKU) 18 wh... 28 Aug 2007 15:58

Error in Importing
I think there is a error in your LIBNAME! How does it look like? Do you have some special chars in there? Where do the parts of the libname come from? Gerhard On Wed, 22 Aug 2007 10:44:16 +0300, Richie N.M. <sas.kenya(a)GMAIL.COM> wrote: Hi All, I get this error ERROR: Connect: ERROR: ... 22 Aug 2007 21:57

help with plotting confidence intervals on the Kaplan-Meier survival curve
Hello Everyone; I am trying to plot the survival and the confidence intervals( lower and upper) for each treatment group at different time points. When I try to use the overlay for this situation, I get a warning: WARNING: OVERLAY option specified conflicts with Y*X=Z type plot request. OVERLAY option ignored. ... 9 Aug 2007 03:38

Second label on Gplot
Is this what you are looking for? axis1 label=(a=90 j=c 'This is line one' j=c 'This is line two'); axis2 label=(j=c 'This is line one' j=c 'This is line two'); proc gplot data=sashelp.class; plot weight * height / vaxis=axis1 haxis=axis2; run; On 8/6/07, Wu Consulting <wuconsulting2(a)hotmail.com> wrot... 6 Aug 2007 18:57

PROC GENMOD: Specifying the Working Correlation Matrix for
Hello Everyone, I'm running some GEE models using PROC GENMOD. My criterion variables consist of repeated lipid measures (cholesterol, triglycrides, total cholesterol to hdl ratio) from a sample of HIV patients. Values for each criterion are coded as 0 for normal and 1 for elevated. Lipids in HIV patients are ofte... 1 Aug 2007 12:21

Tchebysheff's theorem
Kevin, Take a look at: http://math.cudenver.edu/~ssain/prob/lec13.pdf HTH, Art --------- On Fri, 27 Jul 2007 16:53:03 -0400, Kevin Roland Viel <kviel(a)EMORY.EDU> wrote: In the proof of Tchebysheff's theorem, I would like to derive: (y-mu)^2 >= k^2 sigma^2 mu = mean sigma^2 = variance ... 28 Jul 2007 16:59

A simple MACRO question:
John , Throw us a bone and show the error from the log. Toby Dunn If anything simply cannot go wrong, it will anyway. Murphys Law #2. The buddy system is essential to your survival; it gives the enemy somebody else to shoot at. Murphys Law # Tell a man there are 300 billion stars in the univer... 26 Jul 2007 12:20

Conditional Footnotes-PROC REPORT
You need to create a variable, assign the text that you want, and then use the line statement to put that variable. So in your case, compute after grp; line1 $ 40; if grp=1 then line1 = "age=50-60"; else if grp=2 then line1 = "age=70-80"; line @40 line1; endcomp; Carol Bristow 1655 N Fort Myer Dr S... 25 Jul 2007 16:59

Diffplots don't show in GLIMMIX
There are 3 computers in a common computer room that have SAS 9.1.3. I would like these computers to show diffplots for all users. When I log in as a user, i am able to see diffplots from PROC GLIMMIX. However, when other users log in, they cannot see diffplots. Additionally, when i log in with my admin account... 9 Jul 2007 14:26

Panel Fixed Effects
Hello, I just ran a single-equation panel model (N=50, T=180) with TSCSREG. I received the following note for both the fixone and the fixtwo options (i.e. one-way and two-way fixed effects models): "NOTE: The transformed regression does not have full rank. User should be aware of possible multicollinearity an... 4 Jul 2007 14:35