I have a Dataset A and Dataset B and both data sets have only 1 variable, ID. I'm having a hard time trying to do this : (# of rows in Dataset A / # of rows in Dataset B) and then display that answer somehow. I've tried this but it takes way to long because it involves cartesian product join: proc sql; create table ppv as select count(a.ID)/count(b.ID) as ppv5 from DatasetA as a, DatasetB as b; quit; Overall I'm trying to program to calculate ppv after a model is generated.
... View more