I all, I have a problem. I do so as from a table with 100 rows bait a table with rows that have that condition. By turning the macro made sas erases and writes the new data set and then instead of 4 lines provided only one that comes out the end of the dataset. %macro xxx (); %do i=1 %to 24; data _null_; var="hour"||put(&i,z2.); call symput('var',var); run; data control1; set control; %put &var; if &var eq "AAA" or &var eq "BBB" or &var eq "CCC" then delete; %end; run; %mend xxx; %xxx; thank's a lot bie bie m ... View more

Hi all, I have a problem to import an excel file with xls = dbms. I have a datetime field format var1 "03/11/2015 10:04:04" with two space between the date and time. When I import the file I truncates the field by putting only the date. How can I import the field as described above? thank's a lot bie bie PROC IMPORT OUT= WORK.OFFERTE_EB             DATAFILE= "my path"             DBMS=xls REPLACE ;   GETNAMES=yes; RUN; ... View more