topic Re: Proc freq base format in ODS and Base Reporting

Proc freq base format

student_a123 — Fri, 06 May 2022 16:58:42 GMT

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!

Proc freq base format

student_a123 — Fri, 06 May 2022 16:37:36 GMT

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!

Re: Proc freq base format

PaigeMiller — Fri, 06 May 2022 16:44:48 GMT

I don't know what you mean by "Base format". Please show us an example.

Re: Proc freq base format

Reeza — Fri, 06 May 2022 16:45:13 GMT

Is this using SAS Visual Analytics or SAS Studio? You've posted this question under VA.

Assuming this is the same question?

https://stackoverflow.com/questions/72102639/i-dont-see-an-explanatory-legend-in-sas-proc-freq?noredirect=1#comment127462596_72102639

Re: Proc freq base format

student_a123 — Fri, 06 May 2022 16:49:53 GMT

Yes, in which forum should I ask this question

Re: Proc freq base format

SASJedi — Fri, 06 May 2022 16:51:12 GMT

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;

16.00

38.10

36.36

26.00

61.90

46.43

42.00

28.00

48.28

63.64

30.00

51.72

53.57

58.00

Total

44.00

56.00

100

100.00

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:

False

16.00

38.10

36.36

26.00

61.90

46.43

42.00

True

28.00

48.28

63.64

30.00

51.72

53.57

58.00

Total

44.00

56.00

100

100.00

Re: Proc freq base format

Reeza — Fri, 06 May 2022 17:00:11 GMT

@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.

Re: Proc freq base format

SASJedi — Fri, 06 May 2022 17:01:50 GMT

Best forum for this type fo question is probably the SAS Programming forum unless you are using a point-and-click tool...

Re: Proc freq base format

Reeza — Fri, 06 May 2022 17:16:36 GMT

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.

Re: Proc freq base format

Reeza — Mon, 09 May 2022 15:48:40 GMT

If you edit your posts, no one see's that. You need to reply to the post.