topic Re: How to rename day1 to day30 as month 1 in SAS Programming

How to rename day1 to day30 as month 1

Ammu18 — Mon, 11 Mar 2019 14:53:59 GMT

I have a dataset of 360 days

I want to convert day 1 to day 30 as month 1, day 31 to day 60 as month 2 and likewise rename till month 12

No date is given

Please help me to solve this

Re: How to rename day1 to day30 as month 1

PaigeMiller — Mon, 11 Mar 2019 15:00:58 GMT

Show us a portion of this data set.

What have you tried so far?

Re: How to rename day1 to day30 as month 1

Ammu18 — Mon, 11 Mar 2019 15:18:49 GMT

The data set looks like

day1 day2 day3 ......day359 day360.

1 0 1 1 1

1 0 0 1 1

0 1 1 0 0

1. I tried to rename the variables

But only day1 change to month1.

2. then i tried the code given below

%macro rename1(oldvarlist, newvarlist);
  %let k=1;
  %let old = %scan(&oldvarlist, &k);
  %let new = %scan(&newvarlist, &k);
     %do %while(("&old" NE "") & ("&new" NE ""));
      rename &old = &new;
	  %let k = %eval(&k + 1);
      %let old = %scan(&oldvarlist, &k);
      %let new = %scan(&newvarlist, &k);
  %end;
%mend;data a ;
  set b;
  %rename1(day1 day2...day30, month1); /*****didnt work as only day 1 changed********/
run;

Re: How to rename day1 to day30 as month 1

PaigeMiller — Mon, 11 Mar 2019 15:21:15 GMT

@Ammu18 wrote:

The data set looks like

day1 day2 day3 ......day359 day360.

1 0 1 1 1

1 0 0 1 1

0 1 1 0 0

Okay, and what should the end result look like after you do this renaming?

Re: How to rename day1 to day30 as month 1

Ammu18 — Mon, 11 Mar 2019 15:25:27 GMT

I have 360 days given and it should be renamed to month1 to month 12

I have to consider 30mdays in each month

month1 month1 month1 ......month12 month12.

1 0 1 1 1 1

1 0 0 1 1 1

0 1 1 0 0 1

Re: How to rename day1 to day30 as month 1

PaigeMiller — Mon, 11 Mar 2019 15:31:36 GMT

This is not possible in SAS. You cannot have two (or more) different columns of data with the exact same variable name.

Perhaps you need to re-think the problem.

Re: How to rename day1 to day30 as month 1

ErikLund_Jensen — Mon, 11 Mar 2019 17:03:38 GMT

Hi @Ammu18

Never use macro coding if it is not necessary, and it is not in this case. As explained by @PaigeMiller, you cannot have more than one variable with the same name, and I cannot imagine why you would want that, because you would still have the same output data set with 360 variables. I think your request only makes sense it you want to output 12 output variabeles with Month1 as the sum of day1-day30 and so on. If that is a usable result, you can get it in one data step using 2 arrays like this:

data have (drop= i j);
	array day day1-day360;
	do i = 1 to 10;
		do j = 1 to 360;
			day{j} = ranuni(1) > 0.5;
		end;
		output;
	end;
run;

data want (keep=month1-month12); set have;
	array day day1-day360;
	array month month1-month12;
	do i = 1 to 360;
		m = int((i-1)/30)+1;
		month{m} = sum(month{m},day{i});
	end;
run;

Want has 360 variables with random distribution of 0/1, and have is:

Re: How to rename day1 to day30 as month 1

Ammu18 — Mon, 11 Mar 2019 17:54:39 GMT

Thanks a lot for your feedback PaigeMiller.

I really appreciate your prompt response.

Ammu

Re: How to rename day1 to day30 as month 1

Ammu18 — Mon, 11 Mar 2019 17:56:42 GMT

Hi @ErikLund_Jensen,

Thanks a lot for the feedback. I will try this.

Ammu