<calculation as percentage> as my_percent_variable format=percent8.2,
Ok. Please post the full details of your issue, demo code and log that shows what's not working is a good start.
@greg6363 wrote:
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?
Thanks.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.