Help using Base SAS procedures

Urgent Help Needed: Proc Report

Reply
Occasional Contributor
Posts: 9

Urgent Help Needed: Proc Report

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.

var1var2var3var4var5 var6var7
a11ht4444ttgfq1
a11ht4453f3rgew1
a24ht22dfewrta1
a3545cs12ffred1
a3545cs12425fefd1
a3545cs12234f34f1

This is what I require:

var1var2var3var4var5 var6var7
a11ht4444ttgfq1
453f3rgew1
a24ht22dfewrta1
a3545cs12ffred1
425fefd1
234f34f1

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

Thanks

Pihu

Super User
Posts: 3,260

Re: Urgent Help Needed: Proc Report

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

Ask a Question
Discussion stats
  • 1 reply
  • 146 views
  • 3 likes
  • 2 in conversation