data abc; set xyz; count=1; length Distance$ 10; if mails<=50 then D

I Have A Table Like This.

Cityno Cityname Mails
1 Bangalore 8km
2 Hsr Layout 20km
3 Mejistic 30km
4 Jayadeva 55km
5 Itpl 80km
6 Hebbal 115km

I Have Data Like This

I Want O/p Like This
Distance No.ofcity
0-50km 3
51-100km 2
101-150km 4

And So On

Question Posted / anil

6 Answers
13278 Views
DELL, HCL, Oracle, I also Faced
E-Mail Answers

Answer Posted / anil

data abc;
set xyz;
count=1;
length Distance$ 10;
if mails<=50 then Distance='0-50';
else if 50 < mails <= 100 then Distance='51-100';
else if 100<mails <= 150 then Distance='101-150';
run;
proc print;
run;

proc sql;
select Distance,sum(count)as NO_OFCITY
from abc
group by Distance;
quit;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does pl sql work in mysql?

980

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

What is the reports view in oracle sql developer?

991

Can we use ddl statements in stored procedure?

1154

Define commit?

1003

What is sql query limit?

978

Is sql easier than java?

1016

Which join is like an inner join?

1027

What are the different sql commands?

1073

How long does it take to learn pl sql?

1061

Can a trigger call a stored procedure?

1070

What is latest version of sql?

1044

Which version of sql do I have?

1056

Explain select statements in sql?

1056

how to get help information from the server? : Sql dba

940