A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
%macro MACRO1; data _null_; set $indata1 $indata2; length dsin $16. dsout $17.; dsin='outdata.&outdata1; dsout='outdata.&outdata2; call symput("inset",dsin); call symput("outset",dsout); call execute('%MACRO2(&inset, &outset)'); run; %mend MACRO1; %macro MACRO2(dsin, dsout); data var5data; set &dsin; if car1||car2||car3 = car1a||car2a||car3a then do; Var5 = '1'; end; else if car1||car2 = car1a||car2a then do; Var5 = '3'; end; else if car1 = car1a then do; Var5 = '4'; end; else do; Var5 = '5'; end; output var5data; run; data counts (keep= Var1 Var2 Var3 Va4 Var5 Var6 Var7); length count1 count3 count4 count5 count_in count_out; retain count1 count3 count4 count5 count_in count_out; count_in = count_in +1; set var5data end=lastrec; if Var5 = '1' then count1+1; else if Var5 = '3' then count3+1; else if Var5 = '4' then count4+1; else if Var5 = '5' then count5+1; count_in= count_out+1; output; end; if lastrec then do; file process.log mod; put 'Assign Var5 value for &type'; put 'Total number of records with Var5 = 1: ' count1; put 'Total number of records with Var5 = 3: ' count3; put 'Total number of records with Var5 = 4: ' count4; put 'Total number of records with Var5 = 5: ' count5; put 'Total number of records read in: ' count_in; put 'Total number of records read out: ' count_out; put '*****************************************************'; put ' '; end; run; /* create the permanent dataset */ data &dsout; set counts; run; %mend MACRO2; /* Below macro calls the above macros according to value of TYPE */ %macro MAINMACRO; /* Run Program for TYPE */ %if "&type" = "typea " %then %do; %MACRO2("&indata1", "&outdata1", "&typea"); %end; %else %if "&type" = "typeb " %then %do; %MACRO2("&indata2", "&outdata2", "&typeb"); %end; %mend MAINMACRO; %MAINMACRO;
|what is the best Integrated development environment||2||35|
|Where to download python requests library||6||61|
|Getting Variable not defined error in Python||1||36|
|Options for Linking SQL tables to Access 2013||9||29|