Hi,    I use a 2 step approach:   first read your study metadata where you can find all the forms that are defined in your study build   based on above list you can download each form data no matter what exact study you are using (it is metadata driven, so with a few parameters you can use this for multiple studies)   if you are using this in LSAF you most likely need to add a proxy and request to SAS professional services (jira ticket) to open that specific port in their network so that LSAF can connect to Medidata RWS (webservices)   example for metadata:: https://url.mdsol.com/RaveWebServices/datasets/Clinicalviewmetadata.csv?projectname=studyID  replace URL with your medidata URL and studyID with the study you need   form data extraction= proc http proxyhost="webproxy.vsp.sas.com" proxyport=3128         out=clindata         url="https://URL.mdsol.com/RaveWebServices/datasets/V_studyID_FormID.csv?environmentName=prod"         headerin=httphead        headerout=httpret        method="get"        ct="text/plain;charset=UTF-8"; run;   I use Medidata mAuth for authentication, so that's the reason I need the http input header output header I use to scan for return message (OK, nok,...)     ... View more

Hi, the PDF link is still not working ...   ... View more

Hi,    I decide on a maintenance point of view to seperate the code over multiple files.    also a point to consider is how you shedule your programs: if you are using 3 sheduled jobs (example: extraction in shedule job 1, transformation in shedule 2 and reporting / data upload in shedule job 3) makes it easier to re-run certain jobs when a problem has occur. (example: problem during transformation, your extraction process does not need to re-run, so your maintenance window can be smaller).     kind regards, Mark ... View more

Hi,    on linux I use following syntax:     ps -ef | grep 1234         ... where 1234 is the process ID that is locking your process kind regards, Mark ... View more

Hi, if you do not have any licenses for export to Excel you can create XML files that Excel can reads (with multiple sheets) Basic information you can find on http://support.sas.com/rnd/base/topics/odsmarkup/tableeditor/index.html Remark: for a lot of data these files will be huge ! ! a quick example could be: ( you need the file tableeditor.tpl' that you can find in the URL mentioned above ============================================================================= %include 'c:\temp\tableeditor.tpl'; ods tagsets.tableeditor file="c:\temp\export_naar_excel.html" style=styles.mystyle options(excel_zoom="90" excel_scale="90" excel_autofilter="yes" excel_frozen_headers="yes" excel_orientation="landscape" sheet_name="first,second,third" excel_table_move="1,2,3" auto_format="color1" excel_save_file="c:\\ temp.xls" ); proc print data=sashelp.class; run; proc report data=sashelp.class nowd; run; proc print data=sashelp.orsales; run; ods tagsets.tableeditor close; best regards, Mark Roosen ... View more