Can we use CAT Function on numeric columns?
And what is the difference between CATS, CATX and CATT functions.
I am getting confuse between these function.
And what is the data type of the resulted values
Can we use CAT Function on numeric columns?
Yes, but it applies the BEST function to convert them and that may not be what you want. Especially if you have dollars or comma's in your data.
For the other functions, check out this paper, it's 15 page so a bit longer but covers them in detail. In general, if you need information on a specific topic, search that topic on lexjansen.com and you'll find a ton of resources:
http://support.sas.com/resources/papers/proceedings10/205-2010.pdf
SAS CATS documentation, specifically see the "comparisons" and "see also" sections which link you to related functions and highlights the differences.
@Nidhi_vats wrote:
Can we use CAT Function on numeric columns?
And what is the difference between CATS, CATX and CATT functions.
I am getting confuse between these function.
And what is the data type of the resulted values
(Sounds like a test question)..
@Nidhi_vats - do some basic research of your own, maybe even try out some examples. By the time you typed out your question, you probably could have Google'd the answer.
If there's something you've found & don't understand, or want to discuss pros & cons of the various functions (and also the concatenation operators (!!, ||, etc), post here and then let's talk..
Can we use CAT Function on numeric columns?
Yes, but it applies the BEST function to convert them and that may not be what you want. Especially if you have dollars or comma's in your data.
For the other functions, check out this paper, it's 15 page so a bit longer but covers them in detail. In general, if you need information on a specific topic, search that topic on lexjansen.com and you'll find a ton of resources:
http://support.sas.com/resources/papers/proceedings10/205-2010.pdf
SAS CATS documentation, specifically see the "comparisons" and "see also" sections which link you to related functions and highlights the differences.
@Nidhi_vats wrote:
Can we use CAT Function on numeric columns?
And what is the difference between CATS, CATX and CATT functions.
I am getting confuse between these function.
And what is the data type of the resulted values
@Nidhi_vats wrote:
Can we use CAT Function on numeric columns?
And what is the difference between CATS, CATX and CATT functions.
I am getting confuse between these function.
And what is the data type of the resulted values
Are CAT and CATQ functions included in the confusion? How about the || operator?
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.