PROC SUMMARY DATA

[sanjaymane7]

Hi, I am using proc summary data statement where I don't want '_FREQ_ ','_TYPE_' and 'Total' (Blank) in output/ result.

received below result from SAS

TransactionId	_FRQ_	_TYPE_	COMMISSION
			100
A1234	0	1	80
B1234	0	1	20

Want result as per below 

TransactionId	COMMISSION
A1234	80
B1234	20

[PeterClemmensen · Accepted solution]

2 steps:

1. Use the nway option in the PROC Statement.

2. Drop the two variables from the output data.

See below

proc summary nway;
	/* other code */;
	output out = want(drop=_:);
run;

[sanjaymane7]

Thank you so much 🙂

[PeterClemmensen]

Anytime 🙂