here is my problem : data montest; format tp1 time8. ; tp1= 109320; run; proc fedsql; create table montest2 as select * from montest ; quit; ... View more

Ok.. Thks so much ... View more

for example my variable is this form %let var = ABCD_GROUP,OPEGROU,AWSAMZ,HOMJACGFF,YEDD_DE,UEUEDD,HDHDHD_GGGGG,OPERATOR_DATA,INVOICE_MKG,GRFSDD_MKT,OFFICE_DIREC,AMZ_RECRUIT,ALL_EVENT,REZO_SAS,AHAHEHEHDH_TERR ; and in the Html <td> i want this variaable to be display this way : intead of list form separed by comma : ABCD_GROUP OPEGROU AWSAMZ AWSAMZ HOMJACGFF YEDD_DE UEUEDD HDHDHD_GGGGG OPERATOR_DATA INVOICE_MKG GRFSDD_MKT OFFICE_DIREC AMZ_RECRUIT ALL_EVENT REZO_SAS AHAHEHEHDH_TERR ... View more

Hello. thks you so much. It helps and it works ... View more

i want 252 colums in my table outpu so i expect "251 ; " i for my record ... View more

i want 252 colums in my table outpu so i expect "251 ; " i for my record ... View more

Hello ErikLund_Jensen,   i think i was not enough clear in my replu when am trying to produice an example of my file. there is a part of my file, there are 10 lignes, but am expecting 9 observations. but if process the file with the code, i have 8 lines so 8 observations. i've attach a part of my file Thks ... View more

i just realize that in my file, records end by "."   42 CHAR TESSE;NOMBREDEKM;PRIXTTCDUVEHICULE;ETAPEDUPROJET.PFS;0015211;K;20200425;18:48:58;GMF-K0000015211;Roc ZONE 5455434444544444355455544554444544345454455544450545333333333433333333333333333334442433333333333566 NUMR 45335BEFD22545BDB029844345658935C5B541054502FA54A063B0015211BBB20200425B18A48A58B7D6DB0000015211B2F3 43 ketLawyer;218ab553c7f34dd8;RocketLawyer-DocumentJuridique;;;;;;;;;;;;;;;;;Immobilier;;;;;;;;;;;;;;;; 44 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; 45 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Particulier;;;;;;;NON_PJ;;;;;;;;;;; 46 CHAR ;;;;;;;;;;;;;;;;;;;;;;;;;;;.PFS;0015211;K;20200425;18:56:00;GMF-K0000015211;RocketLawyer;19bb4713444 ZONE 3333333333333333333333333330545333333333433333333333333333334442433333333333566667467767333663333333 NUMR BBBBBBBBBBBBBBBBBBBBBBBBBBBA063B0015211BBB20200425B18A56A00B7D6DB0000015211B2F3B54C17952B19224713444 47 9d21f;RocketLawyer-DocumentJuridique;;;;;;;;;;;;;;;;;Immobilier;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; 48 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; 49 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Particulier;;;;;;;NON_PJ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; 50 CHAR ;;;;;;.PFS;0015211;K;20200  every record of my file must begin with PFS ... View more

I have a problem with my code here is an example of my file : 1       PPP;00001;Aa001zz;123;A71 tetstst;a4jgtt;gtrall;grrrr 2       PTP;0002;App01;412; Azer          ( test agerebdb);;; 3       PTP;erfff;Zerrrr;847;derrr;55zer;dfererereer;erffff 4       PTP;erfff;Zerrrr;847;derrr;55zer;dfererereer;erffff   With the code, if execute, i lost the line 3 but i read the line 4 in my table in output ... View more

Hello ErikLund_Jensen    thks you for your propostion yesterday. it work like i want. But can you explain me this part of the code :   else do; put _infile_ @; csum = sum(csum,c); if csum = &expected_delimiters then do; put; csum = 0; end;   If first c ne &expected_delimiters ,  what is done?   thks   ... View more

Thks very much.. ... View more