yes, you can multiply by 1 which implicitly converts to numeric. year=substr(put(repdate,6.),1,4) *1; ... View more

bautista, PGstats answered your question already. since you've not mentioned it's char or numeric. you can also use put(),substr() to do it as follows.     data have; length repdatec $6; input repdate @1 repdatec; datalines; 200201    198102    198510 ; data want; set have; year=substr(put(repdate,6.),1,4); year1=substr(put(repdatec,6.),1,4); proc print; run; ... View more

Hi Benn, what you are asking is remerging summary statistics back to the original data. Hope the following code helps to get the desired results. proc sql; create table test as select a.*,max(age) max_age_by_gender from sashelp.class as a group by sex ;quit; proc print; run;  Obs    Name       Sex    Age    Height    Weight    max_age_by_gender                      1    Carol       F      14     62.8      102.5       15                      2    Alice       F      13     56.5       84.0       15                      3    Joyce       F      11     51.3       50.5       15                      4    Louise      F      12     56.3       77.0       15                      5    Barbara     F      13     65.3       98.0       15                      6    Janet       F      15     62.5      112.5       15                      7    Judy        F      14     64.3       90.0       15                      8    Jane        F      12     59.8       84.5       15                      9    Mary        F      15     66.5      112.0       15                     10    Robert      M      12     64.8      128.0       16                     11    James       M      12     57.3       83.0       16                     12    Henry       M      14     63.5      102.5       16                     13    Alfred      M      14     69.0      112.5       16                     14    John        M      12     59.0       99.5       16                     15    Jeffrey     M      13     62.5       84.0       16                     16    Thomas      M      11     57.5       85.0       16                     17    Philip      M      16     72.0      150.0       16                     18    William     M      15     66.5      112.0       16                     19    Ronald      M      15     67.0      133.0       16 ... View more

I used SAS 9.3. may be that's why i'm getting this message. ... View more

164  proc export data=class(drop=sex  age) outfile='c:\temp\x.txt' 165  replace dbms=dlm; 165!                   delimiter='|'; 166  run; WARNING: This DBMS type does not support Data Set options. The options entered will be ignored. I got the following warning when i tried. It's not dropping variables due to "This dbms type does not support data set options".  It's not a bug i guess.  They aware of this. But as Art mentioned,  May be the Tech support can give a work around for this if you raise a ticket. ... View more

libname psdptgt1 oracle user='userid' password='password' path='(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Host100)(PORT = 1521)) )(CONNECT_DATA = (SERVICE_NAME = DB_ALIAS)))'; Not sure if this what you wanted. But please check this out. I did connected from SAS EG to oracle to test the database connectivity. I used the above method to connect to a new database and tested queries. IF thisworks directly then you would be able to fix your batch file accordingly. This is just an example.  you should modify the host, port(if not default), service_name.  user,password. Once the above method works then you can verify and fix your parameters on batch file. Le me know how it goes!! ... View more

Really....I'm using SAS 9.1. I checked it by running proc setinit; run; I didn't see xml engine.  How can i use the xml libname engine in base sas. Thanks a ton for your quick responese. ... View more