topic Re: Can any one help me? in SAS Programming

Can any one help me?

sravanpathu — Sat, 05 Jan 2013 11:17:55 GMT

Dear All,

I had following dataset

A B

a 1

b 2

I need to convert the data set into following dataset in single step

A B

a 1

b 2

k 3

k is combination of a and b. 3 is sum of 1+2

Re: Can any one help me?

MohammadFayaz — Sat, 05 Jan 2013 12:37:20 GMT

Why do you want add them up there?

It is better to put summary statistics in another data set.( using proc means)

But, OK, the following code is what you want:

proc report data = test out=test_out nowd;

col A B ;

rbreak after / summarize;

run;

For details, see

Proc Report Statement , SAS Institute

Re: Can any one help me?

Linlin — Sat, 05 Jan 2013 13:25:04 GMT

data have;

input A$ B;

cards;

a 1

b 2

;

data want;

set have end=last;

output;

t+b;

if last then do;

b=t;a='k';

output;end;

drop t;

proc print;run;

Re: Can any one help me?

sravanpathu — Sat, 05 Jan 2013 13:31:36 GMT

Thanks alot ma'am

Can we do same in PROC SQL

Re: Can any one help me?

Linlin — Sat, 05 Jan 2013 13:46:32 GMT

You are welcome!

Proc sql also works:

data have;

input A$ B;

cards;

a 1

b 2

;

proc sql;

create table want as

select * from have

union

select * from (select 'k' as a1,sum(b) as b1 from have);

quit;

proc print;run;

Re: Can any one help me?

PGStats — Sat, 05 Jan 2013 16:14:22 GMT

I'm curious, in what way is 'k' a combination of 'a' and 'b'?