Help using Base SAS procedures

proc report default for numeric values

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

proc report default for numeric values

HI I know the default for data set contains only numeric values is a one-line summary. I don't like it. How can I change it?

That is I want the full observations report.


Accepted Solutions
Solution
2 weeks ago
Super User
Super User
Posts: 9,599

Re: proc report default for numeric values

Posted in reply to walterwang

The default for SAS when all numeric is to set them as summary.  You can change this by adding the word display to your define commands:

data have;
  a=1;
  b=2;
  output;
  a=4;
  b=1;
  output;
run;
proc report data=have nowd;
  columns _all_;
  define a / display 'test';
  define b / display 'test2';
run;

View solution in original post


All Replies
Solution
2 weeks ago
Super User
Super User
Posts: 9,599

Re: proc report default for numeric values

Posted in reply to walterwang

The default for SAS when all numeric is to set them as summary.  You can change this by adding the word display to your define commands:

data have;
  a=1;
  b=2;
  output;
  a=4;
  b=1;
  output;
run;
proc report data=have nowd;
  columns _all_;
  define a / display 'test';
  define b / display 'test2';
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 65 views
  • 0 likes
  • 2 in conversation