topic Division on obseravations in SAS Programming

Division on obseravations

Hima — Wed, 02 May 2012 19:34:29 GMT

Input:

PROMOTION TOTALS

TOTAL RECORDS 3,329

TOTAL RECORDS ACCEPTED 3,089

TOTAL RECORDS REJECTED 240

Output:

PROMOTION TOTALS

TOTAL RECORDS 3,329

TOTAL RECORDS ACCEPTED 3,089

TOTAL RECORDS REJECTED 240

Ratio 240/3089

Re: Division on obseravations

Reeza — Wed, 02 May 2012 20:20:42 GMT

data have;

input promotion totals;

cards;

1 3329

2 3089

3 240

;

data want;

set have end=eof;

output;

prev_total=lag(totals);

if eof then do ;

promotion=4;

totals=totals/prev_total;

output;

end;

run;

proc print data=want;run;

Re: Division on obseravations

Haikuo — Wed, 02 May 2012 22:34:52 GMT

Or this:

data have;

input (PROMOTION TOTALS) (:$&30.);

cards;

TOTAL RECORDS 3,329

TOTAL RECORDS ACCEPTED 3,089

TOTAL RECORDS REJECTED 240

;

data want (drop=_:);

set have end=last;

_c=input(lag(totals),comma7.);

output;

if last then do;

totals=catx('/', totals,_c);

promotion='Ratio';

output;

end;

run;

proc print;run;

Regards,

Haikuo

Re: Division on obseravations

shivas — Thu, 03 May 2012 14:38:06 GMT

Hi,

Try this...

data have;

input PROMOTION $25. TOTALS ;

cards;

TOTAL RECORDS 3329

TOTAL RECORDS ACCEPTED 3089

TOTAL RECORDS REJECTED 240

;

proc transpose data=have out=test;

id promotion;

var totals;

run;

data final;

set test;

Ratio=TOTAL_RECORDS_REJECTED/TOTAL_RECORDS_ACCEPTED;

run;

proc transpose data=final out=tt;

run;

Thanks,

Shiva