Hi Jimbarbour, i was able to resolve that by applying the following code below for the AESTDTC. However, since the AEENDTC is U, i guess its unknown and it has to be missing. *Y/M/D for partial date; yearst = scan(aestdtc,3,'-'); monthst = scan(aestdtc,2,'-'); dayst = scan(aestdtc,1,'-'); if length(yearst) =3 then yearst=compress(yearst||'0'); AESTDT=mdy(monthst,dayst,yearst); Regards ... View more

Thank you Patrick. However when the database is locked and the source data cannot be changed then only data programming can correct such anomalies. In this case it should be 18NOV2020. Thank you. ... View more

Thank you Jimbarbour for your kind explanation and assistance in resolving this puzzle. I will implement same and see the outcome. Best regards, Chimuka ... View more

Thank you KurtBremser for your candid advice. It really helped. Warm regard, Chimukah ... View more

Thanks for your suggestion.   Actually the par_1 & 2 variables were coming from transposed data. However, implemented it yet errors as follows:   ... View more

A big thank you. This also solved the second problem. Both problems are solved. ... View more

Thank you Tom for your advice. It did the magic. However it solved the main problem which is the double quotes and also created another one which we avoided using the Label. (Main-Land)  coded as Main_Land   Renaming the variables (perhaps in the notepad or Excel) after Proc Export could be done outside programming environment. However, to accomplish the task accordingly, everything has to be within the programming environment.   Is there anyway to avoid this problem. i mean an alternative to make the variable appear in form of Main-Land instead of Main_Land   Thank you once again. ... View more

data b1; do sample = 1 to 15; do unit = 1 to 3; if unit = 1 then seq = "A"; else if unit = 2 then seq = "B"; else if unit = 3 then seq = "C"; output; end; end; run; proc export data = b1 outfile = "C:\Users\Documents\My SAS Files\9.4\ My_Programmes\ran.csv" dbms=dlm label replace; delimiter = ';'; run; ... View more

Let me demonstrate a little : data b1; do sample = 1 to 15; do unit = 1 to 3; if unit = 1 then seq = "A"; else if unit = 2 then seq = "B"; else if unit = 3 then seq = "C"; output; end; end; run; proc export data = b1 outfile = "C:\Users\Documents\My SAS Files\9.4/My_Programmes\ran.csv" dbms=dlm label replace; delimiter = ';'; run; ... View more