Hello All, I have a requirement where I have a dataset which has the  days a technician visits a customer.We are only considering weekdays(Mon-Fri).If a technician did not visit the a particular customer on a weekday then I need to identify that and populate a  flag as "NO Visit".Is there any way to achive this based on the below example? eg:  Customer_name   TechVist_day            John                02JAN2012            John                03JAN2012            John                05JAN2012                    John                06JAN2012            John                09JAN2012             Mary               02JAN2012            Mary                03JAN2012            Sam                03JAN2012            Sam                04JAN2012                       From the above example I need to populate the flag as "NO Visit" for 04JAN2012 for the customer John and same with customer Sam for 02JAN2012. Please share your thoughts. ... View more

Hi, I have a requirement where I need to populate a field with year and month. eg: 201201 Any suggestions? ... View more

Hi, I am using EG to create three large files(10 gigs) which are sitting on a UNIX server.These three files are the input files for the sas job i run on PC SAS.Right now I am copying the file from unix to a network drive and PC SAS reads the file from the network drive.The problem is,copying of file from UNIX to network drive is taking 4 hours.Is there any way I can read files in UNIX from PC SAS with a library name statement? Please share your thoughts. ... View more

Hi, I inherited a code and it i dont understand the meaning of the following piece ageg=1+1*(sex='F'); ,is it similar to a conditional check? data tt; set t; ageg=1+1*(sex='F'); run; ... View more

Could you please let me know how to limit obs in a pass-thru sql.I am pulling the data from oracle database. Below is my code: proc sql   ; connect to oracle as ora (user = &user. password = &pw path = OraPath); create table zsz as select * from connection to ora ( select * from  ( select name from employee ); disconnect from ora; quit; ... View more

Could you please let me know how to limit the number of observations/rows in a pass-thru SQL? I have tried INOBS and OUTOBS ,but looks like it does not work in pass through ... View more

Hi, I have the following code: Data test; Dt=201210131; Run; Data test1; Set test; Dt1=put(dt,yymmdd10.); Run; When I run the second data step I am getting an error message: "Date out of range" Please share your thoughts on how to fix this error. Thanks. ... View more

Hi, Could you please help me with the following requirement: I have a dataset like the following: State  Visited -------   ---------- CA      Y NV       Y NV      Y NV      N NV       N GA      N I need to have an output dataset like the following: State      Yes   No -------       ----    ---- CA          1      0 NV          2      2 GA          0      1 Please share your thoughts Thanks ... View more