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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: