Thks so much ... View more

am woorkin on viya 3.5 proc cas; table.update / table={caslib='Public',name="&reftable",where=%tslit(%str( upcase(fileref)=upcase("&form_fileref") and upcase(mail)=upcase("&form_mail") and upcase(destination)=upcase("&form_caslib") and upcase(tableout)=upcase("&form_table") ))} set={ {var="actif", value="&value."} }; run; quit; ... View more

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