<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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.