Hello Jim,   My problem is that I don’t know how to control the futur file. Normaly, after correction, I’ll have only the « CRLF » in the end of observation. For making a test, I would like to put in Notepad ++/Find (« Rechercher » : ‘0A’x) : just to see that I don’t have the soul « LF », but it doesn’t work (the example is attached):   Maybe you know how to check if there are soul « LF ».   Thank you! ... View more

Hello Jim, Thank you very much! Ideally I need the file with « ; » for data delimitation and CRLF for observation delimitation? ... View more

Thank you very much, it’s clear! Last question please : I would like to make a test, replace all CR by LF. How I can do that via Notepad ++. I mean I don’t know how to represent CR and LF. Do I need to use “0A”x and “0D”x? Thank you! ... View more

Hello Jim,   I tried to replace dlm=';'||'0D0A'x by dlm=';'||'0A'x in my code but it doesn't work. 😞 I made a request for data correction. Thank you very much for your help! Marie ... View more

Thank you very much Jim! The solution is perfect. Sorry again to embarrassing you with the bad data:( Best regards, Marie ... View more

Thank you very much Tom, I’ll do that with actual file. I’ll make a request for changing the file, now I understand the problem of this file. Thank you for your advices. Marie ... View more

Thank you very much Jim, I’m totally agree with you! I must fixe the format of file. I had also the confirmation of @Tom that it’s the bad data, so I can argument my request of changing the file. Marie ... View more

Thank you Jim, I see! I thought that there is some solution because my code works for line with “vide” at the end. Without “vide” I had a gap. Unfortunately I need to use this file this month:( ... View more

Thank you Jim! I did'nt understand why with LF "here is no way to tell the difference between a value separator and the end of a record."? ... View more

Hello Jim, I asked the new csv file, they did some correction. My original code is working, but there is some lag from the line 515.   Do you know, please some option, to avoid this lag?   Thank you very much! /*****Importation*****/ data EUROPERF_IMP1; dlm=';'||'0D0A'x; infile "XXXX\Marie_Eligibles_c.csv_20200910 (2).csv" dlm=dlm DSD lrecl=32867 /*termstr=CRLF*/ RECFM=n; informat CodeIsin $12.; informat Libelle $50.; informat nature $12.; informat categAMF $32.; informat categEPF $50.; informat zoneGeo $40.; informat dureeMinReco $8.; informat affectationResultat $40.; informat fiscaliteText $50.; informat deviseComptable $3.; informat dateCloture $32.; informat dateOuverture $32.; informat promoteur $50.; informat adressePromoteur $80.; informat steGestion $70.; informat adresseSteGestion $80.; informat steAdmDelegue $80.; informat steFinAdmDelegue $80.; informat depositaire $80.; informat adresseDepositaire $80.; informat commissaireCpte $50.; informat souscription $100.; informat rachat $50.; informat fraisGestion $70.; informat datePerformance $12.; informat perf12mois best32.; informat perf36mois $5.; informat perf60mois $5.; informat fraisGestionCommentaire $256.; informat objectifGestion $256.; informat souscripteurs $256.; informat orientationPlacement $256.; informat dateClotureExercice $256.; informat periodeVL $256.; informat sitePublication $256.; informat conditionSouscripRachat $256.; informat dateValidation $12.; informat minimumRisqueAction $5.; informat dateAgrementAMF $12.; informat Tfe $20.; informat perfAm1 $8.; informat perfAm2 $8.; informat perfAm3 $8.; informat perfAm4 $8.; informat perfAm5 $8.; informat perfAm6 $8.; informat perfAm7 $8.; informat perfAm8 $8.; informat UnitedureeMinReco $7.; informat perfYTD $5.; informat volat_12mois $5.; informat frequence_text $30.; informat prospectus_url $50.; informat jour_valorisation $8.; informat risque $6.; informat VIDE $4.; format CodeIsin $12.; format Libelle $50.; format nature $12.; format categAMF $32.; format categEPF $50.; format zoneGeo $40.; format dureeMinReco $8.; format affectationResultat $40.; format fiscaliteText $50.; format deviseComptable $3.; format dateCloture $32.; format dateOuverture $32.; format promoteur $50.; format adressePromoteur $80.; format steGestion $70.; format adresseSteGestion $80.; format steAdmDelegue $80.; format steFinAdmDelegue $80.; format depositaire $80.; format adresseDepositaire $80.; format commissaireCpte $50.; format souscription $100.; format rachat $5.; format fraisGestion $70.; format datePerformance $12.; format perf12mois best32.; format perf36mois $5.; format perf60mois $5.; format fraisGestionCommentaire $256.; format objectifGestion $256.; format souscripteurs $256.; format orientationPlacement $256.; format dateClotureExercice $256.; format periodeVL $256.; format sitePublication $256.; format conditionSouscripRachat $256.; format dateValidation $12.; format minimumRisqueAction $5.; format dateAgrementAMF $12.; format Tfe $20.; format perfAm1 $8.; format perfAm2 $8.; format perfAm3 $8.; format perfAm4 $8.; format perfAm5 $8.; format perfAm6 $8.; format perfAm7 $8.; format perfAm8 $8.; format UnitedureeMinReco $7.; format perfYTD $5.; format volat_12mois $5.; format frequence_text $30.; format prospectus_url $50.; format jour_valorisation $8.; format risque $6.; format VIDE $4.; input CodeIsin $ Libelle $ nature $ categAMF $ categEPF $ zoneGeo $ dureeMinReco $ affectationResultat $ fiscaliteText $ deviseComptable $ dateCloture $ dateOuverture $ promoteur $ adressePromoteur $ steGestion $ adresseSteGestion $ steAdmDelegue $ steFinAdmDelegue $ depositaire $ adresseDepositaire $ commissaireCpte $ souscription $ rachat $ fraisGestion $ datePerformance $ perf12mois perf36mois $ perf60mois $ fraisGestionCommentaire $ objectifGestion $ souscripteurs $ orientationPlacement $ dateClotureExercice $ periodeVL $ sitePublication $ conditionSouscripRachat $ dateValidation $ minimumRisqueAction $ dateAgrementAMF $ Tfe $ perfAm1 $ perfAm2 $ perfAm3 $ perfAm4 $ perfAm5 $ perfAm6 $ perfAm7 $ perfAm8 $ UnitedureeMinReco $ perfYTD $ volat_12mois $ frequence_text $ prospectus_url $ jour_valorisation $ risque $ VIDE $; run;   ... View more

Sorry, I have another question please 🙂 I don't understand the line: call symputx ('SYSCC', 8, 'G'); Thank you very much! ... View more

Hello, Thank you! I can't undersatand the "LENGTH= Rec_Leng", I understood the other lines. ... View more

Thank you! I’ll try to run this code! ... View more

Yes, I’ll try it! Would be great if it works because I can’t change the structure of file 😞 Thank you very much! ... View more