@Kurt_Bremser  Ok, sorry for the ignorant question, but asking will make me less ignorant.  How do I add URL's to my forum signature?  Perhaps I can just add or replace your signature to mine (it's good)  🙂  With full attribution of course 😉 ... View more

Fix your initial data step so I can paste it into SAS.  Using the Insert SAS Code icon.    You have a typo in your target output (Grey weight=80 not 90) if a patient had multiple admission dates (e.g. Maria), the information related to the earliest admission date is selected   Maria's earliest admission date is 03May2010, her weight is missing, not 75.   See if this helps:   data have ; input admissiondate date9. patientname :$20. gender :$1. weight type :$1.; format admissiondate date9.; cards ; 11Nov2011 Jim M 100 B 03Feb2010 Luna F 92 A 21Apr2011 Luna F 88 A 04May2016 Grey M 80 A 03May2010 Maria F . A 25Dec2012 Maria F 75 B 12Mar2013 Maria F 90 A run ; proc sql; create table want as select b.admissiondate, a.patientname, a.gender, a.weight, b.type from have a join ( select patientname, max(type) as type, min(admissiondate) as admissiondate format=date9. from have group by patientname ) b on a.patientname=b.patientname and a.admissiondate=b.admissiondate ; quit;       ... View more

Well I found this: https://communities.sas.com/t5/SAS-Support-Communities/How-to-ask-a-good-question-and-receive-a-fast-reply/ta-p/417192   It came up as the 1st tip as I typed in this post's subject.  Weird that the same subject entered in the search text entry box doesn't get this hit?   However, that post needs more detail, like using the Insert SAS Code icon for SAS code so it can be cut-and-pasted into SAS, using the have (source) and want (target) dataset paradigm, etc. ... View more

@kmardinian wrote: Hi,   I am trying to pull multiple files from an output folder where each are in this format; SUBJECTXXX_datetime.csv. So each folder has a different Subject ID and a different date stamp. There can multiple files in this one folder.   I'd like to pull all the files that are in this folder into SAS and merge them into one dataset, but I am unsure how to do this without calling each file individually. Once those files are in that one dataset, I'd like to move them to another folder, to then run my program again for the next batch of files   I appreciate any help, thank you!     Two questions:   1) Are all the files the same format?  IOW does the same import process import the CSV? 2) You say "merge them into one dataset".  Do you mean merge, or concatenate?  I'm going to assume the latter.   Sample code:   * create 10 CSV files ***having the same format*** ; %let pathname=%sysfunc(pathname(work)); %macro code; %do i=1 %to 10; %let i=%sysfunc(putn(&i,z2.)); proc export data=sashelp.class dbms=csv outfile="&pathname\class&i..csv"; run; %end; %mend; %code; * check created file ; data _null_; infile "&pathname\class01.csv"; input; put _infile_; run; * build a directory list ; %dirlist(dir=&pathname, filter=ext='csv') * check dirlist ; proc print data=dirlist; run; * read each file ; %macro code; %let fullname=%sysfunc(strip(&fullname)); data WORK.TEMP; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "&fullname" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2; informat Name $7. ; informat Sex $1. ; informat Age best32. ; informat Height best32. ; informat Weight best32. ; format Name $7. ; format Sex $1. ; format Age best12. ; format Height best12. ; format Weight best12. ; input Name $ Sex $ Age Height Weight ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; proc append data=work.temp base=work.want; run; %mend; * delete base table from previous runs ; %kill(data=work.want) * call code macro for every row in dirlist ; %loop_control(control=dirlist) * check final table ; proc print data=want; run;   Comments:   @Tom 's suggestion of using filevar would perform better.  Still, I cranked out the sample code in 10 mins. I ran a single proc import of the CSV, then cut-and-pasted the output from the log and edited it.  So, that takes care of your 50 variables issue. Even if I've misunderstood what you're wanting to do, perhaps you can modify some of this to suit your needs.   You also need to hit the doc for the infile statement.  Read up on the filevar option (and others).  Also review the examples: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000146932.htm   My macros are at https://github.com/scottbass/SAS/tree/master/Macro   Hope this helps...   ... View more