10-05-2017 02:06 PM
10-05-2017 02:49 PM
10-05-2017 02:51 PM - edited 10-05-2017 02:51 PM
Ok. Please post the full details of your issue, demo code and log that shows what's not working is a good start.
That's what I used and I get the following error:
CLI describe error: [Microsoft][SQL Server Native Client 11.0][SQL Server] Incorrect syntax near 'format'. : [Microsoft][SQL Server Native Client 11.0][SQL Server] Statement(s) could not be prepared.
I'm not querying on a SAS server. I am querying tables on a SQL server so the SAS language will not work.
What SQL code can be used in SAS to properly format a field that calculates a percentsges?
10-05-2017 03:17 PM
10-05-2017 03:21 PM
If you're using pass through SQL then it needs to be in a format that the server understands. Since you're using MS SQL (T-SQL) see what Microsoft requires. Or format it after you bring it into SAS using PROC DATASETS.