Converting a value from dd/mm/yyyy to yyyymmdd

deleted_user — Wed, 21 Apr 2010 03:26:48 GMT

Hi All

I am trying to convert input values from the format dd/mm/yyyy to yyyymmdd - this is what some of my code looks like but i cannot seem to get it working :

DATA HEAD;
LENGTH INV_HEADER_TYPE $01. ;
LENGTH INVDATEL $10.;
.
.
INFILE VAPHEAD DSD DLM=',' FIRSTOBS=2;

INPUT
INV_HEADER_TYPE $
INVDATEL $

DATA COMBINE;
SET HEAD ; BY INV_NO;
RUN;

DATA BOTHOUT;
SET COMBINE;
BY INV_NO;

INVDATEX=INPUT(INVDATEL,ANYDTDTE10.);

INVDATEZ=INPUT(INVDATEX,YYMMDD8.) ;

PUT @020 INVDATEZ $08.

;

any help appreciated!

Re: Converting a value from dd/mm/yyyy to yyyymmdd

deleted_user — Wed, 21 Apr 2010 03:59:11 GMT

well i resolved the problem by first converting the variable to a SAS date
:

INVDATEX=INPUT(INVDATEL,ANYDTDTE10.);

then simply using the format YYMMDDN8. in the put section:

@020 INVDATEX YYMMDDN8.

Cheers
Shelton.

topic Converting a value from dd/mm/yyyy to yyyymmdd in SAS Programming

Converting a value from dd/mm/yyyy to yyyymmdd

Re: Converting a value from dd/mm/yyyy to yyyymmdd