hi,
My frnd works SAS and he said the function contain()..
data xxx.
input xxx;
datalines;
12
134
222
23
;
run;
data want;
set xxx;
where xxx = cotain()........................................please let me know ,,, if this functions exists or not if it is ..please help me with PROPER syntax..
;
Regards,
Allu
Hi,
I can't find a contains function, but the contains operator does exist, and can be used as follows, for example:
data have;
input text $;
datalines;
abc
ab
abcd
abcde
;
run;
data want;
set have;
where text contains "cd";
run;
Regards,
Amir.
thanks Amir....is there any chance that this is in new versions???? like 9.3 or 9.4??
................contain().........
example
data xxx;
input aaa;
12
2
131
22;
runl
where num = contain(1)......./*Returns the 12 , 131 ....*/
or
where num = cotain(12).........../*Returns the 12
I am sorry for syntax errors...............but please check for functions ...??
......................will Any body in community help me....................
You simply use Google with a search string like "site:support.sas.com contains" and one of the first links will give you something like SAS(R) 9.2 Language Reference: Concepts, Second Edition
After that it's just RTM.
Hi,
I would echo what Patrick is saying and further recommend you familiarise yourself with navigating your way through the manual.
For 9.3 you can look at:
SAS(R) 9.3 Language Reference by Name, Product, and Category
and use the left hand pane to navigate to Functions -> General Functions -> Alphabetic Listing to see all of the functions available.
As far as 9.4 is concerned, perhaps try contacting SAS Technical Support.
Regards,
Amir.
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.