07-18-2017 12:43 PM
07-18-2017 12:44 PM - edited 07-18-2017 12:45 PM
Why do you have those in the first place? Can you fix your import process ahead of this step instead?
Post a sample of the data set you're trying to import or a fake dataset that will replicate your issue if you want help with code.
07-18-2017 01:41 PM
07-18-2017 10:40 PM
Art, you might be correct, but this is data I created. while importing (proc import) date_time is converting to numeric and while using proc format with picture statement, it is assigned to my library. I am sending the sheet again.
When I use that format in my data , sas log is saying it can't recognize that format (though it is assigned to the library). Could it be because when I am defining proc format (date_time is numeric, with picture statement) and while converting to character it messes up?
07-18-2017 10:46 PM - edited 07-18-2017 10:57 PM
Can't answer your question without seeing the data, the code you used to import it, and the code your talking about now.
Otherwise, we'd just be guessing and possibly misleading you.
Need to see the SAS file that was created as a result of the import. That will let us know what we're dealing with. Can't begin to replicate the process with the file you already sent (twice now as it's the same one as you originally posted), as it doesn't contain any of the characters you are trying to change and, besides, doesn't let us know what happened during the import. I, for one, can't replicate your process because I'm using SAS UE and it doesn't include dbms=excel.
Art, CEO, AnalystFinder.com
07-18-2017 02:03 PM
Art, the fields are character fields only. I checked it again.
Reeza, I posted a dummy dataset in my previous posts. It's just character fields with & ' with names coming off wrong. I don't know if it's SasEG or what? If u know a way to fix while doing proc import please let me know.
How about you help me, help you, by pointing it out rather than having me search through your historical posts?