f



Re: How to search list of particular text values into free text #3

This one may not be efficient when look up table are big,
but at least it saves your typing:

proc sql;
create table xx as
select distinct a.srno,a.order_details,
max(case when a.order_details contains trim(b.types) then b.types else ''
end) as btype
from large_table a, smalltable b
group by a.srno
order by a.srno
;

proc print;
run;

Srno Order_details                           btype

 1   The order of Mangos ..                  Mangos
 10  Retured all Potatoes ..                 Potatoes
 2   The returned order ..                   Mangos
 3   Order for the Oranges ..                Oranges
 4   new container for the Onions ..         Onions
 5   Boxes of Grapes received ..             Grapes
 6   Almonds boxes received ..               Almonds
 7   Dry fruits received on last ..          Dry fruits
 8   Spinach were tossed out ..              Spinach
 9   Begs of Potatoes received ..            Potatoes


On Mon, 18 Jun 2007 13:29:55 -0400, SUBSCRIBE SAS-Nim Pat
<Npp1129@GMAIL.COM> wrote:

>On Mon, 18 Jun 2007 12:02:45 -0400, SUBSCRIBE SAS-Nim Pat
><Npp1129@GMAIL.COM> wrote:
>
>>Hi All,
>>Please if anyone has idea about how to search particular list of text
>>values from one small table to free text variable in large dataset and
>>when finds the value, update the large dataset.
>>I have small lookup table (around 120 records) for example:
>>Category   Types;
>>
>>Type_1 Mangos,
>>Type_1 Pineapples,
>>Type_2 Onions,
>>Type_2 Tomatoes,
>>…
>>
>>Type_n typeN.
>>
>>
>>Now I need to search each particular text values (variable-Types) from the
>>above small table into my large dataset which has free text variable
>>called “Order_details”.
>>For example:
>>Order_details: The last order was for the Mangos on Nov 11 2006.
>>
>>
>>I’m using following code but it’s not efficient:
>>PROC SQL;
>>Create table new_Main_Table AS
>>SELECT *,
>>Case
>>when Order_details contains (‘Mangos’) then “Type_1”
>>when Order_details contains (‘Pineapples’) then “Type_1”
>>when Order_details contains (‘Onions’) then “Type_2”
>>when Order_details contains (‘Tomatoes’) then “Type_2”
>>.
>>.
>>.
>>when Order_details contains (‘typeN’) then “Type_n”
>>Else “ “
>>End As order_Types
>>From Main_table ;
>>Quit;
>>Run;
>>
>>Thanks for your time and help,
>>I really appreciate your effort,
>>Nim
>
>Guys Sorry for the Inconveniencies. I'm attaching sample table.
>my Small lookup table:
>Data SmallTAble ;
>Length Category Types $ 25 ;
>Input Category Types;
>Cards ;
>Type_1 Mangos
>Type_1 Oranges
>Type_1 Pineapples
>Type_1 Peaches
>Type_1 Pears
>Type_1 Kiwis
>Type_1 Grapes
>Type_2 Onions
>Type_2 Tomatoes
>Type_2 Carrots
>Type_2 Carrots
>Type_2 Celery
>Type_2 Potatoes
>Type_2 Spinach
>Type_3 Almonds
>Type_3 Cashews
>Type_4 Dry fruits
>;
>
>And My LARGE Table with Free Text variable :
>
>Data Large_table ;
>Length Srno $4 Order_details $400 ;
>Input Srno  Order_details ;
>Cards ;
>
>1 The order of Mangos dispatched on Nov. 11 2006
>2 The returned order received from the customer for Mangos was on
>Dec. 12 2006
>3  Order for the Oranges dispatched on Nov. 26 2006
>4 new container for the Onions received from NJ on Dec. 1 2006
>5 Boxes of Grapes received from FL on Dec 2007
>6 Almonds boxes received from IL on Nov. 2006
>7 Dry fruits received on last month were dispatched to NJ on dec.
>2006
>8 Spinach were tossed out from the store on Nov. 2006
>9 Begs of Potatoes received from FL on Nov. 2006
>10 Retured all Potatoes to company on Dec 2006
>
>Thanks,
>Nim Pat
0
ya.huang (1962)
6/19/2007 4:27:45 AM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
537 Views

Similar Articles

[PageSpeed] 13

Reply:

Similar Artilces:

Re: How to search list of particular text values into free text
On Mon, 18 Jun 2007 12:02:45 -0400, SUBSCRIBE SAS-Nim Pat <Npp1129@GMAIL.COM> wrote: >Hi All, >Please if anyone has idea about how to search particular list of text >values from one small table to free text variable in large dataset and >when finds the value, update the large dataset. >I have small lookup table (around 120 records) for example: >Category Types; > >Type_1 Mangos, >Type_1 Pineapples, >Type_2 Onions, >Type_2 Tomatoes, >… > >Type_n typeN. > > >Now I need to search each particular text values (variable-Types) from the >above small table into my large dataset which has free text variable >called “Order_details”. >For example: >Order_details: The last order was for the Mangos on Nov 11 2006. > > >I’m using following code but it’s not efficient: >PROC SQL; >Create table new_Main_Table AS >SELECT *, >Case >when Order_details contains (‘Mangos’) then “Type_1” >when Order_details contains (‘Pineapples’) then “Type_1” >when Order_details contains (‘Onions’) then “Type_2” >when Order_details contains (‘Tomatoes’) then “Type_2” >. >. >. >when Order_details contains (‘typeN’) then “Type_n” >Else “ “ >End As order_Types >From Main_table ; >Quit; >Run; > >Thanks for your time and help, >I really appreciate your effort, >Nim Guys Sorry for the Inconveniencies. I'm attaching sample table. my Small lookup table: Data SmallTAble ; Le...

Re: How to search list of particular text values into free text #2
Sorry, there was a minor error, b.types should be b.category: proc sql; create table xx as select distinct a.srno,a.order_details, max(case when a.order_details contains trim(b.types) then b.category else '' end) as btype from large_table a, smalltable b group by a.srno order by a.srno ; proc print; run; Srno Order_details btype 1 The order of Mangos .. Type_1 10 Retured all Potatoes.. Type_2 2 The returned order .. Type_1 3 Order for the Oranges .. Type_1 4 new container for the Onions .. Type_2 5 Boxes of Grapes received .. Type_1 6 Almonds boxes received .. Type_3 7 Dry fruits received on .. Type_4 8 Spinach were tossed out .. Type_2 9 Begs of Potatoes .. Type_2 On Tue, 19 Jun 2007 00:27:45 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote: >This one may not be efficient when look up table are big, >but at least it saves your typing: > >proc sql; >create table xx as >select distinct a.srno,a.order_details, >max(case when a.order_details contains trim(b.types) then b.types else '' >end) as btype >from large_table a, smalltable b >group by a.srno >order by a.srno >; > >proc print; >run; > >Srno Order_details btype > > 1 The order of Mangos .. Mangos > 10 Retured all Potatoes .. Potatoes > 2 The returned o...

How to search list of particular text values into free text
Hi All, Please if anyone has idea about how to search particular list of text values from one small table to free text variable in large dataset and when finds the value, update the large dataset. I have small lookup table (around 120 records) for example: Category Types; Type_1 Mangos, Type_1 Pineapples, Type_2 Onions, Type_2 Tomatoes, … Type_n typeN. Now I need to search each particular text values (variable-Types) from the above small table into my large dataset which has free text variable called “Order_details”. For example: Order_details: The last order was for the Mangos on Nov 11...

Re: Searching for partial text in character variables in SAS #3
hi ... in addition to Nat's suggestion, you could also look at the FIND function (it may be more intuitive to FIND a string rather INDEX a string, but that's just me!) as Nat mentioned, if you are concerned whether case would cause you to miss a match, the FIND functions allows you to ignore case by specifying another argument ('i' for ignore case) data x; input string $50.; i = index(string,'insur'); * ignore case when searching; f = find(string,'insur','i'); datalines; i am insured I AM NOT INSURED sure, I'm Insured i'm sure of that ; run; gives ... Obs string i f 1 i am insured 6 6 2 I AM NOT INSURED 0 10 3 sure, I'm Insured 0 11 4 i'm sure of that 0 0 -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > Rieza > > The INDEX function should work for you: > > INDEX (src,str) first position of string str located in string src > > In your case a statement such as > > If INDEX( notes , 'INSUR' ) then ... > > where notes is the name of the variable and INSUR is the string that you > are seeking. I left blank the outcome of the statement but most likely > would want to select only these records so you would write > > If INDEX( notes , 'INSUR' ); > > You don't really care what the position of...

Re: Exporting a SAS data set to Text file on SAS unix #3
hi ... actually, what I posted earlier was too much code (sorry) this is enough (a bit more succinct) * variable names into a macro variable (tab separated); proc sql noprint; select name into :vars separated by '09'x from dictionary.columns where libname eq 'SASHELP' and memname eq 'CLASS' order varnum; quit; data _null_; file 'z:\class.txt' dsd dlm='09'x ; if _n_ eq 1 then put "&vars"; set sashelp.class; put (_all_) (:); run; -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402...

text-text
Wondering how what I input to my UTF-8 terminal gets passed along through my patched [1] trn ... Cyrillic: А Б В Г Д Е Ж З И Й К Л М Н О П а б в г д е ж з и й к л м н о п IPA: ᴀ ᴁ ᴂ ᴃ ᴄ ᴅ ᴆ ᴇ ᴈ ᴉ ᴊ ᴋ ᴌ ᴍ ᴎ ᴏ ɀ Ɂ ɂ Ƀ Ʉ Ʌ Ɇ ɇ Ɉ ɉ Ɋ ɋ Ɍ ɍ Ɏ ɏ [1] https://groups.google.com/d/msg/comp.sys.raspberry-pi/7Z37Hdrm0DM/6aqD-reXFzAJ ...

Re: SAS Text Editor #3
I got the add ons from the text pad website. Thanks anyway. If there is any other better free editor, please let me know. Cherish cherish k <hawks_cherish@yahoo.co.in> wrote: Hi Dan, Thanks for the reply. I too use Textpad but I don't know how to how to set it up so that it can highlight for the SAS syntax. How to configure it for the SAS extension syntax. Thanks Cherish "Nordlund, Dan (DSHS/RDA)" <NordlDJ@dshs.wa.gov> wrote: > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of cherish k > Sent: Monday, April 28, 2008 10:43 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: SAS Text Editor > > Can somebody direct me to a good SAS text editor for Windows. > Basically I need for just syntax highlighting (I don't need > an editor with prompts etc). > > Thanks > Cherish > > Cherish, If all you need is syntax highliting, I would recommend Textpad (what I use on a regular basis) or UltraEdit (an excellent editor). I am sure others will soon list their favorites. Hope this is helpful, Dan Daniel J. Nordlund Research and Data Analysis Washington State Department of Social and Health Services Olympia, WA 98504-5204 --------------------------------- Save all your chat conversations. Find them online. --------------------------------- Get the freedom to save as many mails as you wish. Click here to know how. ...

Re: SAS/AF
Wrapping works if you have the justification set to left and do not display the horizontal scroll bar. Kind regards, Rob Workman -----Original Message----- From: RH Savanur [mailto:r_savanur@YAHOO.COM] Sent: Friday, September 17, 2004 9:08 AM To: SAS-L@LISTSERV.UGA.EDU Subject: SAS/AF - How to enable text wrapping in Text pad..? Hi, Is there any facility for automatic text wrapping for "TEXTPAD" component..? Thanks in advance. Regards, Savanur ===================================================================== This message contains confidential information intended only fo...

text + text
What is "text + text" supposed to do right now? It doesn't seem very useful to me. What about making "text + text" as an equivalent for "text || text"? Most strongly-typed programming languages do this. And MS SQL Server too, I think (CMIIW). -- dave ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Am Freitag, 8. Oktober 2004 12:57 schrieb David Garamond: > What is "text + text" supposed to do right now? Nothing. > What about making "text + text" as an equivalent for "text > || text"? Most strongly-typed programming languages do this. And MS SQL > Server too, I think (CMIIW). What would this gain except for bloat? It's not like SQL is utterly compatible with any programming language; users will still have to learn all the operators anyway. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Peter Eisentraut wrote: >>What is "text + text" supposed to do right now? > > Nothing. Then are these bugs? (7.4.5 and 8.0.0beta1 give same results). Frankly, the current behaviour is quite strange to me. ------------------ =...

Re: Text Date To SAS Date? #3
On Wed, 31 Oct 2007 13:24:27 -0500, data _null_, <datanull@GMAIL.COM> wrote: >The YMDdttm informat may be what you want. See http://support.sas.com/kb/15/803.html It appears that the minimum width for this format is 13 (because it really expects to see the time subfield), so there are situations where it will not be able read just a date value. Here is an alternative: data _null_; y = 'yyyy-mm-dd'; y = '2007-10-31'; dt = dhms(input(y,yymmdd10.),0,0,0); format dt datetime20.; put (_all_)(=); run; > >1328 data _null_; >1329 y = 'yyyy-mm-dd'; >1330 y = '2007-10-31'; >1331 dt = input(y,ymddttm.); >1332 format dt datetime20.; >1333 put (_all_)(=); >1334 run; > >y=2007-10-31 dt=31OCT2007:00:00:00 > > >Notice the TIME part is 0 which may or may not be useful for you. > >On 10/31/07, Jonathan Wolgamuth <jonwolgamuth@gmail.com> wrote: >> I've looked around quite a bit and am finding that this question comes up >> quite a bit, however, I'm flummoxed on how to get it to work on a field I'm >> working with. >> >> Basically, the field (eff_dt) is a 10 character text field in this format. >> yyyy-mm-dd >> >> I need to convert this field to a DATETIME20. field so I can compare it to >> another field that is already set to that format. >> >> Should I parse out t...

Re: Indenting text in SAS editor? #3
Mark the text, press the tab indent putton or Mark the text Press the Shift TAb to decrease teh indent level Works for me ---- David Wright <David_wright@SPRA.COM> wrote: > rolandberry@hotmail.com (RolandRB) wrote in > <1162331780.609358.291340@b28g2000cwb.googlegroups.com>: > > > > >David Wright wrote: > >> Is there a quick way to indent a range of text in the (enhanced) SAS > >> editor? > >> > >> How about submitting text? > >> > >> -Using SAS 9.1 for windows xp2 > > > >Isn't it done by...

Re: reading text field into sas #3
Hi Jamil, From SAS 8.x character variables may be maximally 32k bytes long, I think either 32767 or 32768 characters. Regards - Jim. -- .. . . . . . . . . . . . . . . . Jim Groeneveld, MSc. Biostatistician Science Team Vitatron B.V. Meander 1051 6825 MJ Arnhem Tel: +31/0 26 376 7365 Fax: +31/0 26 376 7305 Jim.Groeneveld@Vitatron.com www.vitatron.com Showing statistically significant differences between football teams, generally all sporters, requires larger samples than usually applied. [common disclaimer] -----Original Message----- From: Jamil Ibrahim [mailto:jibrahim@i...

RE: [SPAM] - Re: [SPAM] - Re: Serialize wxList - Found word(s) list error in the Text body
Hi Jorgen your approach is modelled along the MFC serialization idea, the approach = I mentioned is based on the XTI metadata provided for an object. So the = streaming itself is not coded anymore, but the metadata for a new class = is. The streaming process now iterates over the attributes, processes = callbacks that avoid streaming out undesired attributes (eg x and y in a = sizer dialog), suppresses default values etc. This also means that the = streaming in survives missing attributes, as long as they are either not = mandatory params for ::Create or have a default value. B...

Can I use SAS to search and replace a piece of text in, say, 1000 text files?
How can I use SAS to search and replace a piece of text in, say, 1000 text files? Thanks for letting me know. Toby ...

Re: How to handle very large text strings in SAS ?? #3
On Fri, 11 Nov 2005 14:16:37 -0800, David L Cassell <davidlcassell@MSN.COM> wrote: >If you are trying to do genetic anlayses, or soemthing which can be treated >as if >it were anlaysis of DNA strings, then you might want to look into >SAS/Genetics. .... Or, just load the txt file into a (*real*) editor and do repeated search/find. A text file of 10 million characters are not even 10 mega byte large. My emacs (even on windows) handles it very well and I used it to verify my sas code posted... (now that sounds so wrong...) This is definitely a Friday-only answer... :-) Cheer...

Re: Saving values in a format in text form #3
Look at the options CNTLOUT and CNTLIN on PROC FORMAT - they deal with how you get the formats in a dataset and then back into the format catalog from a dataset. That's probably the easiest way to deal with your root question. -Joe On Tue, Feb 9, 2010 at 2:20 PM, White, Svend A. <SvendW@health.ok.gov>wrote: > I need to tweak some formats that are currently in use and as part of > the process am extracting all the existing formats and creating a new > setup script (which hopefully won't get lost this time). > > Here's the process I'm using. > 1. Execu...

Re: Searching for partial text in character variables in SAS
Rieza The INDEX function should work for you: INDEX (src,str) first position of string str located in string src In your case a statement such as If INDEX( notes , 'INSUR' ) then ... where notes is the name of the variable and INSUR is the string that you are seeking. I left blank the outcome of the statement but most likely would want to select only these records so you would write If INDEX( notes , 'INSUR' ); You don't really care what the position of the string is other than you want a value other than zero which would mean that the string was not found. You may want to convert the notes file to either upper or lower case -- ie, notes = upcase(notes ); -- in order to simplify the search. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Rieza Soelaeman <rsoelaeman@GMAIL .COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Searching for partial text in character variables in SAS 10/16/2008 10:55 AM Please respond ...

Re: Changing from Text to Value for a bunch of variables #3
If you can clarify how this is going to be used, it will be helpful. If you are going to simply display them as 1 and 0 in a report, you can do that with a format. If you are going to use them for analysis, then you will have to change the variable type from character to numeric. That too is possible, but only at the expense of actually creating a new variable and renaming it to the old variable. You already have an answer for the latter. If it the former then: proc format ; value $yesno "YES" = "1" "NO" = "0" "Yes" = "1" "No" = "0" ; run ; title "After Format" ; proc print ; format c1 - character - c4 $yesno. ; run ; This assumes that the variables of interest are the only character variables that exist in the PDV between the two variables mentioned in the format statement. Yes, numeric variable can exist in between without doing any harm. _________________________________ Venky Chakravarthy E-mail: swovcc_AT_hotmail_DOT_com -----Original Message----- From: jsl [mailto:nospam@NOSPAM.COM] Sent: Tuesday, September 02, 2003 8:50 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Changing from Text to Value for a bunch of variables I have about 20-30 variables in a large dataset that take on the value "YES" or "Yes" and "No" or "NO". I would like to very quickly and easily change them all to numeric va...

Re: Inputting Date/Time Values Stored As Text #3
I wonder why you didn't find is8601dt On 5/11/07, Peter Crawford <peter.crawford@blueyonder.co.uk> wrote: > On Fri, 11 May 2007 10:25:34 -0700, Scott Barry <sbarry@SBBWORKS.COM> > wrote: > > >On May 11, 12:21 pm, "Deborah Testa" <dte...@sevenofninesystems.com> > >wrote: > >> Hello, > >> > >> I am working with a data file that stored date/time values as text like > >> this: > >> > >> 2005-08-01 17:52:33 > >> > >> Is there a quick way to get this into a datetime variable without > >> parsing the two pieces? > >> > >> Thanks, > >> > >> Deborah > > > >In a DATA step, use the INPUT statement to read up the two fields > >using the appropriate "date" and "time" INFORMAT, and then combine > >them into a "datetime" variable using the DHMS function, substituting > >the "time" variable as the Seconds argument of DHMS, and use "0" for > >the Hour and Minute arguments. > > > >Scott Barry > >SBBWorks, Inc. > > > Hi Scott > > I've been using the SAS9 sashelp.vformat resource to search for correct > informats. > > The code > data test ; > set sashelp.vformat ; > where fmttype='I' ; *just informats; > where also fmtname ne:'$' ; * and not character informats; >...

Re: SAS term: character string, text expression #3
Don't Lisp, Forth, and related programming languages allow all sorts of liberties in definitions of functions and procedures? As I recall, a Lisp EVAL() function attempts to execute any expression. As for the lack of a distinction between variables and program, OOP deliberately blurs that faint line. Perhaps SAS in this case, as with logical expressions, blazed the trail into 4th generation programming languages. I don't recall a specific point at which the SAS language evolved into a compile-and-go language with step boundaries, or who led that effort. By the time programmers began r...

Re: Spit out formatted text of a specific value in dataset #3
Hmmm not needing anyother dat ais a but odd but okay: Data Sample ; Input Id Name $ ; Cards ; 1 John 2 Jean 3 Jane ; Run ; FileName Title '/export/home/dunnt/Test.HTML' ; Data _Null_ ; Set Sample ( Where = ( ID = 2 ) ) ; File Title ; Put '<H1>' Name '</H1>'; Run ; You could do this through pure macro code but that seems a but extreme unless there is some other circumstances where it is needed. Toby Dunn Two wrongs are only the beginning. Success always occurs in private and failure in full view. Experience is something you don't get until just after you need it. From: webonomic <webonomic@GMAIL.COM> Reply-To: webonomic <webonomic@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Spit out formatted text of a specific value in dataset Date: Thu, 23 Aug 2007 13:51:50 -0700 That #ByVal(n) is awesome. Found a great reference to it here (http:// www.google.ca/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fwww.lexjansen.com%2Fpharmasug%2F2006%2Ftechnicaltechniques%2Ftt01.pdf&ei=IvPNRsyYH4GGgAOi0NiJDw&usg=AFQjCNGptwSMl5RU2ln58qGEm1amD3-LpA&sig2=YqKsLwwzVwcpn45WSNrOBw) Thanks for pointing it out. Some simple macro work will get me much closer to what I am after. Okay, so we have our basic version: ---------------- data sample; input Id Name; cards; 1 John 2 Jean 3 Jane ; run; ods html file = 'c:\_webout.html'; * Win ; title 'This is my title' #ByVar(Id) proc print d...

Re: input or list question on reading in a text file? #3
Dear SAS-L-ers, Jerry L Diebal posted the following: > I have a file that has data like what is in the cards datastep below: > /**********************************/ > data test; > input datastuff $ ; > keep datastuff ; > cards; > 111111-911 > 000111111 > 000038 > NAME OF CITY > 2 > 0 > 10/31/2007 > 28 > C45 > > 222222-911 > 000222222 > 000038 > NAME OF CITY > 2 > 0 > 10/31/2007 > 28 > C46 > > 333333-911 > 000333333 > 000038 > NAME OF CITY > 2 > 0 > 10/31/2007 > 28 > C47 > ; > /*********************************************/ > > Each record consists of 9 lines like in the sample and each is > separated by a blank line. The leading zeroes need to be retained on > any variable starting with a zero. Can someone show me how to turn the > above into a dataset? Thanks in advance. > Jerry, Check out this TESTED program. It should get you pretty close to where you need to go! data test(drop=blankline); input #1 @7 mixedline $16. #2 allnums1 #3 allnums2 #4 @7 nameofcity $12. #5 allnums3 #6 allnums4 #7 @7 bigdate mmddyy10. #8 allnums5 #9 @7 mixedline2 $3. #10 blankline $ 1. ...

Re: how to output number of missing values of a text variable on #3
One more think I do not know about SQL. There are so many. On 10/22/08, Haris <Karovaldas@gmail.com> wrote: > Good one, Data _Null_, NMISS function seems to work equally well for > NUM and CHAR variables and eliminates the need for SUM! Runs faster > too! > > proc sql; > select catx(' ','nmiss(',name,') as', name) > into :syntax separated by ", " > from dictionary.columns > where Libname = "WORK" AND MemName = "MISSING" ; > > %put NOTE: GENERATED SYNTAX: %bquote(&syntax); > > title 'Missing' ; > select &Syntax > from Missing; > quit; > > On Oct 21, 5:30 pm, iebup...@GMAIL.COM ("./ ADD NAME=Data _null_,") > wrote: > > Using the MISSING function this can be simplified somewhat. > > > > proc sql; > > select catx(' ','sum(missing(',name,')) as', name) > > into :syntax separated by ", " > > from dictionary.columns > > where Libname = "WORK" AND MemName = "MISSING" ; > > %put NOTE: GENERATED SYNTAX: %bquote(&syntax); > > select &Syntax > > from Missing; > > quit; > > > > On 10/21/08, Haris <Karoval...@gmail.com> wrote: > > > > > How about something like this: > > > > > data missing ; > > > input a 1 b...

Re: Searching for partial text in character variables in SAS #2
There are also the PERL regular expression functions. But you will have to wait for the late sleeping "regEXperts" to wake up and load up on caffeine. ...

Web resources about - Re: How to search list of particular text values into free text #3 - comp.soft-sys.sas

Hillary Clinton wins Missouri, giving her a clean sweep of Tuesday's primaries
Bernie Sanders will not request a recount of Missouri's Democratic primary results, conceding the state to rival Hillary Clinton. Sanders told ...

TweetDeck for Windows support ends next month
Twitter has announced that TweetDeck for Windows will no longer be supported starting next month, and that Windows users will need to access ...

This Is The Weirdest Irish-Designed-And-Built Car You'll See All Day
As all of us planning to do some green-tinted vomiting later today can tell you, it’s St. Patrick’s day. That’s why I’d like to take a moment ...

Watch: SeaWorld Says Ending Killer Whale Breeding Is 'The Best Thing for Our Whales'
The president of SeaWorld San Diego spoke about the decision to phase out breeding programs and orca shows at the four SeaWorld facilities.

Casio Smart Outdoor Watch Goes On Sale March 25 For $500
Casio is a brand that you could associate with watches. After all the company is known for their calculator watches from back in the day, not ...

Citing Atrocities, John Kerry Calls ISIS Actions Genocide
New York Times Citing Atrocities, John Kerry Calls ISIS Actions Genocide New York Times Secretary of State John Kerry said the Islamic State, ...

Must See: Rep. Elijah Cummings Tears Gov. Snyder Several New Ones Over Flint Crisis
Governor Rick Snyder appeared before the U.S. House Committee on Oversight and Government Reform Thursday for a hearing on how his administration ...

Accused Kalamazoo shooter's lawsuit against Uber likely a hoax
A handwritten lawsuit blaming the ride-hailing service for ruining the suspect's life didn't come from him, according to the county sheriff. ...

N. Korea fires ballistic missile into sea: Seoul
North Korea fired a ballistic missile into the sea off its eastern coast Friday, just days after leader Kim Jong-Un ordered further nuclear warhead ...

Inside Project McQueen, Apple’s plan to build its own cloud
For the past several months, Apple has been working on “Project McQueen,” a plan to become more reliant on its own data center infrastructure ...

Resources last updated: 3/17/2016 11:20:17 PM