Special chars when exporting

[Vuitton13]

SAS does not recognize certain characters when exporting my file, format. csv

Also the decimal parts of the digits are not taken into account.

Enclosed a data capture output when I ran my proc code import datafile

I am a beginner learner

thanks

[Kurt_Bremser]

Your SAS encoding does not match the one of your csv file. Use a fitting encoding= option in the infile statement.

[PeterClemmensen]

I think @Kurt_Bremser has already solved your problem. 

Also, welcome to the SAS communities 🙂 In the future, when you post a question, please do not use headlines like "URGENT HELP PLEASE". The answer will come no sooner from capitalizing 🙂 Use a descriptive title for your problem and help will come sooner than you know it.

[Vuitton13]

OK thanks.

[ballardw]

You might also post a few rows of your CSV file and explain where the decimal issue occurs.

Note: examining CSV files with a spreadsheet program such as Excel is taking chances with  what you will see. Excel may be assuming you don't want to see the decimal portion due to the range of the values. Also you might be running into a national language difference where decimal and comma are treated differently than you expect in either SAS or a spreadsheet program.

If you saved the data from a spreadsheet program you may want to rerun the export as spreadsheets are also known to convert certain types of values without telling you.

[Vuitton13]

Hello and thank you for all your answers. I tried but it didn't work. I was forced to edit my. csv file in Excel. And with regard to commas, SAS has rounded by default or excess numbers. Only that I do not know if this is the right method. I specify that I am a beginner in SAS