Hi
I need some help please. I have read most of the online posts on qualtrics data extraction using proc http in this community.
After trial and error using SAS 9.4, i managed to reach this stage where i can download a data file from qualtrics.
(Not that i cannot go the easy way to download a CSV file in qualtrics directly, but i hope to achieve it programmatically to automate the process intentionally
for another objective)
This is the data download script.
However when i use notepad to open the csv, i belief the format is incorrect.
The problem is , i do not know how exactly how to specify in SAS the format i wish to download .
Qualtrics supports manual download of these formats
When i asked the question to Qualtrics tech support, they suggested i check with SAS community instead.
I wish to seek some advice please. Thank you
Hi @Yiang ,
I think that the process of exporting responses in Qualtrics requires two steps:
SAS can process ZIP files if you decide that's easier to manage.
Hi @Yiang ,
I think that the process of exporting responses in Qualtrics requires two steps:
SAS can process ZIP files if you decide that's easier to manage.
Thanks for the hint @ChrisHemedinger
the file is in a zip format even though i downloaded it as a .CSV file.
after reading your message, i renamed the .csv to .zip and the data in CSV file can be found inside the zip file.
Hi @ChrisHemedinger,
I have a process that successfully requests and then imports data from Qualtrics API into SAS. However, I have issues with finding the sweet spot for the time it takes for the extract to be complete. Any sense of how long to wait? Currently, I've added a 20 minute pause to allow the data to queue for import; however, sometimes it still does not extract the most recent responses, thus the wait was insufficient. Love to figure out if there is a standard time I should use or how to explore (beside trial and error), what that ideal wait time...
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.