hi,      I have data as below -     ID_no    ID_Val 1234       line1 1234       line1 1234       abcd 2345       line1 2345       line1 2345       abcd 3456       line1 3456       line2     I want to create a variable for flag, when an ID_No encounters value for ID_Val = abcd, but to output all ID_No and flag.   Output will be -   ID_No   ID_Flag 1234      abcd 2345      abcd 3456      none   (means when value = abcd isn't there for any of the ID_No, then ID_Flag will be 'none' (n/a)   ID_no should not repeat in the end data.   thanks in advance, basels ... View more

I have data something like this -   id1   abc id1   def id2   pqr id2   rst   ------   etc     I want to have like this in output dataset -   id1  abc/def id2   pqr/rst     thanks in advance, ... View more

Hi,   Recently Microsoft Office 2010 was intalled on my system and I have trouble in using proc import of data from excel to sas dataset. For few of the columns where names are there, only I can see first letter of each name in columns, not the whole name which is there in excel work book. Has any one encountered this kind of issue and please let me know how to resolve. thanks, sasbas9 ... View more

Hi,    I need help on how to summarize data by no of observations. For ex: I have data by customer segment and I want to see how many customers are there in each of segment (count), how can I do using proc summary. thanks, sasbase ... View more

I am getting an error message in the proc format with some symbols - "This range is repeated, or values overlap: " I was presttey sure that there are no repeats of variables with "by" statement, How to overcome this issue. thanks in advance, sasbase9 ... View more

I want to loop thru each of record to see if value in a particular date fields gets changed over time. There are multiple records for same entity in my table(kind of history table). Any idea how to do this using data setp/proc sql. thanks in advance, sasbase ... View more

hi,   I need to check multiple log files if they are created today and to check if no error exists in log files without manually opening log files. Can this be done using SAS statements ? thanks, basesas ... View more

HI, I was getting this note in the log : The data value for column  dat_time_field1 was truncated or was out of range 15 times when retrieving that       data from the DBMS. This looks to me that date time was not appropriately pulled into SAS dataset. Here back end d/b is Oracle. Please let me know if any conversion for field needed to pull exact value from d/b. thanks! ... View more

Hello, I need to compare a datetime field if it is b/w particular hours ? For Ex: if time in datetime field falls b/w 2 intervals of time (b/w 2 PM - 5 PM etc) Would any one please let me know. I was using put function and comparing against integers. thanks in advance. ... View more

hello, I need help with exporting a .txt file from a remote unix server to windows server. Would proc export does that? Please site an example/point to any existing code if available. thanks!! ... View more