Hi All,
I am using SAS 9.4 (English). I want to concatenate a numeric variable (call it num_var) and a character variable (call it char_var) as follows:
wanted = cat(char_var,num_var); run;
I understand that CAT concatenates character variables. Here is my question: Must I convert the numeric variable to a character variable prior to running CAT? Or, does SAS convert the numeric variable to a character variable when I run the code?
Thanks for your help.
Tristan
CAT/CATT/CATX/CATS level of functions does do the automatic conversion, but it uses the BEST format, not the format applied to the data.
This type of information will be laid out in the documentation.
specifies a constant, variable, or expression, either character or numeric. If item is numeric, then its value is converted to a character string by using the BESTw. format. In this case, leading blanks are removed and SAS does not write a note to the log.
CAT/CATT/CATX/CATS level of functions does do the automatic conversion, but it uses the BEST format, not the format applied to the data.
This type of information will be laid out in the documentation.
specifies a constant, variable, or expression, either character or numeric. If item is numeric, then its value is converted to a character string by using the BESTw. format. In this case, leading blanks are removed and SAS does not write a note to the log.
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.