I have a problem with the output of proc freq. I probably changed its base format somehow, how can I return it?
No I see outpt like this:
But i want to see it like in base format with all descriptions and additional information box:
Thank you in advance for your help!
I have a problem with the output of proc freq. I probably changed its base format somehow, how can I return it?
No I see outpt like this:
But i want to see it like in base format with all descriptions.
Thank you in advance for your help!
I don't know what you mean by "Base format". Please show us an example.
Is this using SAS Visual Analytics or SAS Studio? You've posted this question under VA.
Assuming this is the same question?
@student_a123 wrote:
Yes, in which forum should I ask this question
Yes doesn't indicate if it's SAS Visual Analytics or SAS Studio.
They are different tools.
And if its Studio, the answer will be the same as on Stack Overflow.
Best forum for this type fo question is probably the SAS Programming forum unless you are using a point-and-click tool...
Not sure what you are trying to get as output. For example, this output looks similar to what you are getting:
data have;
call streaminit(12345);
do id=1 to 100;
flag1=rand('integer',0,1);
flag2=rand('integer',0,1);
output;
end;
run;
proc freq data=have;
tables flag1*flag2;
run;
|
If the values 1 and 0 represent something that you want to be reflected in the report, you might create a custom format and apply the format in proc freq:
proc format;
value flag 0='False'
1='True'
.='Missing'
other='Miscoded'
;
run;
proc freq data=have;
tables flag1*flag2;
format flag1 flag2 flag.;
run;
This changes the values in the output like this:
|
I've merged your posts and moved them to the ODS REPORTS forum as that's the most appropriate. You should include the image from SO as well, the second one that shows what you actually want.
If you edit your posts, no one see's that. You need to reply to the post.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.