topic Re: SAS Base migration to SAS data loader hadoop in SAS Viya

SAS Base migration to SAS data loader hadoop

maddepusrikanth — Fri, 05 Nov 2021 14:46:05 GMT

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

Re: SAS Base migration to SAS data loader hadoop

JosvanderVelden — Fri, 05 Nov 2021 15:05:50 GMT

What is the content of ACCTDTOPEN?

Re: SAS Base migration to SAS data loader hadoop

maddepusrikanth — Fri, 05 Nov 2021 15:12:41 GMT

Date

Re: SAS Base migration to SAS data loader hadoop

JosvanderVelden — Fri, 05 Nov 2021 15:20:10 GMT

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;