I have a text prompt called &person that selects a name like Smith, Sally that I would like to output in my report in sas eg.
I tried creating a calculated field with &PROSPECT_STAFF prompt value. It is picking up the value, but is confused by the comma.
I suspect I need a put or input statement? Here is the error after I tried defining it with $CHAR40.

Any help is appreciated.
Thanks
Quotes
"&prospect_staff" as...
So thankful! I was using single quotes, trying to use input, put statements to change the data type! Thanks so much!
So to be clear, for anyone following up on this--
I created a text prompt that generated a variable &Prospect_Staff
To output it in the report, I created a calculated field with just "&Prospect_Staff", with no additional formats!
Works great, thanks to Reeza!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.