And a final minor variation:   data want (drop=_:); set have; date=coalesce(date,_ret_date); retain _ret_date; if response^='NE' then _ret_date=date; run; Do you literally mean "previous month value", or do you mean the most recent non-missing date value?  I.e., what do you want if you have more than one consecutive missing date? ... View more

"Didn't work" is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the "</>" to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the "</>" icon or attached as text to show exactly what you have and that we can test code against.   In other words, Show the code you actually used and best from the log as the messages SAS provides often will indicate what is needed. ... View more

Hello As you are new to SAS pease this is a good introduction for you https://support.sas.com/resources/papers/proceedings11/054-2011.pdf . ... View more

Hi: Your screen shot of desired results is the type of report typically called a demographic report. There is not any SAS procedure that will generate that type of report for you by default. You have to do more manipulation of the summarized data in order to generate the type of report you show. For example, your XX (XX%) for the values for the Active vs the Placebo is usually the concatenation of 2 numeric variables (N and PCTN) in order to make a character string that can be displayed under each major column. Typically, to get the results for GENDER, you run PROC FREQ for each of your groups (ACTIVE/PLACEBO) and then for your AGE values, you run PROC MEANS. Generally, you need to post process the data from both of these procedures to get the data in a form that's ready for PROC REPORT. There are several macro programs floating around that do it. I have several examples using PROC REPORT with some helper variables in my Creating Complex Reports paper and Lisa Fine has some examples of this type of report in her book on using PROC REPORT and I'm sure I remember several PharmaSUG papers that had different ways to use PROC REPORT or the DATA step to generate this type of report. Cynthia ... View more

Hi: Your screen shot of desired results is the type of report typically called a demographic report. There is not any SAS procedure that will generate that type of report for you by default. You have to do more manipulation of the summarized data in order to generate the type of report you show. For example, your XX (XX%) for the values for the Active vs the Placebo is usually the concatenation of 2 numeric variables (N and PCTN) in order to make a character string that can be displayed under each major column. Typically, to get the results for GENDER, you run PROC FREQ for each of your groups (ACTIVE/PLACEBO) and then for your AGE values, you run PROC MEANS. Generally, you need to post process the data from both of these procedures to get the data in a form that's ready for PROC REPORT. There are several macro programs floating around that do it. I have several examples using PROC REPORT with some helper variables in my Creating Complex Reports paper and Lisa Fine has some examples of this type of report in her book on using PROC REPORT and I'm sure I remember several PharmaSUG papers that had different ways to use PROC REPORT or the DATA step to generate this type of report. Cynthia ... View more