Hi. Check this previous post: http://support.sas.com/forums/thread.jspa?threadID=5548&tstart=0 Greetings from Portugal. Daniel Santos at www.cgd.pt. ... View more

You could use the regular expression functions to extract the digits, but as stated before, COMPRESS function would be most direct and simple way Check the online documentation for the compress function (and its modifiers): http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000212246.htm Greetings from Portugal. Daniel Santos at www.cgd.pt. ... View more

Sorry, but I didn't get it... Being the above dataset the input data, could you please post the result dataset? Greetings from Portugal. Daniel Santos at www.cgd.pt. ... View more

Hello rab. Could you be more specific about what your trying to do, so we could point you the right direction?... Are you extracting, merging or transforming this data? Greetings from Portugal. Daniel Santos at www.cgd.pt. ... View more

Check for SAS Auto System Variables. see: http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a003167023.htm You might want to look into the &SYSPROCESSNAME Var see: http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a001221839.htm Greeting from Portugal. Daniel Santos at www.cgd.pt. ... View more

Hello. As previously said, adding the task to the system scheduler would be the simplest and safest way. But, if you wish to run your SAS program from a workstation and lets say, its a one time run only, I guess you could prepare a "special" datastep at the beginning of the program that will wait until the desired hour. Something like this: data _null_; do until(datetime() gt '19APR2009 10:00:00'dt); /* check date/time */ call sleep(10,60); /* wait 10x60 seconds = 10mins until next check */ end; run; /* your code, here */ Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

Hello Peter. Great reply. The wonderful magic of the DoW loop technique and its many variations. I attended Paul's presentation about the DoW loop at SGF2009, for me one of the best papers. I also loved the presentation about the "hardcore" performance POKE/PEEK functions (see: http://support.sas.com/resources/papers/proceedings09/010-2009.pdf ). Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

OK, my mistake. If you break the dataset by YEAR, the IDENTITY variable will maintain the ordering sequence (ordered), IF and ONLY IF the dataset is splitted sequentially, say processed through datastep (which processes each OBS sequentially). As Doc@Duke, said, you cannot assume the ordering sequence with PROC SQL, unless you explicitly say so. That is because SQL uses an optimizer that will choose the best strategy/technique to perform the task, and this may not involve a sequential processing of the dataset. I agree with Scott, before making any further assumption about your task and the way you are doing it, you should share with us a bit of your code. Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

You could easily do this with a single SQL statement (where SERIAL1 = SERIALA or SERIAL1 = SERIALB). For a datastep merge solution, you should do a 3 table merge, being the third table a copy of dataset B. Assuming that dataset A is sorted by SerialA, it would look like this; data BB; /* copy B to BB */ set B; run; proc sort; /* sort BB by SerialB */ by SerialB; run; data RESULT; /* do the 3 table merge */ merge A (in = a) B (in = b rename = (SerialA=Serial1) drop = SerialB) BB (in = bb rename = (SerialB=Serial1) drop = SerialA); by Serial1; if a and (b or bb); /* match by Serial1=SerialA or Serial1=SerialB */ run; Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

Hello Susan. Data sorted by YEAR IDENTITY GENDER AMOUNT is in different thant by IDENTITY. For example YEAR IDENTITY GENDER AMOUNT 2008 1 M 10 2008 2 F 11 2009 1 F 12 2009 2 F 13 is sorted by YEAR IDENTITY GENDER AMOUNT not sorted by IDENTITY. Try to look the IDENTITY column alone, you can easily see that it is not sorted. YEAR IDENTITY GENDER AMOUNT . 1 . . . 2 . . . 1 . . . 2 . . At row 3 the sequence is broke, as 1 (row 3) is lower than 2 (row 2). Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

You'll have to convert one of them. to convert from num to char, use the put function. see: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000199354.htm to convert from char to num, use the input function. see: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000180357.htm Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

Hello AnneP. Because: dim=input('19' || substr('9899',3,2),best4.)-1950; is a valid syntax. but: array x(input('19' || substr('9899',3,2),best4.)-1950); is not. Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more

Try this instead for yearcount calculation: %let years=9899; %let yearcount=19%substr(&years,3,2)-1950; /* build the calculation */ %let yearcount=%eval(&yearcount); /* do the calculation */ This will resolve yearcount to: 49 Your code resolve yearcount to: input('19' || substr('9899',3,2),best4.)-1950 Diference is, the way the calculation is performed, in your case at run time, in my sugestion at compile time. And: array x(input('19' || substr('9899',3,2),best4.)-1950); is not a valid syntax, but: array x(49) is. Greetings from Portugal. Daniel Santos at www.cgd.pt ... View more