Converting a value from dd/mm/yyyy to yyyymmdd

[deleted_user]

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!

[deleted_user]

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.