topic Re: programming of freq tables in SAS Data Management

programming of freq tables

Alex33 — Fri, 28 Nov 2014 13:03:32 GMT

Hello. Could you help me. I need programming the frequency table for example as pic 1 (attached) .

i read and watched different resources about it, but there is no information on my task

Please show me how programme it

The main file attached

art297 — Fri, 28 Nov 2014 15:38:45 GMT

You'll probably have to play around with this to get exactly what you want, but I think you are looking for proc tabulate. e.g.:

PROC TABULATE data=have;

CLASS dose visit result;

TABLE dose * visit ,

result * n all='Total';

RUN;

Alex33 — Sat, 29 Nov 2014 09:02:30 GMT

Arthur, the biggest thank you:) the code is really working, but may be you help me in some nuances?

1. this pic of results has shifted data.pic2 I think is not accurately and those strange letters ƒ

The data must be look like this pic3

Please maybe you know how do this?

Reeza — Sat, 29 Nov 2014 15:25:57 GMT

Do you have your data already summarized for such a table or do you have the raw data?

The ff are from the listing output copied to a word document. What will your final output file be, a word document, excel, pdf?

The report shown above is a more complicated than your original question, but it's also a commonly asked question.

Here's a good link on creating such reports in SAS, I believe there's an exact example of what you're looking forward towards the end.

Alex33 — Sat, 29 Nov 2014 22:38:56 GMT

1. Hi, this is raw data. here full version

2. the f was copied in txt, but in word and excel too image of result

but i need is the code such as given by Arthur, but adapted on my task and data, it's required my science work)

Alex33 — Sun, 30 Nov 2014 20:48:44 GMT

I read your document, i did it my work:)Thanks, but maybe you suggest me , how create column not done)