Hi everyone!   I have 1000 tables 100gb each. I am processing them one by one with simple data steps.  I want to write an if statement that would check the first row, and if column X is not equal to 1 then stop this data step (meaning stop to work with this dataset) and go to the next table.    Thanks! ... View more

Hi everyone,   I guess I have 3 issues. I need to read files, that have filepath in following format:   x1/x2/x3/x4/file    So, I want to iterate over SOME x1, ALL x2, SOME x3, ALL x4. Finally when I am in x4 folder, I have 2 types of file's name in following format: file_name_date file_name_date.new    So, from those I want to read only file_name_date files, and I want to skip all file_name_date.new. file_name part of file is constant the only thing changes in file_name_date is the date part.   Then, this file is zipped. Can sas read zipped file?    Finally, when I read this file and did some manipulation with it, I want to save it and then start to work with new file. When I iterate over all files in folder, i will go back from x4 level to x3 level, change folder, go to new x4 level and repeat process.   Sorry, I guess it is confusing. You are more than welcome to ask extra questions, I will try to explain as hard as I can   Thanks,  Ed ... View more

I have following input format HHMMSSXXX, for example 93552085, I want to transform it into time format like 9:35:52,085. Thanks!  ... View more

This is the sample code    data a_k resid; set akkk; if mad_command ne 0 then do; output resid and ....; end; run;   So, what I am trying to do is that if mad_command ne 0, then ouput the whole row to resid table AND ALSO OUTPUT the previous row to resid table as well.    Thanks ... View more

Hi everyone,   I need to calculate lag value that is not constant from time to time.   For example for first entry I want lag6() for second entry I want lag9() for third entry lag999().    Is there any way to do it? I tried to use %let function, but macro can be only constant so it was not working.  ... View more