hi sorry i wasn't being clear enough for Starting Data. seen as picture 1 below. as for the mentioned step 1. i have use SAS Enterprise Guide "Import Data" function to import the data into SAS server directly without codes. due to the file is too large n have many columns i decided to make all of them into 1 column. the method used will be as follows to make all data into a single column for the intention to "faster processing". DATA WORK.ActILP_EX_2020_05_19_0030;
LENGTH
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n $ 1884 ;
LABEL
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n = "CHDRNUM|CNTTYPE|BILLFREQ|BILLCHNL|SRCEBUS|AGNTNUM|HISSDTE|BNSIND|ZREVBNS|BONUSAMT|ZINTRATE|ZANNTYDT|STATCODE|PSTATCODE|CRTABLE|LIFE|JLIFE|COVERAGE|RIDER|CRRCD|PCESTRM|RCESTRM|BCESTRM|SUMINS|ORIGSUM|ZBINSTPREM|EXTR|ZDISCODE|ZDISPREM|ZGSTPREM|AGE|RETIREAGE|C" ;
FORMAT
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n $CHAR1884. ;
INFORMAT
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n $CHAR1884. ;
INFILE 'C:\Users\parkourtofu\AppData\Local\Temp\SEG12248\ActILP_EX_2020-05-19-0030-17e38c4b19c0442bbe027eb0ec1ba9d7.txt'
LRECL=1884
ENCODING="WLATIN1"
TERMSTR=CRLF
DLM='7F'x
MISSOVER
DSD ;
INPUT
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n : $CHAR1884. ;
RUN; then i use tranwrd to change all the values with 99999999 to zero data test;
set WORK.ActILP_EX_2020_05_19_0030;
'CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n=tranwrd('CHDRNUM|CNTTYPE|BILLFREQ|BILLCHN'n , "99999999|", "0|");
RUN; these are the date columns of the 332 columns inside my data i wanted to zeorise them. yes the number that has " isnt the date and when i make them into 1 column, i assume i have made all the data without delimiter into a character form.
... View more