topic Re: URGENT HELP PLEASE!! in New SAS User

Special chars when exporting

Vuitton13 — Mon, 14 Jan 2019 19:07:05 GMT

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

Re: URGENT HELP PLEASE!!

Kurt_Bremser — Sat, 12 Jan 2019 16:05:02 GMT

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

Re: URGENT HELP PLEASE!!

PeterClemmensen — Sat, 12 Jan 2019 16:17:32 GMT

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.

Re: URGENT HELP PLEASE!!

ballardw — Mon, 14 Jan 2019 16:47:52 GMT

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.

Re: Special chars when exporting

Vuitton13 — Wed, 16 Jan 2019 09:27:41 GMT

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

Re: URGENT HELP PLEASE!!

Vuitton13 — Wed, 16 Jan 2019 09:28:40 GMT

OK thanks.