topic Re: Date to Int in SAS Programming

Date to Int

thomask23 — Sat, 25 Apr 2015 01:27:36 GMT

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.

Re: Date to Int

stat_sas — Sat, 25 Apr 2015 01:50:06 GMT

Try this to see if it works.

format month yymmddn8.;

Re: Date to Int

Reeza — Sat, 25 Apr 2015 03:32:37 GMT

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.

Re: Date to Int

PGStats — Sat, 25 Apr 2015 03:41:02 GMT

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;