About maddepusrikanth

maddepusrikanth · ‎11-29-2021

are you talking about SAS Data Loader for Hadoop (DLH)? Yes, SAS to SASDLH Migration.

maddepusrikanth · ‎11-28-2021

Hi, we are migrating SAS base to SAS DLH. the below code is in SAS base. SAS BASE Data RACCPERF.BDAXPCARDP_&str_tgl_1; SET &lib.xxxxxxxxx (keep= CRDNBR CRDACCT CRDUSRDTA CRDEMBL3 CRDBLK CRDBLKDTE CRDPDTNBR CRDEXPDTE CRDSTATUS CRDEMBL1 CRDRLNSHP) ; UCRDBLKDTE = INPUT(INput(STRIP(CRDBLKDTE),$8.),YYMMDD8.); coba = strip('1000000' + put(strip(crdexpdte),$4.)); if substr(coba,4,2) in ('00','01','02','03','04','05','06','07','08','09','10','11','12','13', '14','15','16','17','18','19') then do; coba2 = strip('200000' + substr(coba,2,6)); end; else do; coba2 = strip('190000' + substr(coba,2,6)); end; UCRDEXPDTE = INPUT(INPUT(COBA2,$6.),YYMMN6.); as_of_date=strip(put(&str_tgl_1,$14.)); run; SAS DLH Code. Plz Advice. Thanks.

maddepusrikanth · ‎11-26-2021

Hi All, Here is my code please review. CODA = (Strip (190000 +substr(CODA,2,6)); /* OP Values are correct*/ coda21=Strip(Put(coda2,$6); /* OP Values are correct*/ ADCB=MDY(SUBSTR(CODA21,5,2),SUBSTR(CODA21,7,2),SUBSTR(CODA21,1,4); /* OP Values are null*/ I want only month and year in ADCB. Please advice. Thanks.

maddepusrikanth · ‎11-05-2021

Date

maddepusrikanth · ‎11-05-2021

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

maddepusrikanth · ‎10-14-2016

i want max Screen_number for every SSID and if the min Date_Screened as Date_Screend dates take the Date_Screnned and MAX Date_Screened as Date_Rescreened. date screend failed & Date_Randimized. Thanks.

maddepusrikanth · ‎10-14-2016

Hi, need to hlep on data reformat as below. i/p and o/p as below Excel. SSID Screening_Number Date_of_Birth date_screened Date_Randomized Date_Screen_failed 158018 840238004 23Dec1947 11Apr2016 11May2016 158018 840238004 23Dec1947 13Jul2016 27Jul2016 158018 840238019 23Dec1947 11Apr2016 11May2016 158018 840238019 23Dec1947 13Jul2016 27Jul2016 o/p SSID Screening_Number Date_of_Birth date_screened Date_Screen_failed Date_Rescreened Date_selected 158018 840238019 23Dec1947 11Apr2016 13Jul2016 11May2016 27Jul2016 Thanks

Online Status	Offline
Date Last Visited	‎12-15-2021 03:01 AM

Re: SAS Data loader convert date value to SAS value

Re: SAS Data loader convert date value to SAS value

SAS Data loader convert date value to SAS value

Re: SAS Base migration to SAS data loader hadoop

SAS Base migration to SAS data loader hadoop

Re: SAS Data reformat

SAS Data reformat

Re: SAS Data loader convert date value to SAS value

Re: SAS Data loader convert date value to SAS value

SAS Data loader convert date value to SAS value

Re: SAS Base migration to SAS data loader hadoop

SAS Base migration to SAS data loader hadoop

Re: SAS Data reformat

SAS Data reformat