23-Jul-2018, 05:23 PM
Hi manish,
please help me... in need to count status in Active & Inactive in columns.
please find attached csv file & code.
regards,
Satendra kumar
please help me... in need to count status in Active & Inactive in columns.
please find attached csv file & code.
Code:
%Macro SUMMARY;
libname SAS 'E:\Proportionate Billing Data Summary\Summary_Data';
Data SAS.Final_summary_july18_done;
Set SAS.Final_summary_july18;
Format ddate YYMMDD10.;
%let A = 0 ;
%let IN = 0 ;
%Do I = 1 %to 30 %by 1;
%If AccountStatus&I. = 'Active' %then
%Let A = %Eval(&A +1) ;
%If AccountStatus&I. = 'Inactive' %then
%Let IN = %Eval(&IN +1) ;
%End
ACTIVE = &A.;
output;
INACTIVE = &IN.;
output;
RUN;
%Mend;
%SUMMARY;
Satendra kumar