topic Re: Proc freq vs datastep in SAS Programming

Proc freq vs datastep

BrahmanandaRao — Wed, 30 Sep 2020 17:08:20 GMT

How to get proc freq output
Using datastep

Re: Proc freq vs datastep

PaigeMiller — Wed, 30 Sep 2020 17:13:34 GMT

Hello @BrahmanandaRao

Could you explain further? Provide details? Thanks!

Re: Proc freq vs datastep

ballardw — Wed, 30 Sep 2020 17:17:35 GMT

Example data and the proc freq code you want to simulate.

Note: if you are using Proc Freq to compute anything other than counts the code in a single Data step is likely to be ugly at best and impossible at worst. Even just doing counts of something like : tables x*y is going to be somewhat ugly.

Re: Proc freq vs datastep

Reeza — Wed, 30 Sep 2020 17:30:11 GMT

Are you asking:

How to save the output from PROC FREQ to a dataset
How to get the same output you would from PROC FREQ using a data step instead
Something else?

It would be very helpful if you would add more details to your question before you post them. A rough idea is to show what you have, what you want and what you've tried so far.

@BrahmanandaRao wrote:
How to get proc freq output
Using datastep

Re: Proc freq vs datastep

BrahmanandaRao — Wed, 30 Sep 2020 17:32:49 GMT

same proc freq output
In data step

Re: Proc freq vs datastep

Reeza — Wed, 30 Sep 2020 17:34:30 GMT

Why?

Re: Proc freq vs datastep

PaigeMiller — Wed, 30 Sep 2020 17:37:54 GMT

@BrahmanandaRao wrote:
same proc freq output
In data step

@BrahmanandaRao

As before, I ask for further explanation and details, which this does not provide. Please put some time and effort into asking clear and understandable questions, with enough explanation and details so we know what you mean. Your extreme brevity is not a good way to ask questions.

Re: Proc freq vs datastep

BrahmanandaRao — Wed, 30 Sep 2020 17:47:07 GMT

Interviewer asked

Re: Proc freq vs datastep

Kurt_Bremser — Wed, 30 Sep 2020 18:46:39 GMT

If the extremely little effort you put into asking questions here is typical for the effort you put into work, then any interviewer will be well advised to not recommend you for hiring.

Please show us that this impression is wrong.

@BrahmanandaRao wrote:
Interviewer asked

Re: Proc freq vs datastep

ballardw — Wed, 30 Sep 2020 20:15:56 GMT

@BrahmanandaRao wrote:
Interviewer asked

Next time, if there is one, then ask the interviewer for the specific Proc Freq code to emulate.

And if the result is supposed to be duplicated by a single Data step.

Take a look in the documentation at just how many options are available for the tables statement, especially the tests like Chi-squares or odds ratios. Then look up what is involved with calculating the pieces needed to do those.

Since a single Proc Freq call can have for practical purposes an unlimited number of tables statements requesting different output for each one with differing numbers of variables the actual content of the freq code really needs to be determined.

And the Plots options are right out unless you have delved into the not very often mentioned of the Data Step Graphic Interface.

I suspect the question was not about "data step" coding as much as awareness of the multiple options available in Proc Freq.

Re: Proc freq vs datastep

Reeza — Wed, 30 Sep 2020 20:54:29 GMT

Even at the basic one way or two way table it's a decent question for an interview - the correct response is I would never do that manually, but if I had to for some reason then this how I would do it.

A one way or two table tests by group processing, control of output and retain calculations in a single step that should be relatively quick for a SAS programmer who understands data step processing.

I 100% agree that trying to replicate a tested process with manual complicated statistical calculations is a bad idea.

Re: Proc freq vs datastep

BrahmanandaRao — Thu, 01 Oct 2020 09:05:25 GMT

Hi KurtBremser
If you don't want to give answer please ignore me here after please don't make insult
of course you are expert in coding but i am beginner

Re: Proc freq vs datastep

Kurt_Bremser — Thu, 01 Oct 2020 09:21:34 GMT

It obviously took that (intended) insult to get you to write a complete sentence with some information content. Now answer our questions and provide details about your issue, so we can be of help.