topic Re: function ...contain() in SAS Programming

function ...contain()

allurai0412 — Wed, 22 May 2013 10:56:48 GMT

hi,

My frnd works SAS and he said the function contain()..

data xxx.

input xxx;

datalines;

134

222

;

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

Re: function ...contain()

Amir — Wed, 22 May 2013 11:55:50 GMT

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

abcd

abcde

;

run;

data want;

set have;

where text contains "cd";

run;

Regards,

Amir.

Re: function ...contain()

allurai0412 — Wed, 22 May 2013 12:07:18 GMT

thanks Amir....is there any chance that this is in new versions???? like 9.3 or 9.4??

................contain().........

example

data xxx;

input aaa;

131

22;

runl

where num = contain(1)......./*Returns the 12 , 131 ....*/

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....................

Re: function ...contain()

Patrick — Wed, 22 May 2013 12:12:49 GMT

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.

Re: function ...contain()

Amir — Wed, 22 May 2013 12:30:31 GMT

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.