02-06-2015 06:08 AM
Hi,
I have an interesting problem. In some datasets I have received, there is a variable present CTS$REASON which does not conform to SAS standards for variable names. I have no idea how they have managed to get this variable name there. I can open the dataset in SAS Viewer but any operation I do in SAS fails as this variable is not valid. Any thoughts on how to process this other than exporting as CSV from SAS viewer and importing again?
Thanks
02-06-2015 06:14 AM
To add some further information it appears that I can use proc sql to select the other variables in the dataset and put them out to a new dataset, however its quite a pain as I want 59 of the 60 variables, and the tables with invalid variable don't show up in the metadata so cant generate the code
Ok, have found the issue, its an option that EGuide has set which Base does not:
Thanks
02-06-2015 06:14 AM
To add some further information it appears that I can use proc sql to select the other variables in the dataset and put them out to a new dataset, however its quite a pain as I want 59 of the 60 variables, and the tables with invalid variable don't show up in the metadata so cant generate the code
Ok, have found the issue, its an option that EGuide has set which Base does not:
Thanks
Need further help from the community? Please ask a new question.