Urgent Help Needed: Proc Report

pihu_11 — Tue, 06 Aug 2013 22:13:09 GMT

Hi All,

I have SAS dataset that I'm converting into a .xml file using proc report n ODS.

There are 7 variables in that dataset and sorted in the order I need.

The group variable is var1 which has different values and each unique value has either 1,2 or more rows with different values of other variables (var5,var6,var7).

var2,3, and 4 will have same values for each group.

Problem: I need to display the variables Var1-4 only once for each group.

var1	var2	var3	var4	var5	var6	var7
a1	1	ht	4	444	ttgf	q1
a1	1	ht	4	453	f3rge	w1
a2	4	ht	22		dfewrt	a1
a3	545	cs	12		ffre	d1
a3	545	cs	12	425	fef	d1
a3	545	cs	12	234	f34	f1

This is what I require:

var1	var2	var3	var4	var5	var6	var7
a1	1	ht	4	444	ttgf	q1
				453	f3rge	w1
a2	4	ht	22		dfewrt	a1
a3	545	cs	12		ffre	d1
				425	fef	d1
				234	f34	f1

Which type of variable should be used in proc report for Var1-4?? Display? group? order?

Thanks

Pihu

Re: Urgent Help Needed: Proc Report

SASKiwi — Tue, 06 Aug 2013 23:01:34 GMT

Var1 to Var4 need to be defined as GROUP variables for the behaviour you want.

topic Urgent Help Needed: Proc Report in SAS Procedures

Urgent Help Needed: Proc Report

Re: Urgent Help Needed: Proc Report