intnx

sasphd — Thu, 23 Mar 2017 13:52:33 GMT

I use intnx function but it give date format diffirent from I want

data firstandlastdates;
     set crsp.msf(keep=permno date);
     by permno; /*MSF is always sorted by permno date*/
     retain firstdate;
     date=intnx('month', date, 1)-1;
     if first.permno then firstdate=date;
     if last.permno then do;
         lastdate=date;
	 output;
     end;
  run;
  
  data permnosrankdates(rename=(date=rankdate));
      set firstandlastdates;
      date=firstdate;
      do while(date<=lastdate);
         output;
	 date=intnx('month', date+1, 1)-1;
      end;
  run;

 data permnosrankdates;
     set permnosrankdates;
     date=rankdate;
     i=1;
     do while(i<=24);
         output;
         date=intnx('month', date, 0)-1;
	 i=i+1;
     end;
  run;

the result that I want

Obs      PERMNO    rankdate         date     i

                  1       10000    19851231    19851231     1
                  2       10000    19851231    19851130     2
                  3       10000    19851231    19851030     3
                  4       10000    19851231    19850930    4
                  5       10000    19851231    19850831     5
                 ......

the result i GOT

                 Obs      PERMNO    rankdate         date     i

                  1       10000    19851231    1986           1
                  2       10000    19851231    8476           2
                  3       10000    19851231    2356           3
                  4       10000    19851231                   4
                  5       10000    19851231                   5

So I want to good date format YYMMDDN8.

Re: intnx

PaigeMiller — Thu, 23 Mar 2017 13:57:52 GMT

You need to assign the format you want to variable date when you create it in the data set. This has nothing to do with INTNX

Re: intnx

sasphd — Thu, 23 Mar 2017 14:11:39 GMT

How to do it please

Re: intnx

Kurt_Bremser — Thu, 23 Mar 2017 14:20:12 GMT

Use the format statement.

Re: intnx

PaigeMiller — Thu, 23 Mar 2017 14:23:59 GMT

format date yymmddn8.;

topic Re: intnx in SAS Procedures

intnx

Re: intnx

Re: intnx

Re: intnx

Re: intnx