Hey everyone! I'm in bit of a pickle and have spent hours trying to figure this out so hoping someone out there can help. I have a project in SAS EG that contains two programs. Now, I inherited this project so I don't know what went into creating this project. But basically, one of the programs uses a &month and &year macro variable that gets defined in the Project Prompts screen when you run the project. These should be global variables.   In fact, &month is a global variable. When I run both programs, the variable gets initialized correctly. But for whatever reason, that's not happening with &year. It works in Program A but is not present in Program B.   I put in this code in Program A to see the macro variables: %put _global_;   The output is: 25 GOPTIONS ACCESSIBLE; 26 %put _global_; GLOBAL MONTH November GLOBAL YEAR 2018   But when I put the same code in Program B: %put _global_;   I only get this: 22 GOPTIONS ACCESSIBLE; 23 %put _global_; GLOBAL MONTH November   Does anyone know why this is happening? ... View more

I'm in bit of a pickle here and turning to you all for help. I'm a SAS beginner so pardon me if this is a very basic question. Basically, I have this dataset:   ID  Gender  Type 1    F            X       F            Y 2    F            Y       M           Y       F            X   Both the first two observations "belong" to ID=1 and the last three observations "belong" to ID=2. How do I fill in the missing ID values? I've tried using retain but SAS won't let me run any data step where I have a "by id" statement because this dataset isn't sorted by id. However, I can't sort it by ID because then I lose the grouping.   Any solutions here? ... View more