here i can write the code using PROC SQL; plz ans in DATA STEP; proc sq

calculate the sum of value using only DATA STEP.
data count_;
input year name $ value;
cards;
2006 xxx 10
2007 yyy 12
2006 xxx 20
2008 yyy 15
2007 xxx 15
;

out put should be like this
year name T_value
-----------------------
2006 xxx 30
2007 xxx 15
2007 yyy 12
2008 xxx 15

Question Posted / xxx

6 Answers
8237 Views
I also Faced
E-Mail Answers

Answer Posted / xxx

here i can write the code using PROC SQL;
plz ans in DATA STEP;

proc sql;
select year,name, sum(value)as T_value from count_ group by
year, name having sum(value) order by name;
quit;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain proc univariate?

979

Have you ever used the SAS Debugger?

1701

What is the work of tranwrd function?

1189

What is the use of divide function?

1021

how can you create zero observation dataset? : Sas programming

1097

Explain the difference between using drop = data set option in set and data statement?

1116

What do you know about sas data set?

1037

what is null hypothesis? why do you consider that?

2855

What do the mod and int function do? : Sas programming

1142

what are the types of interactive display types? : Sas-bi

1045

explain what is factor analysis? : Sas-administrator

1054

what is hash files in sas and why we are using this one in sas?

2162

explain the use of % includes a statement in sas? : Sas-administrator

953

Explain bmdp procedure?

993

what is sas business intelligence? : Sas-bi

1107