Search
 
 

Display results as :
 


Rechercher Advanced Search

Keywords

Affiliates
free forum


Average of Last three visit of each subject

View previous topic View next topic Go down

Average of Last three visit of each subject

Post  pallav on Wed Sep 12, 2012 11:22 am

Here is the data for which I want an average for last three visit for each subject


DATA TEST;
INPUT SUBJECT $ VISIT;
DATALINES;
E101 10
E101 10
E101 20
E101 30
E102 10
E102 20
E102 30
E103 10
E103 10
E103 20
E103 20
E103 40
E103 40
E103 50
;
RUN;

Desire output



Obs SUBJECT visit

1 E101 20.0000
2 E102 20.0000
3 E103 43.3333


Please reply with your answers.....

Thanks

pallav

Posts : 98
Join date : 2012-03-14
Location : Ahmedabad

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum