topic Re: Import KoboToolBox Data Result in XLSX to SAS in SAS Programming

Import KoboToolBox Data Result in XLSX to SAS

febyinkasid — Mon, 16 Jun 2025 02:58:55 GMT

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

Re: Import KoboToolBox Data Result in XLSX to SAS

Kurt_Bremser — Mon, 16 Jun 2025 05:03:21 GMT

Where is the macro variable data defined?
On which platform does your SAS session run?

Re: Import KoboToolBox Data Result in XLSX to SAS

Ksharp — Mon, 16 Jun 2025 05:24:41 GMT

Try DEBUG statement to get more information:

filename target temp;
proc http method="get"
url="www.sas.com"
out=target
timeout=600;
debug level=3;
run;

Re: Import KoboToolBox Data Result in XLSX to SAS

febyinkasid — Mon, 16 Jun 2025 07:37:52 GMT

&data is defined in my macro dictionary.
using SAS 9.4

Re: Import KoboToolBox Data Result in XLSX to SAS

Kurt_Bremser — Mon, 16 Jun 2025 07:54:06 GMT

SAS 9.4 on UNIX or Windows? If server-based, is the path defined in &data available on the server?

Re: Import KoboToolBox Data Result in XLSX to SAS

febyinkasid — Mon, 16 Jun 2025 09:48:26 GMT

Hmm the &data. is local path, is not the problem since its already used globally and regularly. that is not the main problem.