> why doesn't most of the > documentation on stored processes don't talk about > creation of stored process using DI studio? Are you referring to the SAS Stored Process Developer's Guide documentation, or SAS Data Integration Studio Users Guide documentation? Vince DelGobbo SAS R&D ... View more

Cool post Daniel.... Honestly the way i learnt functions was by practice, execution & Ronald P. Cody book on SAS Functions by example..by constant usage i have been able to remember which functions give default 200 length or input variable length itself...wierd lengths have not yet happend with me :)...Thanks for the SAS-L post link..i never knew about the subgroups in function ( Library and Supervisor Functions 😞 which makes this length assignment happen the way they do) . Thanks a ton!!!!!!!!! for the info 🙂 ... View more

If I understand this right, this is SQL entirely runs in DB2, so I don't think it's fair having SAS tech support try to resolve performance issues within DB2... In SAS (SQL and data), by indexing the temp table usually makes this type of queries to run in a descent period of time. I like SQL a lot, but updating a master table using a transaction table is not what SQL is best at. I many situations I found that data step with modify by outperforms the SQL counterpart. /Linus ... View more

Peter, The INTNX() worked beautifully! Thank you for your suggestion . AJ ... View more

? or ?? The optional question mark (?) and double question mark (??) format modifiers suppress the printing of both the error messages and the input lines when invalid data values are read. The ? modifier suppresses the invalid data message. The ?? modifier also suppresses the invalid data message and, in addition, prevents the automatic variable _ERROR_ from being set to 1 when invalid data are read. Found it in the SAS doc http://support.sas.com/onlinedoc/913/getDoc/da/lrdict.hlp/a000146292.htm#a000146295 ... View more

Hi Pavan, Here is a paper from SAS Global Forum 2007 Tutorials :: http://www2.sas.com/proceedings/forum2007/213-2007.pdf , try going through it. Sushil ... View more

Hey Null/Cynthia, Just found this :: http://support.sas.com/kb/33/814.html ... a basic solution to my problem. but not with proc transpose...but a different approach..kinda like it Thanks to SAMPLES & SAS NOTES for the solution :: data visits; input dovisit date9. person_id sex :$1. nvisit :$1. fvisit :$1. avisit :$1.; datalines; 18dec2007 444 M T F F 18dec2007 444 M T F F 10jan2007 365 M T F F 10jan2007 365 M T F F 01feb2007 212 F T T T 01feb2007 212 F T F T ; run; /*create a data set of the duplicates using DUPOUT= option */ proc sort data=visits dupout=visits_dup nodupkey; by person_id; run; /* Create a macro variable with the variable names that are to */ /* be merged. The variables considered BY variables are excluded */ /* from going into the macro variable using the NOT IN operator. */ /* The resulting macro variable is in the format varname=varname_2 */ */ proc sql noprint; select trim(name) || '=' || trim(name) || '_2' into :varlist separated by ' ' from DICTIONARY.COLUMNS WHERE LIBNAME EQ "WORK" and MEMNAME EQ "VISITS" and upcase(name) not in ('PERSON_ID' 'DOVISIT' 'SEX'); quit; /*Merge the two data sets using the macro variable to rename the */ /*common variables in the second (duplicates) data set. */ data merged; merge visits visits_dup (rename=(&varlist)); by person_id; run; proc print; run; ... View more