topic Percentage out of two query results in SAS Data Management

Percentage out of two query results

NareshAbburi — Tue, 04 Nov 2014 15:42:12 GMT

Hi,

Can anyone help me to find a way to find the percentage out of two query results

I've below two queries. But I'm trying to find the Result_2ndQuery/Result_1st Query

PROC SQL;

SELECT COUNT(DISTINCT FILEID) FROM MTG.LOGFILE_WIS_FINAL_UI5_FINAL;

SELECT COUNT(DISTINCT FILEID) FROM MTG.LOGFILE_WIS_FINAL_UI5_FINAL WHERE ACTION_NICE = 'Open New Account' AND ACTION_COUNT >1;

RW9 — Tue, 04 Nov 2014 15:46:58 GMT

Something like:

proc sql;

create table WANT as

select COUNT(DISTINCT A.FILEID) as A_RESULT,

COUNT(DISTINCT B.FILEID) as B_RESULT,

CALCULATED A_RESULT / CALCULATED B_RESULT * 100 as PERCENT

from MTG.LOGFILE_WIS_FINAL_UI5_FINAL A

full join (select * from MTG.LOGFILE_WIS_FINAL_UI5_FINAL WHERE ACTION_NICE = 'Open New Account' AND ACTION_COUNT >1)

on /* not sure from your example what the linking items would be? */;

quit;

DBailey — Tue, 04 Nov 2014 15:48:30 GMT

proc sql;

select

count(distinct case when ACTION_NICE = 'Open New Account' AND ACTION_COUNT >1 then fileid end) / count(distinct fileid) as Pct

from

MTG.LOGFILE_WIS_FINAL_UI5_FINAL;

quit;

NareshAbburi — Tue, 04 Nov 2014 15:52:04 GMT

Perfect. I appreciate it.

I need to learn complex joins like this.