cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DanielSantos
‎04-27-2017
  • 474 Posts
  • 15 Likes Given
  • 21 Solutions
  • 89 Likes Received
About
SAS professional @ www.cgd.pt

Re: Recoding Variables using Arrays and Do Loops

by Barite | Level 11 in SAS Procedures
‎09-05-2012 11:46 AM
‎09-05-2012 11:46 AM
Hi. Array will produce a nicer code and Macro too. Here's one way to recreate code through Macro. options mprint; %macro decodevar(V,N); * V=var prefix, N=var num; %do I=1 %to &N;      if &V&I eq 1 then do; &V&I.N=2; &V&I.D=2; end; else if &V&I eq 2 then do; &V&I.N=0; &V&I.D=2; end; else if &V&I eq 3 then do; &V&I.N=0; &V&I.D=0; end; else if &V&I eq 4 then do; &V&I.N=1; &V&I.D=2; end; else if &V&I eq . then do; &V&I.N=0; &V&I.D=0; end; %end; %mend decodevar; data WANT; set HAVE; %decodevar(Q,4); run; Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: Nick Name matching function

by Barite | Level 11 in SAS Programming
‎09-05-2012 10:52 AM
‎09-05-2012 10:52 AM
Hi. If you're not happy with the sounds like operator/soundex, I don't see any function that will do this kind of "magical" match. Maybe perl regular expressions will get you nearer, but I'm sure it will go well farther than just one magical simple expression to do the match. Unless you are coding this with a full set of good rules or dictionary, can't see how to do this. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: Import Xml file into SAS dataset (v9.1.3)

by Barite | Level 11 in SAS Programming
‎09-05-2012 10:11 AM
‎09-05-2012 10:11 AM
It's actually pretty easy to do, no need for coding if you have the XMLMapper tool. Available here (at no cost, btw): http://support.sas.com/demosdownloads/setupcat.jsp?cat=Base+SAS+Software Cheers from Portugal. Daniel Santos @ www.cgd.pt Note: You can download and install de 9.2 version, It's a standalone tool and you'll be fine with that. That's the one we're using here to create the maps with the SAS 9.1.3. realease. ... View more

Re: Import Xml file into SAS dataset (v9.1.3)

by Barite | Level 11 in SAS Programming
‎09-05-2012 09:54 AM
3 Likes
‎09-05-2012 09:54 AM
3 Likes
Hello. Since the XSL procedure is at an experimental stage on 9.1.3, you have to be more precise about the error. If by any means you manage to setup your own xmlmap, it's pretty much like this: http://support.sas.com/documentation/cdl/en/engxml/62845/HTML/default/viewer.htm#a002484891.htm Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: grouping records

by Barite | Level 11 in SAS Procedures
‎09-05-2012 06:25 AM
‎09-05-2012 06:25 AM
Haikuo, forget the previous code, from michtka last example everything is much clear. Again, if tables are ordered by subjid,activity and subjid,awake,sleep and there's no overlapping intervals (has shown upside) by simply conditionally iterating through test1 (test2 would be the driver table) you can have the job done. No need for loop iterations. data want (drop=sleep awake _:)  ; * drop limits and temp vars;      set test2 ;        retain group;        * iterate through available limits;        do while (subjid > _subjid or (subjid = _subjid and (activity > sleep and sleep ne .)));                  group=_group; * set default group (previous);           set test1 (rename=(subjid=_subjid group=_group));        end;        if (awake <= activity <= max(sleep,activity)) then group=_group; * set correct group; run; Here's the result running michtka's last sample, handling correctly values that are outside ranges. Obs subjid     activity  group   1 1          15        1   2 1          25        1   3 1          35        2   4 1          49        2   5 1          58        5   6 2          71        1   7 2          86        2   8 2          90        3   9 2         104        3 10 2         115        2 Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: grouping records

by Barite | Level 11 in SAS Procedures
‎09-04-2012 01:01 PM
‎09-04-2012 01:01 PM
Array's aren't really needed, and merge probably won't work. Here's another solution using datastep, conditionally iterating through test1 (test2 would be the driver table). data want (drop=sleep awake _:); * drop limits and temp vars;      set test2 ;      if subjid ne _subjid or activity > sleep then         set test1 (rename=(subjid=_subjid group=_group)); * verify match;      if activity < awake then group=.; else group=_group; * set desired group; run; This assumes that tables were previously ordered by subjid,activity and subjid,awake,sleep has shown upside. If you're dealing with a large volumes, I believe this would be a good performance wise code. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: proc dbload

by Barite | Level 11 in SAS Procedures
‎09-04-2012 11:09 AM
‎09-04-2012 11:09 AM
Hello HelloSAS Read this please: https://communities.sas.com/thread/2158?start=0&tstart=0 Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: Count child by parent

by Barite | Level 11 in SAS Procedures
‎09-04-2012 11:03 AM
‎09-04-2012 11:03 AM
Using lag, and deriving from Mike's simplified code here: https://communities.sas.com/message/137090#137090 data WANT; set HAVE;     retain WANTED;     WANTED=sum(WANTED*(lag(CASE) = CASE),(lag(ID_child) ^= ID_child)); run; More on the LAG function here: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/a000212547.htm Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: html mail from sas

by Barite | Level 11 in Administration and Deployment
‎09-04-2012 07:14 AM
‎09-04-2012 07:14 AM
Hello. Try to save the mail as an html file, open this with notepad, and check the path of the link. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: How could I get rid of this warning!

by Barite | Level 11 in SAS Procedures
‎09-03-2012 01:03 PM
‎09-03-2012 01:03 PM
Just loose the a.* in the select proc sql;      create table any_name as      select     a.*        ,                 b.* from       table_1    a,            table_2    b where a.account_number=b.account_number; quit; Since you're selecting just the key from A, and the where clause restricts the query to a inner join (same value on both sides), it' doesn't matter from which table comes the Account_Number. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: grouping variable a

by Barite | Level 11 in SAS Procedures
‎09-03-2012 11:25 AM
‎09-03-2012 11:25 AM
Yep, same thing, different coding. That's a good alternative. :smileylove: SAS! Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: complex join with large tables

by Barite | Level 11 in SAS Programming
‎09-03-2012 11:22 AM
‎09-03-2012 11:22 AM
From a quick look to ORACLE's own documentation this should do the trick for exception handling: select * from B where not exists (select * from A where A.X=B.X and A.Y=B.Y AND A.M=B.M) This would return B except A by (X,Y,M). Then it's just a matter of joining A back to the result, say with the UNION or if you need the whole thing in SAS bring back those two pieces of data and append them together. With that volume of data and for most case, I guess it's better to let the DBMS handle it's own data and just transfer the results. If you choose the "Hash/Merge way" be cautious with multiple keys on both sides (N to N relations). Merge won't handle this on a traditional way, same for Hash bellow SAS v9.2. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: grouping variable a

by Barite | Level 11 in SAS Procedures
‎09-03-2012 10:41 AM
‎09-03-2012 10:41 AM
Or use LAG function: data want; set have; if lag1(A) ne A then B+1; run; More here: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/a000212547.htm Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: complex join with large tables

by Barite | Level 11 in SAS Programming
‎09-03-2012 09:52 AM
‎09-03-2012 09:52 AM
SAS is really needed? If both tables reside into ORACLE, have you considered running the query there? If you do need the result in SAS I would br advisable to perform SQL pass-trough (inside ORALCE) and just retrieve the result. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more

Re: how to program like this?

by Barite | Level 11 in SAS Procedures
‎08-31-2012 05:33 AM
‎08-31-2012 05:33 AM
And another way to do it, no arrays, just lag. data temp (keep=MEAN5_X); set have; retain MEAN5_X .; MEAN5_X=sum(MEAN5_X,X,-lag5(X)); if _N_ gt 5; run; data want; merge have temp; MEAN5_X=MEAN5_X/5; run; Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-27-2017 11:08 AM
Likes given to
Likes from
Quick links