The information I Have was in my first post The dates are coming in as numeric as follows. 201802. 20180201 Because the macro files are so old I don’t want to reinvent the wheel. So depending on the dataset and task. I would be staring at two dataset with the two different date formats that I need to combine. When I try to use input () and put () to convert I get crazy numbers and if I try to reformat using yymmdd10. I get 02/01/2018 for the last example and garbage for the 201802. I need to be able to convert either format into the other since I get change the code to standardize. I hope this helps. My goal is a new dataset with one format ideally the 20180201 format ... View more

First of u believe the formats are Yymmddn8 Yymmddn6 But I can’t get them to behave when I try to convert them between formats ... View more

@s_lassen. This could work. But I would need it to only read certain files that contain “ratio” in the file name. How would I isolate that ? ... View more

Question on the combined library. If I wanted it to read only files that end with “ratio”. How would i code that I probably going to have to go down the set route since the files are all over the place. I need to combine all the datasets then standardize them. ... View more

The problem with this is.. i have to go through folders and years... so the file is dynamically reading the paths there are over 40 directories and 30 files per directory i need to combine using this macro ... View more

I @Astounding wrote: Don't create a blank.  Delete it entirely.  Sorry if that wasn't clear.   However .... if you don't expect to the new files to have the same structure, APPEND is not the best route.  Just change the name of the output data set from NEW to &SEG.  Then OUTSIDE of the macro, use a DATA step to combine the data sets:   data out.new; set op_l_tx op_l_rv op_s_rvlr; run;   However, if you are going that route, it opens up new possibilities.  You could simply use a single step with no macro language:   data out.new; length flag $ 9; set in.op_l_tx (in=in1) in.op_l_rv (in=in2) in.op_s_rvlr (in=in3); if in1 then flag='op_l_tx'; else if in2 then flag='op_l_rv'; else flag='op_s_rvlr'; run;     I have 200 datasets    so this wont work on that.   ill try without the null table    ... View more

Thanks..    i made the changes.    but now im getting the data will not append to the base file.  I created this blank and I was expecting SAS to automatically add the fields similar to the set statement when combining files.   I dont want to use "FORCE" and I do expect the files not to be completely identical since im going across years in this data pull   Sample error    WARNING: Variable DBB was not found on BASE file. The variable will not be added to the BASE file. ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files.   data out.new; set _null_; run;   data new; length flag $ 9; set in.&seg.; flag = "&seg"; run; proc append data=new base=out.new; run;   ... View more