SAS

sum by every n rows.
Hi, Could anyone help me on summing following dataset ? I have n, x variables and would like to calculate for sum by every 2 rows . n x sum_by_every_2_rows 1 -1 2 -50 -51 3 -2 4 -1 -3 5 1 6 -1 0 7 3 8 2 5 9 2 10 -2 0 11 1 12 2 3 13 5 14 40 45 15 30 16 39 69 17 -2 -2 Thanks, db ... 4 Mar 2010 15:48

hwo to pull years of data..
did you mean pool or subset? What is the analysis/hypothesis you are aiming at? Eli ... 11 Mar 2010 17:59

hwo to pull years of data..
Hi All, Can any one please tell me... how can I pull say 4 years of data from master data (this contains 10 yrs of data). I am planning to pull the data past 4 years starting from last month JAN2010. Cheers, ... 4 Mar 2010 01:15

Regarding Graph output
Dear all, I am creating graphs of change from baseline of mean scores by visits. In my output I am getting some reverse bars as the mean change is negative. Is there any way to get all of them upward? I used order=(-25 to 50 by 5). But its not giving expected result. And also is there any way to get the mean chang... 3 Mar 2010 23:05

importing from Excel
I use the code below and get error in log. PROC IMPORT OUT=WORK.laptopdata DATAFILE = "C:\laptop_review.xls" DBMS=EXCEL REPLACE; RANGE="Review$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; proc print data = laptopdata; RUN; The ... 4 Mar 2010 12:19

Can ODS create Excel output?
I've been using code like ODS MSOFFICE2K file="...xls"; to produce output to read into Excel. However, this produces html output. Excel can read this, but it leads to all sorts of problems when linking (I get lots of 'cannot update links' messages in Excel). Can ODS produce proper Excel files? ... 3 Mar 2010 23:05

check for variable existence, if not there put variable in.
You can always put if missing(var) then call missing(var); which is sort of cheating but works fine iff var is numeric... Or just give the variable a format and/or length - that will initialize the variable if it's not in existence at that point. -Joe On Wed, Mar 3, 2010 at 3:32 PM, Catima Potter <cpotter@k... 4 Mar 2010 10:03

check for variable existence, if not there put variable in.
Hello, I am writing code where I need to see if a variable exists in the dataset. If it is not there, then I would like to include it with a value of . (missing). I have tried this code but when the variable does exists, it is overwriting the values to missing. Your assistance is greatly appreciated. ~Catima ... 3 Mar 2010 17:32

Suppress Borders in ODS Tagsets ExceXP
/* Subject: Re: Suppress Borders in ODS Tagsets ExceXP? You can try style=minimal, though from what i've seen that can cause some interesting bugs in the output.<< Thanks. That's an improvement, although one thing it still leave in are the borders! --Dav david.a.vandenbroucke(a)hud.gov */ *... 3 Mar 2010 17:32

A Data manipulation question - SORRY STAT personal has changed
Sorry Stat changed it's mind. So I will need help on the following. I have a following dataset with variables -Problem,subject, cycle, dchange . Problem subject cycle dchange ------ ------- ----- ---- pain 1001 1 0 1001 2 0 ... 3 Mar 2010 16:24