DATA Step, Macro, Functions and more

Converting a value from dd/mm/yyyy to yyyymmdd

Reply
N/A
Posts: 0

Converting a value from dd/mm/yyyy to yyyymmdd

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!
N/A
Posts: 0

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

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.
Ask a Question
Discussion stats
  • 1 reply
  • 2551 views
  • 0 likes
  • 1 in conversation