You're almost there. You have to convert it from date (days since 1Jan1960) to datetime (seconds from…). The dhms function does this: data test; date1 = '10/15/2017'; run; proc sql; create table test2 as select dhms(input(date1, MMDDYY10.), 0, 0, 0) AS date2 format = DATETIME20. from test ; QUIT; ... View more

It's hard to tell, because I can't see your exact code!   If it's exactly as the link has it, I'd modify it to this:     do while(not done); myfilename = filepath; input @; if reclen >= 2 then do; input name $ x1 x2 x3 @; output; end; input; end;   The input @; will read the record but not process it and not release it; nevertheless it populates reclen. If the length is 2 or more, read the fields you want and write out an observation. Again the trailing  @ will not release the record. At the end of the do block, the record is again processed as a null process, but releases it so that the next input will carry on correctly.   I should think that this will give you quite an improvement, especially if you've got a lot of variables to read. ... View more

It could make a difference depending on the file system and structure of the CSV files themselves, but you could try something like this: if reclen < 2 then delete; If you've used the length=reclen keyword of infile, and your files have variable length records, the blank lines will have a length of 0 or 1 (probably the former). ... View more

@mkeintz …with an 'end;' statement to terminate the 'if _n_ = 1 then do;', of course! ... View more

There are few problems I can see here. Does this code work better? %let libname=RF; %let filename=NG; %let year=2013; %let number=02; %let X1=wage; %let Y1=salary; data &libname..&filename&year%eval(&number+2); set &libname..&filename&year&number; if &Y1 in (1,2) and &X1 in (1,2,5,6); run; You missed out the %let commands for wage and salary. When you have a macro variable that must be suffixed with a full-stop, you need two of them: &libname.. To make sure that number has 2 added to it, you need to use  %eval. ... View more

Nah, it was quite a good question. And if you start experimenting with what SAS can do (and it's pretty good at playing around with strings), you'll be answering problems in no time! ... View more

Poking? Ow! ... View more