I love SAS, I love the flexibility, but sometimes you wonder if there is an easier way to do things..... Coming from SPSS and Stata, these programs had a great ability to split data and organise output Let me give an example: whenever you have subgroups and analyse your data with SPSS, then you have the option of "Split File", it allows you to organise the outcome as separate tables or aggregate the outcome in one easily readable file, see the link bellow, where it is shown for descriptive statistics but the same can be done with regression models https://www.youtube.com/watch?v=2mKU8Sev6Gk the "BY" statement in SAS creates separate tables and the output can be so long and confusing and difficult to read. I did a proc logistic in SAS with only one independent variabel just to get the unadjusted OR and then repeated the analyses for the 9 subgroups I have in my date with the BY statement, so imagine have the output for proc logistic repeated 9 times.... messy! I re-did it in SPSS, using the option "Split File-Compare Groups", the outcome was neat and easy to read Isn't there a simple way to do that in SAS too? Best wishes ... View more

EDITED: PLEASE SEE BELOW IN RED Hi all Could anyone please help me with this: I have a data set that looks like this:                  Person Earning Site Date 1 12 A 2001-01-23 1 34 B 2001-02-03 1 23 B 2001-02-25 2 45 B 2001-03-04 2 32 A 2001-03-27 3 7 A 2001-04-04 3 34 B 2001-05-05 3 65 B 2001-05-26 3 33 A 2001-06-06 3 23 B 2001-07-02 4 33 B 2001-02-03 4 12 A 2001-03-05 What I am trying to do is the following Person Earning Site Date 1 Earning first date person 1 Site at first earning First earning date person 1 2 Earning first date person 2 Site at first earning First earning date person 2 3 Earning first date person 3 Site at first earning First earning date person 3 4 Earning first date person 4 Site at first earning First earning date person 4 This is what I have done: proc sql; create table want as select distinct   Person,   Earning,   Site,   Date   from have   group by Person having date=min(date); Quit; In other words, i am trying to select the distinct rows per person by the first earning date. The problem is that there are still some duplicates. When I look at the new tables I see that the duplicates have the same "Person" but different "Site" which I really dont understand, MY MISTAKE, ACTUALLY THE PROBLEM SEEMED TO BE THAT THE DUPLICATES HAD THE SAME DATE BUT DIFFERENT SITE, ANY WHAY OF SOLVING THIS (I DONT CARE ABOUT WHICH SITE WOULD BE SELECTED IN THAT CASE) Any help is appreciated Best regards ... View more

Hi all I wonder if anyone has any suggestion / Macro / idea about how to visualize the frequencies of the different variables in a dataset? To explain a bit more, how to display a graphic presentation of the data, let us say, by showing a histogram showing the frequencies of male and females in the gender variable (categorical variable) of the dataset, and a histogram for the frequencies of people in age (continuous variable, same as the histogram in the proc univariate) ? Or if you have a better suggession that only histograms to "see" the data? Kind regards Am ... View more

Hi I have been searching for this very simple thing. Creating a frequency table with certain increament steps Let us say I have a continous variable taking values 1-100 and I have a thousand observations of that variable What is the easiest wat to create a frequency table with a specific increamtnet, ie in groups of 10 or 20 or anything?? Using proc freq with formats seems a bit complicated for this task, or am i worng? Regards ... View more