Date to Int

[thomask23]

I need to join a data set by the primary id and the month.
The month field in one table(A) is a char and the month field in the other table(B) calandar.

Table A month field is formatted like 20150301 INT
TABLE B month field is formatted like 01SEP14 DATE

HOW CAN I FORMAT THE MONTH FIELD IN TABLE A(01SEP14) TO return (20140901) INT

iVE TRIED THE BELOW
(DIDNT WORK)

DATA work.ACCTS;
        SET work.ACCTS ;
  MONYEARCHAR=put(firstday,z6.);
   RUN;
        QUIT;
PLEASE HELP.

[stat_sas]

Try this to see if it works.

format month yymmddn8.;

[Reeza]

You need yymmdd8. format instead of z6 format in your put statement.

If you're doing this via SQL you can do the transformation in the SQL join step. 

[PGStats · Accepted solution]

INT looks more like a numeric than a character variable. To get a number that looks like a date, you will need an input(put()) combination:

data test;

firstday = '01SEP14'd;

format firstday date7.;

int = input(put(firstday, yymmddn8.), 8.0);

run;

proc print; run;

PG