topic Re: Create sas data set with dates YYMM nuymeric in SAS Programming

Create sas data set with dates YYMM nuymeric

Ronein — Tue, 09 Apr 2024 11:21:05 GMT

Hello

What is the way to create the following data set with 6 columns M1-M6 with numeric number (represent date in format YYMM).Please note that I need it because the data sets tables have YYMM name and when I run macro later I need to mention to which data sets use.

Re: Create sas data set with dates YYMM nuymeric

PaigeMiller — Tue, 09 Apr 2024 11:35:17 GMT

This is essentially the same as your other question, where you want macro variables that have these values. The only difference is that here you would have to loop in a data step, whereas when you want macro variables you can do the looping in a data step with CALL SYMPUTX or with a macro loop.

I already explained how to do it in your other thread.

Re: Create sas data set with dates YYMM nuymeric

yabwon — Tue, 09 Apr 2024 11:49:46 GMT

Besides what @PaigeMiller already advised you, it looks like you have an Excel table already generated. How about importing it?

Bart

Re: Create sas data set with dates YYMM nuymeric

Kurt_Bremser — Tue, 09 Apr 2024 16:41:22 GMT

The YYMMN4. format will display a date value in this way; use it in a PUT function. Calculate the dates with INTNX.

Re: Create sas data set with dates YYMM nuymeric

Tom — Tue, 09 Apr 2024 18:01:35 GMT

It is not clear what you mean (and posting a photograph does not help).

Do you want a DATE value with a display format like YYMMN4. format attached that will display the dates with just the last two digits of the year and two digit month number?

Do you want an INTEGER value like 2,404 with no format (or perhaps the 4. format) attached so it prints like 2404?

And please explain in more detail WHY you need this dataset? What exactly are you going to do with it?

Are you planning to combine it with actual data? What does that data look like? How do you plan to combine them?

Re: Create sas data set with dates YYMM nuymeric

Ksharp — Wed, 10 Apr 2024 03:00:28 GMT

data want;
array M{6};
start=mdy(7,1,2019);
   do month=0 to 34;
     do n=1 to dim(M);
      M{n}=intnx('month',intnx('month',start,month),n);
	 end;
	 output;
   end;
keep m1-m6;
format m1-m6 yymmn4.;
run;