to create numeric year and month: data want; set have; year=input(substr(repdate,1,4),4.); month=input(substr(repdate,5,2),2.); run; ... View more

Median is a a row-wise not an aggregate function in proc sql.  Take a look at: http://www.sascommunity.org/wiki/Fun_with_PROC_SQL_Summary_Functions If you need to use median values, calculate them with proc means or proc summary, and merge the results with your original data. ... View more

Thanks Tom. It was very detailed. I appreciate your time. ... View more

First of all, Are you sure you can connect with ORACLE by using oracle client software? In fact , SAS/ACCESS used oracle client to communicate with ORACLE. So if you can connect, then copy the contain of PROFILE file(in oracle client) into file '/sas/SASFoundation/bin/sasenv_local' ,and test it again. GoodLuck. Ksharp ... View more

Hi:   Since the XML Libname Engine is part of Base SAS, you won't see it in PROC SETINIT. (you don't see PROC PRINT, FREQ or MEANS in SETINIT either, but you can still use them).   OK...let's assume that you have an XML file stored in c:\temp\giftidea.xml (as shown in the attached screenshot). Then this code (in 9.2 or higher) would read the XML file into a SAS dataset: ** for 9.2; /* libname giftxml xml92 'c:\temp\giftidea.xml';  */      ** for 9.1.3; libname giftxml xml 'c:\temp\giftidea.xml';   proc contents data=giftxml._all_; run;     data mygifts;    set giftxml.giftidea; run;   proc print data=work.mygifts; run;    libname giftxml clear;   If your data are not in a simple structure, as defined in the doc for the Libname Engine, then you would have to use an XML Map file to map from more hierarchical XML to SAS dataset form. cynthia ... View more

Good question! I need to send a specification based on sas code to a person who doesn't work in sas.  I mean i need to provide more generic way to the person who programs this in different language. Also i need to more explicity mention "missing".  The other implicitly gives the values in my case. ... View more