SAS Support Communities

Thank you so much for your help! it's exactly of what I expected. ... View more

I think you are right, it's not just a space from the original file. it must be something in there? but I like the code you sent.   Thank you.   ... View more

after look into the original file, I realized that there is one "text: field have "space" in the value, for example:  this original file: (this is not a real data, the actual data have more variables including date field). ID visit value1  Name value3 value4 100 1 Asia Lita wong Honda credit 200 1 USA Irene Tesla cash the "Name'"="Lita Wong" have a space in between. so when I export it to csv file, the the 'Name' shift to next row. I did not realize it shifted to the next row, I thought it was missing ID and visit after export to csv file.   the output of csv looks like this: ID visit value1  Name value3 value4 100 1 Asia Lita     wong Honda credit       200 1 USA Irene Tesla cash   so after I deleted the space, from Lita Wong to Litawong, the csv file looked like this: ID visit value1  Name value3 value4 100 1 Asia Litawong Honda credit 200 1 USA Irene Tesla cash  this is  what i expected, and then I saved it to excel file. ... View more

Thank you all for the nice comment and useful information. I really appreciate for your time.   I have figured it, by cleaning the raw file, every thing is going well!     ... View more

I have tried it, but the output did not hold the format. especially for date, it showed numbers instead of mm/dd/yy. ... View more

if I export to excel file, all are going well. The only issue is, the output excel file cannot hold the format that I run in the code. for example; 1 = yes, 2 = no.  in the output excel file, it will show as 1, and 2, but I need it shows 'Yes' ans "No".   the reason I'm using output csv is, the output file will show "Yes" and "No", and then I convert it to excel file. ... View more