Percentage out of two query results

[NareshAbburi]

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 · Accepted solution]

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;

[NareshAbburi]

Perfect. I appreciate it.

I need to learn complex joins like this.

[DBailey]

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;