Hi All,  I want to find out the diffrerence between two date values as per that day wise..   example;   data have; input id startdate enddate; informat startdate enddate datetime20.; format startdate enddate datetime20.; cards; 1 1May2019:11:10:00 2May2019:00:30:00 ; run;   If I conider the time format as 12 hrs then the difference is 1hr 30 mins,  1 hrs for 1st of may and 30 mins for 2 of may.  like wise I want to find out the difference between two datatime values..   thanks in advance ... View more

If I have a multiple files with difference extension and I want to read all the files into SAS at once... how I have to do?   for example in a specified location I have multiple file like  2 excel (.xls) 1 CSV(.csv) , 1 text (.txt)  &  1 Access (.mdb) files. I have to read all these file into sas with single step...     Thanks in advance ... View more

Hi All   I have 10 data sets and it is save in my library as    dt_city_01; (data sets name) dt_city_02; dt_city_03; .............  so on to  dt_city_10.   I want to assign city into 1 macro variable and 01,02,03(so on to 10) into other macro variable.....   can any 1 help me out..     thanks in advance. ... View more

I want to read an excel file into SAS environment (Server) which is saved on my windows desktop (using proc step or data step).   Can it be possible? how?       Thanks in advance...  ... View more