topic How to create an additional record by adding values of two records in SAS Programming

How to create an additional record by adding values of two records

knveraraju91 — Tue, 29 Sep 2020 05:44:04 GMT

Dear,

I need to create an additional record with sum values of two records. In the below output i need to create the red highlighted record.


data one;
input val$ n1 n2 total;
datalines;
cr 10 12 22 
pr 12 23 35
sd 23 24 47
ne 30 35 65
;

Please suggest.

output needed:

val n1 n2 total

cr 10 12 22
pr 12 23 35

cr/pr 22 35 57
sd 23 24 47
ne 30 35 65

Re: How to create an additional record by adding values of two records

Kurt_Bremser — Tue, 29 Sep 2020 06:19:10 GMT

What is the rule that identifies the observations that need to be added? Is it only the position in the dataset?

Re: How to create an additional record by adding values of two records

knveraraju91 — Thu, 01 Oct 2020 03:59:40 GMT

In my dataset there are only 4 obs. I need to add records with val in(cr,pr) and create new variable cr/pr. Thank you. Please suggest

Re: How to create an additional record by adding values of two records

jimbarbour — Thu, 01 Oct 2020 05:10:45 GMT

This isn't particularly elegant, but it will do the job if what you've posted is literally all you want.

data one;
	DROP	_:;
	RETAIN	_CR	0;
	RETAIN	_CR_n1;
	RETAIN	_CR_n2;
	RETAIN	_CR_Total;

	INPUT	val$ n1 n2 total;

	if	 Val			=	'cr'	THEN
		DO;
			_CR			=	1;
			_CR_n1		=	n1;
			_CR_n2		=	n2;
			_CR_Total	=	Total;
		END;

	if	 Val			=	'pr'	THEN
		_PR				=	1;

	IF	_CR	AND	_PR			THEN
		DO;
			OUTPUT;
			Val			=	'cr/pr';
			n1			=	n1	+	_CR_n1;
			n2			=	n2	+	_CR_n2;
			Total		=	Total	+	_CR_Total;
			OUTPUT;
		END;
	ELSE
		DO;
			OUTPUT;
		END;

datalines;
cr 10 12 22 
pr 12 23 35
sd 23 24 47
ne 30 35 65
;
RUN;

Results:

If that's really all you need, please mark the solution; otherwise, please post more including more extensive data.

Jim

Re: How to create an additional record by adding values of two records

Kurt_Bremser — Thu, 01 Oct 2020 05:11:36 GMT

data want:
set have;
_n1 + n1;
_n2 + n2;
output;
if _n_ = 2
then do;
  val = "cr/pr";
  n1 = _n1;
  n2 = _n2;
  total = n1 + n2;
  output;
end;
drop _:;
run;

Untested, posted from my tablet.