Removing Duplicate Column Values without removing the Row

[uselessprogress]

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.

[Steelers_In_DC]

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;

[Cynthia_sas]

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;

[Jagadishkatam]

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