SAS Base migration to SAS data loader hadoop

[maddepusrikanth]

Hi All,

I am working for SAS Base to SAS data loader hadoop mogration project.

Please help in the below SAS base conversion in SAS dlh.

data RACxxxxx.BDAyyyyyyyy;

SET &lib.zzzzzzzzzzzz(keep = ACCTNBR ACCTPDT ACCTSTAT ACCTCUST ACCTDDPMT ACCTDTOPEN ACCTDTWRTO
ACCTBLK ACCTBLKDTE ACCTCRLMT ACCTCYCDUE ACCTSMTBLR ACCTCURBLR ACCTAMTDPR
ACCTNBRDPR ACCTSMTBLC ACCTCURBLC ACCTAMTDCC ACCTAMTDCC ACCTAMTCCC ACCTNBRCCC
ACCTCRDST1 ACCTCRDST2 ACCTCRDST3 ACCTCRDST4 ACCTCRDSH1 ACCTCRDSH2 ACCTCRDSH3 ACCTCRDSH4
ACCTFILDTE ACCTOUTBAL ACCTUPIBR ACCTUPSVCR ACCTUPMSCR ACCTUPINSR ACCTUPMEMR ACCTSVCCYR
ACCTMSCCYR ACCTINSCYR ACCTMEMCYR ACCTUPIBC ACCTUPSVCC ACCTSVCCYC ACCTDTCRL);

above code migration completed. but stuck at below code.

UACCTDTOPEN = INPUT(INput(STRIP(ACCTDTOPEN),$8.),YYMMDD8.);

as_of_date=strip(put(&str_tgl_1,$14.));

run;

Thanks,

Srikanth

[JosvanderVelden]

What is the content of ACCTDTOPEN?

[maddepusrikanth]

Date

[JosvanderVelden]

In what format? What is the issue?

data _null_;
ACCTDTOPEN = "18-04-03";
put ACCTDTOPEN=;
UACCTDTOPEN = INPUT(INput(STRIP(ACCTDTOPEN),$8.),YYMMDD8.);
put UACCTDTOPEN=;
run;