topic Re: SAS Reporting based on column in ODS and Base Reporting

SAS Reporting based on column

Nishant_saxena — Mon, 10 Jul 2017 19:35:44 GMT

Hi all,

Please help me out with this simple logic

my data set is :

probablity champ date comment

100 xyz 08APR2012 deal closed

100 pqr 09MAY2013 deal closed

90 xyz 22JAN2011 not closed

80 xyz 20FEB2011 deal closed

and the desired output I want is like:

champ probablity date comment

xyz 100 08APR2012 deal closed

90 22JAN2011 not closed

80 20FEB2011 deal closed

pqr 100 09MAY2013 deal closed

Please help me out.

Thanks

Re: SAS Reporting based on column

Reeza — Mon, 10 Jul 2017 19:38:36 GMT

@Nishant_saxena wrote:

Hi all,

Please help me out with this simple logic

my data set is :

probablity champ date comment

100 xyz 08APR2012 deal closed

100 pqr 09MAY2013 deal closed

90 xyz 22JAN2011 not closed

80 xyz 20FEB2011 deal closed

and the desired output I want is like:

champ probablity date comment

xyz 100 08APR2012 deal closed

90 22JAN2011 not closed

80 20FEB2011 deal closed

pqr 100 09MAY2013 deal closed

Please help me out.

Thanks

PROC REPORT with a GROUP option for the CHAMP variable? I'm assuming you want a report in the SAS output. It's a listing report so it's pretty straighforward. If you're having issue with a specific component of PROC REPORT post what you have so far and what errors you're getting.

Re: SAS Reporting based on column

Astounding — Mon, 10 Jul 2017 19:45:28 GMT

Even a simple PROC PRINT can do the trick:

proc sort data=have;

by descending champ descending probability;

run;

proc print data=have;

by champ notsorted;

id champ;

var probability date comment;

run;