I cannot have the translation to and reverse running on same session. What extra do i need to reverse? ... View more

string=COLLATE(1,256); high4=substr(string,55); cust_id=translate(cust_id, string, high4); Actually there is really just three lines in the original code and there is no specification to length or format or data type to string or high4 and cust_id is an alphabet follow by 7 digits no of 0-9, would a one liner cust_id=translate(cust_id, high4, string) be adequate or I have to add string=collate(1,256); high4=substr((string,55); just before that one liner? My converted cust_id does look more strange than what we see here sometimes longer with say a bunch of VVVVVVVVVVVVVVVVVV to end some usually about some 40 characters long.. ... View more

if _n_=1 then do; string=COLLATE(0,255); high4=cats(substr(string,56),substr(string,1,55)); end; why is this part required? also why have to minus 1 in collate paramenters?   ... View more

if I already have cust_id_out_1 created from cust_id and I just need to turn cust_id_out_1 back into cust_id how do I put it?   I tried the given command starting from cust_id -e1234567 etc to cust_id_out_1 to cust_id_out_2 it worked but if I already have cust_id_out_1 and I want to get back to cust_id, the translation gives wrong answer What is missing? ... View more

What if cust_id contains also characters E.g. E4349567 C4127658 C6267260 E5211402 K4729617 G6646262 Does it work？ ... View more

data custinfo; input cust_id $8.; datalines; E4349567 C4127658 C6267260 E5211402 K4729617 G6646262 ; run; data test1; set custinfo; string=COLLATE(1,256); high4=substr(string,55); cust_id_out_1=translate(cust_id, high4, string); cust_id_out_2=translate(cust_id_out_1,string,high4); run; proc print data=custinfo; run; proc print data=test1; run; I tried but cannot see cust_id_out_1 or cust_id_out_2, but no error though ... View more

data test2; set cust; string=COLLATE(1,256); high4=substr(string,55); cust_id=translate(cust_id, high4, string); run; what would be the code in sas to reverse the above?  ... View more

I convert sas dataset with those symbols into csv using utf8 then sftp to another server which load insert into db2 ... View more

We convert sasdataset into csv using encoding utf8 as explained above Then csv is transferred to linux and load into db2 ... View more

in notepad it looks gibberish too   in ultraedit, using hex it shows better....   pls see both pic   ... View more

haha not the 55 things, it just came in as a txt file then we use sas to read from text file and output as dataset , that's it I am trying to find that txt file and will show you if I can have access   ... View more