topic Re: startdato-enddato in SAS Enterprise Guide

startdato-enddato

EDB1 — Thu, 24 Nov 2016 10:48:15 GMT

Hei,

I'm working with SAS, and I have this formatdate 200103;

I need to find the first and the last day in these dates, that's to say

først day would be 20010301

last day would be 20010331

I did this:

data test2;

set test1;

datoa=((aarm*100)+01);

datoz=input(put(((aarm*100)+1),z8.),yymmdd8.);

Run;

But I'm finding any most direct and short. Is this possible?

Re: startdato-enddato

Reeza — Thu, 24 Nov 2016 10:52:54 GMT

INTNX function. Look at the alignment parameter, with a 0 increment. The documentation has an example

Re: startdato-enddato

Kurt_Bremser — Thu, 24 Nov 2016 10:55:09 GMT

data test2;
set test1;
datoa = mdy(mod(aarm,100),1,int(aarm/100));
datoz = intnx('month',datoa,0,'end');
format datoa datoz yymmdd10.;
run;

Re: startdato-enddato

EDB1 — Thu, 24 Nov 2016 10:56:30 GMT

Ok,

I did it now:

data test2;

set test1;

datoa=((aarm*100)+01);

datoz=put((intnx('month',(input(put(((aarm*100)+1),z8.),yymmdd8.)),1)-1),yymmddn8.);

Run;

Is that the only one way?

I'm finding any more short

Re: startdato-enddato

Reeza — Thu, 24 Nov 2016 10:58:47 GMT

That's ugly. Why all the put/input? Can't you store it as a SAS date?

Youre looking for how many days in a month?

Re: startdato-enddato

Reeza — Thu, 24 Nov 2016 11:11:05 GMT

Date = input( aarm, yymmn6.);

start_date=intnx('month', date, 0, 'b');

end_date=intnx('month', date, 0, 'e');

format date start_date end_date yymmdd8;

run;

If you really want, you can nest the functions to get rid of the first step, but I thought it helped for clarity.

Re: startdato-enddato

EDB1 — Thu, 24 Nov 2016 11:22:24 GMT

It was fine but I has recived like a result any like this:

2001-03-12

But I would like any with this formate:

20010312

Is this possible?

Re: startdato-enddato

Kurt_Bremser — Thu, 24 Nov 2016 11:27:46 GMT

@EDB1 wrote:

It was fine but I has recived like a result any like this:

2001-03-12

But I would like any with this formate:

20010312

Is this possible?

If you meant my code, just change the format to yymmddn8.

Be aware that both my new variables contain SAS date values.

Re: startdato-enddato

EDB1 — Thu, 24 Nov 2016 11:58:43 GMT

KurtBremser...

thanks... 😉