SAS

lag calculation macro
Has anyone else struggled with the lag function in SAS? The lag function often doesn't work in an intuitive manner in conditional statements, or if missing values are involved. Anyways, I wrote a short macro code to handle lag calculations which I'd like to share. It works fairly well, although I may be reinventi... 3 Feb 2010 12:50

PROC MIXED for non-normal data
Hello all, Can one use PROC MIXED on non-normally distributed data? I have heard it is robust to the assumptions. If so, are there any references in literature that support this? My dataset consist of body temperatures measured hourly across +-10 sequential days during summer, autumn, winter and spring. I us... 4 Feb 2010 02:17

Making a table of % of missing values for several variables
Hi I have a dataset with 50 character variables (SNP1 - SNP50), each of which have a certain amount of missing data. I want to create a table that will give me the percentage of missing data per variable. Maybe something like this: VARIABLE N %MISSING SNP1 2010 2.6% .... 3 Feb 2010 14:00

Urgent Position: (JMP/SAS Expert), San Jose CA 6 months Contract
Position: SAS Expert Location: San Jose CA Length: 6 Months Start: ASAP 3 years linkage/correlation analysis experience. Needs to be an expert on JMP or SAS statistical software applications. Statistics Master's degree or above preferred. Six sigma black belt preferred. Familiar with Cisco hardware metric... 2 Feb 2010 22:00

Compare adj-R2
Since you are fitting the same model to different data sets, there doesn't seem to me to be a reason to compare adjusted R2. You could compare the R2. A simple approach is to just look at the significance of the F test for the regression, as the Fvalue is equal to (R2 divided by the number of regressors) in turn divi... 2 Feb 2010 22:00

Zip to Congressional District?
All: I need some help. Is there a SAS function or easy procedure for converting Zip Codes to its corresponding Congressional District? Any help or advice would be greatly appreciated as I am not sure where else to go at this point... Thanks! ... 3 Feb 2010 01:49

variable week
I want to create a binary variable which equals 1 if the date is the week (between Monday and Friday) and 0 if it's the weekend (Saturday or Sunday) from a variable date MMDDYY10. ... 2 Feb 2010 22:00

U-codes for Greek letters in SAS 9.2
Hi Joakim, Have not tried these U codings in 9.2 Windows. see http://homepage.mac.com/magdelina/.Public/utl.html http://tiny.cc/q0cda utl_tipweb.txt for a cleaner version see /* T000960 ALL THE USEFUL RTF CONTROL SEQUENCES */ %Let Lele=%Str («); %Let Degr=%Str (°); %Let PlMi=%Str (±); %Let Su... 3 Feb 2010 11:42

Modify cdfplot generated in Proc Univariate cdfplot statement?
According to this: http://support.sas.com/documentation/cdl/en/procstat/63032/HTML/default/proc stat_univariate_sect010.htm haxis= options should be able to control the haxis scale, but I tried and it didn't work. I do notice the following warning: WARNING: ODS Graphics is experimental in this release of the... 2 Feb 2010 15:33

U-codes for Greek letters in SAS 9.2
Hi, In SAS 9.1, I used the code t=A4{sub =BD=A4\u955-z}(h) (where =A4 is the od= s escapechar) to get a subscripted "lambda". I've found that this code doesn'= t work in SAS 9.2. I can get the lambda sign, but not if it's subscripted lik= e this. Anyone has a remedy? KR, Joakim ... 2 Feb 2010 15:33