topic Re: Removing Duplicate Column Values without removing the Row in SAS Procedures

Removing Duplicate Column Values without removing the Row

uselessprogress — Fri, 17 Apr 2015 13:01:30 GMT

I was wondering If there is a way to remove duplicate column values without removing the entire row. This is purely for formatting, and i'd just like to take a step out of my manual workflow.

Basically I'd like to turn this:

Location	Departments
Location 1	5400
Location 1	5401
Location 2	5402
Location 2	5403

Into this:

Location	Departments
Location 1	5400
	5401
Location 2	5402
	5403

Thanks.

Re: Removing Duplicate Column Values without removing the Row

Steelers_In_DC — Fri, 17 Apr 2015 18:38:18 GMT

Here you go:

data have;

infile cards dsd dlm=',';

length location $10.;

input Location $ Departments $;

cards;

Location 1,5400

Location 1,5401

Location 2,5402

Location 2,5403

;

run;

proc print data=have;id location;by location;

Re: Removing Duplicate Column Values without removing the Row

Cynthia_sas — Fri, 17 Apr 2015 19:06:45 GMT

Hi,

And, PROC REPORT will do this for you too.

cynthia

proc report data=have nowd;

column location departments;

define location / order;

define departments /display;

run;

Re: Removing Duplicate Column Values without removing the Row

Jagadishkatam — Sat, 18 Apr 2015 03:11:59 GMT

Alternatively you could achieve the same in a datastep by

data want;

set have;

by location;

if not first.location then location='';

run;

Thanks,

Jag