I am working with a dataset that contains variables like customer ID and unit ID. I would like to remove space between them and add an underscore to be like customer_ID and unid_ID.
Thanks for your help!
How did you obtain the data set?
If you read it in from csv or Excel add this option and re-import the file.
options validvarname=v7;
@Mariloud wrote:
I am working with a dataset that contains variables like customer ID and unit ID. I would like to remove space between them and add an underscore to be like customer_ID and unid_ID.
Thanks for your help!
How did you obtain the data set?
If you read it in from csv or Excel add this option and re-import the file.
options validvarname=v7;
@Mariloud wrote:
I am working with a dataset that contains variables like customer ID and unit ID. I would like to remove space between them and add an underscore to be like customer_ID and unid_ID.
Thanks for your help!
It worked great! Thank you!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.