05-31-2024
v307086
Calcite | Level 5
Member since
01-21-2023
- 14 Posts
- 1 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by v307086
Subject Views Posted 1618 05-31-2024 12:03 PM 766 02-01-2024 01:38 PM 789 02-01-2024 01:30 PM 3611 04-12-2023 11:17 AM 3646 04-11-2023 07:58 PM 3710 04-11-2023 12:37 AM 3747 04-10-2023 07:30 PM 3766 04-10-2023 05:51 PM 3802 04-10-2023 05:03 PM 3831 04-10-2023 04:32 PM -
Activity Feed for v307086
- Posted Retain the value on SAS Programming. 05-31-2024 12:03 PM
- Posted Re: Proc transpose on SAS Programming. 02-01-2024 01:38 PM
- Posted Proc transpose on SAS Programming. 02-01-2024 01:30 PM
- Posted Re: SAS Graphs on Graphics Programming. 04-12-2023 11:17 AM
- Liked Re: SAS Graphs for DanH_sas. 04-11-2023 07:59 PM
- Posted Re: SAS Graphs on Graphics Programming. 04-11-2023 07:58 PM
- Posted Re: SAS Graphs on Graphics Programming. 04-11-2023 12:37 AM
- Posted Re: SAS Graphs on Graphics Programming. 04-10-2023 07:30 PM
- Posted Re: SAS Graphs on Graphics Programming. 04-10-2023 05:51 PM
- Posted Re: SAS Graphs on Graphics Programming. 04-10-2023 05:03 PM
- Posted SAS Graphs on Graphics Programming. 04-10-2023 04:32 PM
- Posted Re: Please help me to Answer the questions below on SAS Programming. 01-22-2023 12:56 PM
- Posted proc report in SAS ODA on SAS Programming. 01-22-2023 12:46 PM
- Posted Re: Can see only output data in tabular form while using proc report in SAS ODA on SAS Programming. 01-22-2023 12:43 PM
- Posted I can only see a table while using proc in sas oda. I can see only table form. can anyone help me on SAS Programming. 01-21-2023 08:34 PM
-
Posts I Liked
Subject Likes Author Latest Post 3
06-02-2024
04:17 PM
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
02-01-2024
01:42 PM
A BY statement puts results from each level of the BY variable (1, 2, 3 or 4) on its own row. Without the BY statement, results for 1, 2, 3 and 4 are on the same row.
... View more
04-12-2023
11:22 AM
"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
01-29-2023
06:39 PM
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
01-22-2023
04:38 PM
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
01-22-2023
04:38 PM
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