01-01-2016 11:47 PM
i have aa data set
name rating post;
a 2 ASE
b 3 ASE
c 4 ITA
d 5 ITA
e 2 VP
f 7 Vp
want to knw the rating of each person out of whole rating and performed the following query
select first_name,(calculated rating/r) from pawan.test,(select sum(rating) as r from pawan.test1);
ERROR: It appears that the CALCULATED variable rating was referenced before it was defined.
ERROR: The following columns were not found in the contributing tables: post.
ERROR: The following columns were not found as CALCULATED references in the immediate query: rating.
01-02-2016 12:31 AM
I suspect that what you need is not SQL but proc rank:
data have; length name $12 rating 8 post $12; input name rating post; cards; a 2 ASE b 3 ASE c 4 ITA d 5 ITA e 2 VP f 7 Vp ; proc rank data=have out=want ties=dense; var rating; ranks ratingRank; run; proc print data=want noobs; run;
if not, tell us what you expect as a result.