NEVER post pictures of code or other code-related text. Copy/paste the text into a window opened with the respective buttons. The button for logs and other non-proportional text is this:   The "little running man" to the right is for SAS code, and provides colorng similar to the SAS Enhanced Editor.   Whenever you have an issue with code, do ALWAYS post the whole (all code and messages) log of the failing step/macro/etc. ... View more

With percent values, you should also use the PERCENT format, or multiply by 100 first. ... View more

ALWAYS post the log when you have issues.   This looks wrong: data = NY2016_deliveries; A DATA statement does not have an equal sign apart from those needed in additional options. ... View more

The only practical way to retrieve all START values for a given format is PROC FORMAT. To get the values in any other way would involve reading the catalog file where the format is stored as a binary stream and extract the data, which would probably leave you with 10k of macro code. ... View more

Quote from myself: Please post example data as a DATA step with DATALINES in the future ... View more

You have two nested loops, the outer going backwards from February 2025 to November 2022, and the inner that counts back 11 months from the starting month. Define those two loops (using SAS functions like INTNX), and then run the code for the resulting month. ... View more

See my presentation. It contains a way to list all files/directories recursively. The permissions are contained in one of the FINFO results. ... View more

data have; infile datalines dlm='09'x dsd truncover; input patient $ treatment $ start :date9. end :date9. ; format start end date9.; datalines; E1 A 10-Apr-17 26-Jun-17 Seq A E1 B 07-Jun-18 08-Aug-18 Seq A E2 B 06-Sep-16 20-Oct-16 Seq B E2 A 15-Nov-17 04-Oct-18 Seq B E3 A 07-Dec-10 08-Feb-11 Seq A E3 A 06-Sep-16 20-Oct-16 Seq A E3 B 15-Nov-17 04-Oct-18 Seq A E4 B 07-Dec-10 08-Feb-11 Seq B E4 B 06-Sep-16 20-Oct-16 Seq B E4 A 15-Nov-17 04-Oct-18 Seq B E5 A 27-Feb-18 20-Nov-18 Combi C E5 B 22-May-18 30-Oct-18 Combi C E7 A 01-Feb-16 28-Apr-16 Seq A E7 A 20-Apr-17 16-May-17 Seq A E7 B 21-Aug-17 02-Jan-19 Seq A E7 A 27-May-19 29-Jul-19 Seq A E8 B 01-Feb-16 28-Apr-16 Seq B E8 B 20-Apr-17 16-May-17 Seq B E8 A 21-Aug-17 02-Jan-19 Seq B E8 B 27-May-19 29-Jul-19 Seq B ; data want; if 0 then set have; flag1 = "Seq "; do until (last.patient); set have; by patient; if first.patient then flag2 = treatment; if not first.patient and treatment ne lag(treatment) and start lt lag(end) then do; flag1 = "Combi"; flag2 = "C"; end; end; do until (last.patient); set have; by patient; output; end; run; Gives the same result that you show in your post.   Please post example data as a DATA step with DATALINES in the future, like I do here. ... View more

A DATA step does not produce output, it already creates a dataset. Just use that in the next step. ... View more

To save the results of a printing procedure to a dataset, use ODS OUTPUT  ... View more

Anytime you get NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. you have to look for something unbalanced in the code. Unbalanced quotes, missing closing parentheses, %MACRO without a proper %MEND, and so on. Note that you do not need to create and execute a macro if you only have simple unnested %IF %THEN %DO. You can run those in "open code" and remove at least part of the complexity, particularly for testing.   What do your include files contain? If there are more macro definitions in there, they might be part if the problem.   Start wit a simplified version of the process (as already suggested) and expand from there until you get a problem; you will then have clear clue where to look. ... View more

Do you want a count of admissions in a given week, or just a flag that there was at least one admission? ... View more

Use the WEEK function on the admission date, and then PROC FREQ to count the number of admissions per week. ... View more

Look at the many options of a SET statement, like END= or INDSNAME=. All these create variables. ... View more