Has anyone tried to import Kobotoolbox questionnaire result in XLXS form to SAS? I have this macro to import, but somehow it keeps getting timeout /*XLS IMPORT*/ %macro httpkobolong(name, link); filename target "&data.\&name..xlsx"; proc http method="get" url="&link." out=target timeout=600; run; %mend(); %let link_module=https://kobo.sid-indonesia.org/api/v2/assets/[AssetID]/export-settings/[export-setting UID]/data.xlsx; %httpkobolong(name_module,&link_module.);   I assume this one from kobo, that is being timeout, but maybe anyone has any experience in this. Thanks in advance   ... View more

Hi all, I have this logic to retrieve all file inside a folder, I want to add last modified or created date of the file inside. Where can I add and what procedure to use? Thanks /*FIND PATH PARENT*/ %let pathbase=G:\Shared drives\; data filebase; length fref $8 fname $200; did = filename(fref,"&pathbase."); did = dopen(fref); do i = 1 to dnum(did); fname = dread(did,i); output; end; did = dclose(did); did = filename(fref); keep fname i; run;   ... View more