<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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.