About ItWorked

ItWorked

Hello SAS Community, I have dozens and dozens of variables that are named _2001_count, _2002_count, 2003_count, _2004_count, etc that I would like to rename to something like count_2001, count_2002, count_2003 etc. so I can work with them more easily. I don't want to have to type them all out each time I need to manipulate a variable and want them renamed so I can easily make variable lists. I have read several posts including https://communities.sas.com/t5/SAS-Programming/Rename-all-variables-starting-with-the-same-preffix-to-a/td-p/611152, but my situation is slightly different. I am using base SAS 9.4. Thank you for any help!

ItWorked · ‎05-22-2024

@ballardw Thank you for the tip. I did not know this. Thank you for re-writing the code as well.

ItWorked · ‎05-22-2024

This was perfect; I appreciate you!

ItWorked · ‎05-22-2024

Hello, I am trying to figure out how to expand a dataset by creating a new row for each year between a start date and end date and find the age the person is at each year between those 2 dates. I have tried a couple of things without success. I have tried to modify this code: https://stackoverflow.com/questions/47428867/how-to-create-additional-rows-for-each-day-between-two-dates-in-sas.Though the code ran successfully without errors, I did not get the intended results. It incremented the first observation's start date, and I need the first observation's start date to remain unchanged. I am not certain how to proceed. Any assistance would be appreciated. I am using SAS9.4.

ItWorked · ‎04-09-2024

@PaigeMiller Thank you, this makes sense - that dataset2 is being overwritten with the second iteration. Thank you for that helpful explanation. When I run your suggested code, I get 2 datasets, and each dataset has only 1 variable of interest, either age_2001 in one and age_2020 in the other. However, I wanted both of those variables in the same dataset. You are correct - I wanted to do the macro as a practice exercise and to save from writing out 15 extra lines of code (15 age categories for 2001 and 15 for 2020). But it sounds like skipping the macro on this is the way to go. Thank you again!

ItWorked · ‎04-09-2024

Hello, I have 2 age variables: age_2001 and age_2020, and I want to create an age category for each in a single data step: age_2001_cat and age_2020_cat. I can do this longhand successfully, but I wanted to try it in a macro. However, when I run the macro, the final output dataset only contains the age_2020 and age_2020_cat variables. Both age_2001 and age_2001_cat variables have been overwritten. Can you please help correct my macro statement? I am using SAS 9.4. Thank you in advance!

renaming multiple variables by making the prefix (which is a year) to ...

Re: increment an age for every year between 2 dates and create a new r...

Re: increment an age for every year between 2 dates and create a new r...

increment an age for every year between 2 dates and create a new row f...

Re: How do I prevent the second macro from overwriting the first?

How do I prevent the second macro from overwriting the first?

renaming multiple variables by making the prefix (which is a year) to ...

Re: increment an age for every year between 2 dates and create a new r...

Re: increment an age for every year between 2 dates and create a new r...

increment an age for every year between 2 dates and create a new row f...

Re: How do I prevent the second macro from overwriting the first?

How do I prevent the second macro from overwriting the first?