/*i have the following dataset.*/
data score;
input marks ;
datalines;
10
20
30
40
50
60
70
80
90
100
;
run;
Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150
and 2 to 6 i.e(20+30+40+50+60)=200
and 3 to 7 i.e(30+40+50+60+70)=250 and so on.
how to get it.
thanks in advance

Can we use where and having clauses in a single SAS program.
ex: proc sql;
select a,b,c from test
where state in 'KA'
and having .
Is the above program run correctly, if not why ?

how to add distinctly var variable values ex..
Data a;
input var;
datalines;
0
1
2
3
-1
-2
-3
;
run;
adding all +ve value in one varibale n do the same for -ve
too

Hello,
I have PROC SQLs results group by 3 fields and I use SUM and
COUNT functions in SQL. The problem is when I try to display
my result with PROC TABULATE. I am getting very big
numbers. I believe I make a mistake some where in Tabulate.
Here is my Proc Tabulate.
PROC TABULATE DATA=OUT04_05 FORMAT=12.;
CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE;
VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE;
TABLE CENTRE ALL, (YR ALL)*VISA,
(NEWUSER*F=COMMA12. AUTUSER*F=COMMA12.
FRAUD*F=COMMA12. TRANSFER*F=COMMA12.
REISSUE*F=COMMA12.) /
MISSTEXT={LABEL='0'} PRINTMISS RTS=20;
FORMAT VISA VISAFMT.;
KEYLABEL SUM = ' '
ALL = 'TOTAL';
LABEL YR = 'DATE YEAR'
NEWUSER = 'TOTAL NEW ACCT'
TRANSFER = 'TOTAL TRANSFER'
FRAUD = 'TOTAL FRAUD TRANSFER'
AUTUSER = 'TOTAL AUTH USERS'
REISSUE = 'TOTAL REISSUE';
When I code it like : NEWUSER*N*F=COMMA12.
AUTUSER*N*F=COMMA12.
I get same amount numbers but to find a NEWUSER I use
COUNT(*) and to find AUTUSER I use SUM(xxxx) function so
both result shouldn’t be the same my problem is in this
point.
Could you tell me where the problem in code is. How can I
display my result?
TX.

607

Describe a time when you were really stuck on a problem and
how you solved it?

732

Assuming {et} is randomly drawn from N(0,1) and e0 = 0,
generate 200 observations of
xt = et − 0.5e(t−1) and draw a line graph of xt.

291

hi all,
I need the SAS DI DUMP(A00 260) for attending the
certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

2788

How we can create SAS USER DEFINED CODE?

395

Hi all,
If Anybody has Advance SAS Certification dumps??? Please share
with me. Email: pramod.kalugade03@gmail.com

424

what is study design in while working with SAS? what are
screening variables in SAS?

474

What is a macro routine?

909

Describe a time when you were really stuck on a problem and
how you solved it?

832

Do you need to rearrange the order of the data for the report?

628

How do you convert basic cube to transaction cube and
transaction cube to basic cube?

501

What are the table names in oracle database...?

811

Can you suggest us materials for sdtm mapping?

2330

what is proc Index? and what is proc document?

474

How to import multiple xls files into sas. Out of those
files, how to get different values from a single variable
and how to find number of rows per value type?
We can do this using group by for one xls file with proc
sql. Was wondering how I can achieve this for multiple
files at the same time.
Any ideas?