Use another informat: data have; input x percent.; cards; 5 (5) 4 9 ; run; Xia Keshan ... View more

data test; *char datetime; a='8/30/2013 10:10:33 PM'; *convert to sas datetime using input; b=input(a, mdyampm22.); *split to date and time; date = datepart(b); time= timepart(b); *whatever format you wish to apply; format b datetime. date ddmmyy10. time time8.; run; ... View more

Once your conditions get complicated, I recommend doing them in a data _null_ step and put the result into a macro variable with call symput('cond_var','Y') or call symput('cond_var','N'), respectively. That way you can easily check if it works by simply doing a %put &cond_var after the data _null_ step. ... View more

You said the magic word - macro (as in macro variable). Be sure to e select "Double quotes around file name" in the File Location tabs. How to set the macro variable to a proper value depends on you application. If you wish to import multiple files in one go you might want to take a look at the loop transform (where you feed the file name from an outer job to the existing job). ... View more