Hi All,       In a dataset, I have two columns st_dt and end_dt which are char type dates : data have; input dt1 $ 1-10 @12 dt2 $12.; format dt1 $12. dt2 $12.; datalines; 2012-02-22 2012-06-22 2012-02 2013-05-24 2013 2014-01-01 2013-01-01 ; run; I have to calculate something like this: if  dt1 >= dt2 then var1 = (dt1-dt2) + 1; else var1 = dt2 -dt1;   Please, advise me how to do this with sample code.   Thanks ... View more

Hi All,        I have a data set "EMP" with column name ID. When I try to rename it to EMPID, it's not renaming.    Code: data test;      set EMP (rename=(ID=EMPID)); run; No, errors, "test" data set is getting created with all observations but without renaming the column ID.  I am not able to understand why it is not renaming the column. I have tried like this also: data test;         set EMP;        rename ID=EMPID; run; Please,  help me to understand what could be the reason and how to resolve it.   When I try to check the following code, it is working: data test1;       set sashelp.class; run; date test1_rename;         set test1 (rename=(NAME=EMPID)); run; ... View more

Hi All,        I have to process different datasets and add a column to it. But, this new column gets added to the beginning of the datasets. I want to move this to the end of all columns in each dataset. I know that  length, attrib, retain, format, informat can be used to reorder the columns as required, but they require to mention the columns names, but the problem here is that I don't know what other columns are there in each dataset since each dataset has different columns and each of them have 25+ columns.   Please,  advise how to reorder in this case and provide some sample code, if possible. ... View more