oh in sas it is actually blank see attached next to 1077.27 (row 9243, col hkpbim_int_rate)     ... View more

so this is the sequence read from text file data SDATA2.HKPBIM_STATIC; infile "&G-IRF_RAW_PENDING_PATH./hkpb.static.txt" RECFM=N' readdata: input hkpbim_int_rate $EBCDIC4.0 . . . FORMAT hkpbim_int_rate $4.0 THEN SDATA2.HKPBIM_STATIC is used to create wdata.installment using data step and nothing is done to the variable hkpbim_int_rate and wdata.installment is the file I want to convert to csv using the following code: filename exprt "/toutput/path/installment.csv" encoding="utf-8"; proc export data=output.installment outfile=exprt dbms=csv replace; run; now in the output most lines can be loaded into db2 using load insert command but as shown in picture attached where red line added, this row suddenly cannot be loaded because the input splitted into two lines unlike lines before and after it. I was told it was seperated by a 'cache return', not too sure but it sound likes it from a senior.. and senior asked me to put "" in the field to resolve. I tried but I end up getting """"""""""""" as the input instead very weird. so my question is how to have this column load into db2 properly, right now it gets rejected? I will show you how sas display these in a bit.... I must convert into csv first..             ... View more

If output as $4.0 why i am getting symbols like ^@000^@^@ but splitted into two lines with cache return after convert to csv as original sas is showing 0 (but length is 2) I convert this way Filename exprt “/path/to/test.csv” encoding=“utf8”; Proc export data=out.test outfile=exprt dbms=csv replace; run; ... View more

It is then output as $4.0 So pretty normal? ... View more

I want to convert into csv then load into db2 What to do now ... View more

this second column in $EBCDIC4.0 is giving me trouble, in sas it looks empty and after converting to csv it looks like & (1 digit) or 0 (but when use len(), says 2)  what is the best way to convert this in csv and have it as utf8? ... View more

I reread the program and realised these data is put in like this   input int_amt S370fpd5.2 int_rate $EBCDIC4.0     could S370fpd5.2 or S370fpd5.2 make numbers display in a strange way like symbol?     ... View more

 can I use encoding=utf8 to display it? I used encoding=utf8 to convert the file to csv and use codepage=1208 (which is also for utf8) to load into db2  however the content splited up into two rows with a cache return between so e.g. ^@000^@^@ before ^@000            ^@^@ does it work if I use double quote to enclose it before converting into csv but I tired it keep giving me """"""""""""   ... View more

data test2; set cust; string=COLLATE(1,256); high4=substr(string,55); cust_id=translate(cust_id, high4, string); run; does these create binary code? they look like symbols e.g. ^@000^0^0 ... View more

Sorry it didnt work that field become ”””””” Let me clarify What happened was i try to convert sas dataset to csv This particular column was something like ^@000^@^@ After converted to csv, it became 22,33, hello,^@000 ^@^@,44,55 So it has a lot of space in it and split into two lines in csv I was told it is due to a cache return and so should put it inside “” But i tried concatx and quote both give me “”””””” ... View more

data outout; length field $10; field = "hello"; field = quote(field); run; proc print data=outout; run; I get "hello and not "hello" why? ... View more

I can’t convert again so must change db2 command or remove them.   something worry me, before I used encoding ‘any’ to convert saw datasets to csv but some columns cannot show in db2 due to character conversion problem, so I used utf8 but I am worried that some data originally showing fine cannot show as I am not using encoding ‘any’, what can’t of encoding would be a problem.. I remember seeing different data format in some SAS programs.. but I must say most should work with utf8? ... View more

does it only happen to the first character as an additional character and I can remove it such the rest of the file is same or original? ... View more