cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
alepage
a week ago
  • 796 Posts
  • 177 Likes Given
  • 17 Solutions
  • 22 Likes Received

How to modify the sas code generated by the import data tools

by Barite | Level 11 in SAS Enterprise Guide
‎01-20-2023 12:24 PM
‎01-20-2023 12:24 PM
Hello,   I have used the sas import data tool in order to import a csv file without any error. I have tried with the proc import procedure but it did not give results as nice as with the import tool.   Does someone know the first steps involves in the import data tool, because we don't see it into the generated code.   The goal is to produce a code that will do the same job as the import tools in order to run that script on a regular basis.   ... View more

How to unzip a file in SAS EG to a specific location without the subfo...

by Barite | Level 11 in SAS Enterprise Guide
‎01-20-2023 11:21 AM
‎01-20-2023 11:21 AM
Hello,   I am using a unix command to unzip a file save on our unix server. Unfortunately, the file contains a folder and a subfolder which does not respect the folder name convention of sas and unix as well.   x %sysfunc(quote(unzip /finsys/...safety_purpose/report.zip -d /finsys/...safety_purpose/report))); What I would like to do, it's to replace this unix command by something that will give more information into the log file and to have the capability to unzip this file exactly where I want without the imbeded folder structure found into the zip file ... View more

Re: PROC HTTP Qualtrics.com

by Barite | Level 11 in SAS Enterprise Guide
‎01-19-2023 04:28 PM
‎01-19-2023 04:28 PM
I have carry out other tests and here's my last script.   /* First Step, looking at the survey list available */ %let Api_Token='****************************fD74l0sc1'; options set=SSLREQCERT="allow"; filename resp temp; PROC HTTP METHOD="GET" URL= 'https://ca1.qualtrics.com/API/v3/surveys' OUT=resp; headers 'x-api-token'= &Api_Token.; run; /* Let the JSON engine do its thing */ libname posts JSON fileref=resp; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=posts; quit; proc print data=posts.alldata; run; data Basic_survey_info (drop=ordinal_result ordinal_elements); set posts.result_elements; obs=ordinal_elements; run; /* Choosing the good survey by providing a partial name and putting the SurveyID into a macro variable*/ %macro GetSurveyID(Partial_Survey_Name); data Basic_survey_info; set Basic_survey_info; if find(name,"&Partial_Survey_Name.",'i') ge 1 then call symputx('SurveyID',id,'g'); run; %mend GetSurveyID; %GetSurveyID(Morgex); %put &=SurveyID; /* We have put SurveyID in the macro variable, &SurveyID.*/ /* Create Response Export / Start Response Export */ /* In that step, we need to provide the SurveyID (see previous step) in order to get the RequestID as well as the ProgressID */ /******************************************************************************************/ options set=SSLREQCERT="allow"; filename rsp temp; proc http url="https://ca1.qualtrics.com/API/v3/surveys/&SurveyID./export-responses/" method= "POST" in='{"format" : "csv"}' out=rsp; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run; /* Let the JSON engine do its thing */ libname RSP JSON fileref=rsp; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=RSP; quit; proc print data=RSP.alldata; run; proc print data=RSP.meta; run; proc print data=RSP.result; run; Data ReponseExport; set rsp.alldata; if p2 = 'progressId' then call symputx('ProgressID',strip(value),'g'); if p2 = 'requestId' then call symputx('RequestID',strip(Value),'g'); run; %put &=ProgressID &=RequestID; /* GET REPONSE EXPORT PROGRESS */ options set=SSLREQCERT="allow"; filename progr temp; proc http url="https://ca1.qualtrics.com/API/v3/surveys/&surveyId./export-responses/&ProgressID." method= "GET" out=progr; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run; /* Let the JSON engine do its thing */ libname progr JSON fileref=progr; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=progr; quit; proc print data=progr.alldata; run; proc print data=progr.meta; run; proc print data=progr.result; run; Data ReponseExport; set progr.alldata; if p2 = 'fileId' then call symputx('FileID',strip(value),'g'); run; %put &=FileID.; /*Get Response Export File*/ options set=SSLREQCERT="allow"; filename expfile '/.../test3.txt'; proc http url="https://ca1.qualtrics.com/API/v3/surveys/&surveyId./export-responses/&FileID./file" method= "GET" out=expfile; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run; This script works but when I look into test3.txt here's what I see below .  Any idea how to solve that issue.   PK ... View more

Re: PROC HTTP Qualtrics.com

by Barite | Level 11 in SAS Enterprise Guide
‎01-19-2023 03:09 PM
‎01-19-2023 03:09 PM
How this function works if I want to get the json reponse of qualtric.com   Could you please provide an example of SAS code? ... View more

Re: PROC HTTP Qualtrics.com

by Barite | Level 11 in SAS Enterprise Guide
‎01-19-2023 02:50 PM
‎01-19-2023 02:50 PM
Hello Chris,   I have started this project as follow:   /* First Step, looking at the survey list available */ %let Api_Token='**********************************wJOJfD74l0sc1'; options set=SSLREQCERT="allow"; filename resp temp; PROC HTTP METHOD="GET" URL= 'https://ca1.qualtrics.com/API/v3/surveys' OUT=resp; headers 'x-api-token'= &Api_Token.; run; /* Let the JSON engine do its thing */ libname posts JSON fileref=resp; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=posts; quit; proc print data=posts.alldata; run; data Basic_survey_info (drop=ordinal_result ordinal_elements); set posts.result_elements; obs=ordinal_elements; run; /* Choosing the good survey by providing a partial name and putting the SurveyID into a macro variable*/ %macro GetSurveyID(Partial_Survey_Name); data Basic_survey_info; set Basic_survey_info; if find(name,"&Partial_Survey_Name.",'i') ge 1 then call symputx('SurveyID',id,'g'); run; %mend GetSurveyID; %GetSurveyID(Morgex); %put &=SurveyID; and it works This script below is working:   options set=SSLREQCERT="allow"; filename rsp temp; proc http url="https://ca1.qualtrics.com/API/v3/responseexports/" method= "POST" in="{""format"" : ""csv"",""surveyId"" : ""&SurveyID""}" out=rsp; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run; /* Let the JSON engine do its thing */ libname RSP JSON fileref=rsp; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=RSP; quit; proc print data=RSP.alldata; run; proc print data=RSP.meta; run; proc print data=RSP.result; run; Data ReponseExport; set rsp.alldata; if p2 = 'id' then call symputx('ProgressID',value,'g'); if p2 = 'requestId' then call symputx('RequestID',Value,'g'); run; Is there a way to find what's could be the good url for the reponse export progress   ... View more

PROC HTTP Qualtrics.com

by Barite | Level 11 in SAS Enterprise Guide
‎01-19-2023 02:06 PM
‎01-19-2023 02:06 PM
Hello, I am trying to convert this  curl --request GET \ --url https://yul1.qualtrics.com/API/v3/surveys/surveyId/export-responses/exportProgressId \ --header 'Content-Type: application/json' \ --header 'X-API-TOKEN: '   into a SAS Code (see the code below) in order to obtain the fileid.  However, I am getting an 404 error which means I think that the URL is not good.  HouF!   /* GET REPONSE EXPORT PROGRESS */ options set=SSLREQCERT="allow"; filename progr temp; proc http url="https://ca1.qualtrics.com/API/v3/responseexports/" method= "GET" in="{""exportProgressId"" : ""&ProgressID"",""surveyId"" : ""&SurveyID""}" out=progr; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run;     ... View more

proc http Qualtrics.com

by Barite | Level 11 in SAS Enterprise Guide
‎01-19-2023 12:05 PM
‎01-19-2023 12:05 PM
Hello,   I have getting the surveyid from a previous script (not included). and I am able to execute the script below but, I am unable to replace the surveyID by it macro variable .   Does someone know how to do that ?   %let SurveyID=SV*************MwSAyrGK; options set=SSLREQCERT="allow"; filename rsp temp; proc http url="https://ca1.qualtrics.com/API/v3/responseexports/" method= "POST" in='{"format" : "csv","surveyId" : "SV******QMwSAyrGK"}' out=rsp; headers 'x-api-token'= &Api_Token. 'Content-Type'='application/json'; run; But I would like to replace the value of the surveyid by a macro variable for safety purpose and automation. ... View more

proc http and passing the surveyid in the url

by Barite | Level 11 in SAS Enterprise Guide
‎01-18-2023 05:03 PM
‎01-18-2023 05:03 PM
Hello,   I am a new user of proc http in SAS. I have tried the code below and it works   options set=SSLREQCERT="allow"; filename resp temp; PROC HTTP METHOD="GET" URL= 'https://ca1.qualtrics.com/API/v3/surveys' OUT=resp; headers 'x-api-token'= '***************ddssXDlLVfJUwJOJfD74l0sc1'; run; /* Let the JSON engine do its thing */ libname posts JSON fileref=resp; title "Automap of JSON data"; /* examine resulting tables/structure */ proc datasets lib=posts; quit; proc print data=posts.alldata; run; data Basic_survey_info (drop=ordinal_result ordinal_elements); set posts.result_elements; obs=ordinal_elements; run; From the table Basic_Survey_info, one of the survey id is equal to SV_ahhZznQMwSAyrGK   With this information I would like to execute the script below but in SAS. How to do that ?   curl --request POST \ --url https://yul1.qualtrics.com/API/v3/surveys/surveyId/export-responses \ --header 'Content-Type: application/json' \ --header 'X-API-TOKEN: ' \ --data '{ "format": "csv" }'   Whats the url will look like when you the surveyId by it's value ?   I have tried this piece of code  options set=SSLREQCERT="allow"; filename resp TEMP; %let SurveyId=SV_ahhZznQMwSAyrGK; proc http url="https://ca1.qualtrics.com/API/v3/surveys/&SurveyId./export-responses" out=resp; headers 'x-api-token'= '***********ssXDlLVfJUwJOJfD74l0sc1' 'Content-Type'='application/json'; run; but I am strill getting an error 404   NOTE: 404 Not Found NOTE: PROCEDURE HTTP used (Total process time): real time 0.30 seconds cpu time 0.00 seconds   More over, how do we convert the information  data '{ "format": "csv" in SAS     ... View more

Re: how to get the previous value

by Barite | Level 11 in SAS Enterprise Guide
‎12-16-2022 05:18 PM
‎12-16-2022 05:18 PM
It is the last value of the previous year. We put it into a macro . and use it when var2 is equal to habi_statisti_20200103. I know that the lag function should work but up to now, it isn't ... View more

Re: how to get the previous value

by Barite | Level 11 in SAS Enterprise Guide
‎12-16-2022 05:07 PM
‎12-16-2022 05:07 PM
Hello, I have tested you code and we are close, except the lag does not seem to work.  When var2= habi_statisti_20200204, var3 should be equal to habi_statisti_20200203, when var2=habi_statisti_20200203 var3 should be equal to habi_statisti_20200131 and so on. ... View more

how to get the previous value

by Barite | Level 11 in SAS Enterprise Guide
‎12-16-2022 03:40 PM
‎12-16-2022 03:40 PM
Hello,   I would like to know how to get the previous value of var2 which is equal to var3 at each 6 observations. So if you look at exec number 3821 , the value of var2 is habi_statisti_20200106,and I want to get the previous value of var2 which is habi_statisti_20200103.   How do we do that ?       data want; infile datalines delimiter=','; input var1 $4. var2 $25. var3 $25.; datalines; 3791,habi_statisti_20200103, 3791,habi_statisti_20200103, 3791,habi_statisti_20200103, 3791,habi_statisti_20200103, 3791,habi_statisti_20200103, 3791,habi_statisti_20200103,habi_statisti_20191231 3801,habi_statisti_20200103, 3801,habi_statisti_20200103, 3801,habi_statisti_20200103, 3801,habi_statisti_20200103, 3801,habi_statisti_20200103, 3801,habi_statisti_20200103,habi_statisti_20191231 3811,habi_statisti_20200103, 3811,habi_statisti_20200103, 3811,habi_statisti_20200103, 3811,habi_statisti_20200103, 3811,habi_statisti_20200103, 3811,habi_statisti_20200103,habi_statisti_20191231 3821,habi_statisti_20200106, 3821,habi_statisti_20200106, 3821,habi_statisti_20200106, 3821,habi_statisti_20200106, 3821,habi_statisti_20200106, 3821,habi_statisti_20200106,habi_statisti_20200103 3831,habi_statisti_20200106, 3831,habi_statisti_20200106, 3831,habi_statisti_20200106, 3831,habi_statisti_20200106, 3831,habi_statisti_20200106, 3831,habi_statisti_20200106,habi_statisti_20200103 3841,habi_statisti_20200106, 3841,habi_statisti_20200106, 3841,habi_statisti_20200106, 3841,habi_statisti_20200106, 3841,habi_statisti_20200106, 3841,habi_statisti_20200106,habi_statisti_20200103 3851,habi_statisti_20200107, 3851,habi_statisti_20200107, 3851,habi_statisti_20200107, 3851,habi_statisti_20200107, 3851,habi_statisti_20200107, 3851,habi_statisti_20200107,habi_statisti_20200106 3861,habi_statisti_20200108, 3861,habi_statisti_20200108, 3861,habi_statisti_20200108, 3861,habi_statisti_20200108, 3861,habi_statisti_20200108, 3861,habi_statisti_20200108,habi_statisti_20200107 3871,habi_statisti_20200109, 3871,habi_statisti_20200109, 3871,habi_statisti_20200109, 3871,habi_statisti_20200109, 3871,habi_statisti_20200109, 3871,habi_statisti_20200109,habi_statisti_20200108 3881,habi_statisti_20200110, 3881,habi_statisti_20200110, 3881,habi_statisti_20200110, 3881,habi_statisti_20200110, 3881,habi_statisti_20200110, 3881,habi_statisti_20200110,habi_statisti_20200109 3891,habi_statisti_20200113, 3891,habi_statisti_20200113, 3891,habi_statisti_20200113, 3891,habi_statisti_20200113, 3891,habi_statisti_20200113, 3891,habi_statisti_20200113,habi_statisti_20200110 3901,habi_statisti_20200113, 3901,habi_statisti_20200113, 3901,habi_statisti_20200113, 3901,habi_statisti_20200113, 3901,habi_statisti_20200113, 3901,habi_statisti_20200113,habi_statisti_20200110 3911,habi_statisti_20200113, 3911,habi_statisti_20200113, 3911,habi_statisti_20200113, 3911,habi_statisti_20200113, 3911,habi_statisti_20200113, 3911,habi_statisti_20200113,habi_statisti_20200110 3921,habi_statisti_20200114, 3921,habi_statisti_20200114, 3921,habi_statisti_20200114, 3921,habi_statisti_20200114, 3921,habi_statisti_20200114, 3921,habi_statisti_20200114,habi_statisti_20200113 3931,habi_statisti_20200115, 3931,habi_statisti_20200115, 3931,habi_statisti_20200115, 3931,habi_statisti_20200115, 3931,habi_statisti_20200115, 3931,habi_statisti_20200115,habi_statisti_20200114 3941,habi_statisti_20200116, 3941,habi_statisti_20200116, 3941,habi_statisti_20200116, 3941,habi_statisti_20200116, 3941,habi_statisti_20200116, 3941,habi_statisti_20200116,habi_statisti_20200115 3951,habi_statisti_20200117, 3951,habi_statisti_20200117, 3951,habi_statisti_20200117, 3951,habi_statisti_20200117, 3951,habi_statisti_20200117, 3951,habi_statisti_20200117,habi_statisti_20200116 3961,habi_statisti_20200120, 3961,habi_statisti_20200120, 3961,habi_statisti_20200120, 3961,habi_statisti_20200120, 3961,habi_statisti_20200120, 3961,habi_statisti_20200120,habi_statisti_20200117 3971,habi_statisti_20200120, 3971,habi_statisti_20200120, 3971,habi_statisti_20200120, 3971,habi_statisti_20200120, 3971,habi_statisti_20200120, 3971,habi_statisti_20200120,habi_statisti_20200117 3981,habi_statisti_20200120, 3981,habi_statisti_20200120, 3981,habi_statisti_20200120, 3981,habi_statisti_20200120, 3981,habi_statisti_20200120, 3981,habi_statisti_20200120,habi_statisti_20200117 3991,habi_statisti_20200121, 3991,habi_statisti_20200121, 3991,habi_statisti_20200121, 3991,habi_statisti_20200121, 3991,habi_statisti_20200121, 3991,habi_statisti_20200121,habi_statisti_20200120 4001,habi_statisti_20200122, 4001,habi_statisti_20200122, 4001,habi_statisti_20200122, 4001,habi_statisti_20200122, 4001,habi_statisti_20200122, 4001,habi_statisti_20200122,habi_statisti_20200121 4011,habi_statisti_20200123, 4011,habi_statisti_20200123, 4011,habi_statisti_20200123, 4011,habi_statisti_20200123, 4011,habi_statisti_20200123, 4011,habi_statisti_20200123,habi_statisti_20200122 4021,habi_statisti_20200124, 4021,habi_statisti_20200124, 4021,habi_statisti_20200124, 4021,habi_statisti_20200124, 4021,habi_statisti_20200124, 4021,habi_statisti_20200124,habi_statisti_20200123 4031,habi_statisti_20200127, 4031,habi_statisti_20200127, 4031,habi_statisti_20200127, 4031,habi_statisti_20200127, 4031,habi_statisti_20200127, 4031,habi_statisti_20200127,habi_statisti_20200124 4041,habi_statisti_20200127, 4041,habi_statisti_20200127, 4041,habi_statisti_20200127, 4041,habi_statisti_20200127, 4041,habi_statisti_20200127, 4041,habi_statisti_20200127,habi_statisti_20200124 4051,habi_statisti_20200127, 4051,habi_statisti_20200127, 4051,habi_statisti_20200127, 4051,habi_statisti_20200127, 4051,habi_statisti_20200127, 4051,habi_statisti_20200127,habi_statisti_20200124 4061,habi_statisti_20200128, 4061,habi_statisti_20200128, 4061,habi_statisti_20200128, 4061,habi_statisti_20200128, 4061,habi_statisti_20200128, 4061,habi_statisti_20200128,habi_statisti_20200127 4071,habi_statisti_20200129, 4071,habi_statisti_20200129, 4071,habi_statisti_20200129, 4071,habi_statisti_20200129, 4071,habi_statisti_20200129, 4071,habi_statisti_20200129,habi_statisti_20200128 4081,habi_statisti_20200130, 4081,habi_statisti_20200130, 4081,habi_statisti_20200130, 4081,habi_statisti_20200130, 4081,habi_statisti_20200130, 4081,habi_statisti_20200130,habi_statisti_20200129 4091,habi_statisti_20200131, 4091,habi_statisti_20200131, 4091,habi_statisti_20200131, 4091,habi_statisti_20200131, 4091,habi_statisti_20200131, 4091,habi_statisti_20200131,habi_statisti_20200130 4101,habi_statisti_20200203, 4101,habi_statisti_20200203, 4101,habi_statisti_20200203, 4101,habi_statisti_20200203, 4101,habi_statisti_20200203, 4101,habi_statisti_20200203,habi_statisti_20200131 4111,habi_statisti_20200203, 4111,habi_statisti_20200203, 4111,habi_statisti_20200203, 4111,habi_statisti_20200203, 4111,habi_statisti_20200203, 4111,habi_statisti_20200203,habi_statisti_20200131 4121,habi_statisti_20200203, 4121,habi_statisti_20200203, 4121,habi_statisti_20200203, 4121,habi_statisti_20200203, 4121,habi_statisti_20200203, 4121,habi_statisti_20200203,habi_statisti_20200131 4131,habi_statisti_20200204, 4131,habi_statisti_20200204, 4131,habi_statisti_20200204, 4131,habi_statisti_20200204, 4131,habi_statisti_20200204, 4131,habi_statisti_20200204,habi_statisti_20200203 ; run; ... View more

Re: how to do that

by Barite | Level 11 in SAS Enterprise Guide
‎12-15-2022 04:37 PM
‎12-15-2022 04:37 PM
It seems so simple for you and for me I had no idea how to do that. Sorting by descending order and using a retain statement. It does exactly what I wish. Thank you very much ... View more

Assign a value based on date / working day

by Barite | Level 11 in SAS Enterprise Guide
‎12-15-2022 03:47 PM
‎12-15-2022 03:47 PM
Hello,   Here's my dataset.   I would like to develop some go that will permit to map the date2 at the good value as it is into the dataset, based on date1 and workingday value.  When it is a working day, workingday eq one and if not it equals zero.     So I would like a sas code example to map date2 base on date1 and workday value. Does someone know how to do that ? Regards, data want; infile datalines delimiter=','; input date1: yymmdd10. workingday: 1. date2: yymmdd10.; format date1 yymmdd10. workingday 1. date2 yymmdd10.; datalines; 2020-01-01,0,20200103 2020-01-02,0,20200103 2020-01-03,1,20200103 2020-01-04,0,20200106 2020-01-05,0,20200106 2020-01-06,1,20200106 2020-01-07,1,20200107 2020-01-08,1,20200108 2020-01-09,1,20200109 2020-01-10,1,20200110 2020-01-11,0,20200113 2020-01-12,0,20200113 2020-01-13,1,20200113 ; run; Please note that I would like to have date2 using yymmddn8. format but I have tried it the code and it does not like it. ... View more

Re: How to add row number in an empty dataset

by Barite | Level 11 in SAS Enterprise Guide
‎12-15-2022 10:52 AM
‎12-15-2022 10:52 AM
it is a good question.   imagine that I have generated a dataset A with var1-var4 values including n, also with values in it. The I take the dataset B which contains var1 until var10 including n. In that dataset B, i want to drop (var1 to var4) and keep n as below;   data b(drop= var1 var2 var3 var4); set b; stop; run;   Then create new table as below   proc sql; create table pilote_&startyear2._&endyear2._jointure_v001 as select a.* ,b.* from work.jointure as a left join pilote_&startyear._&endyear._jointure_tmpl as b on(a.n1=b.n); Quit;   where dataset a is like jointure and dataset b is like  pilote_&startyear._&endyear._jointure_tmpl   ... View more

Re: How to add row number in an empty dataset

by Barite | Level 11 in SAS Enterprise Guide
‎12-15-2022 10:34 AM
‎12-15-2022 10:34 AM
In the dataset want, var1 until var10 and n already exist but there is no value in those. I have tried: data want; set want do n=1 to 100; output; end; and it does not work ? Does the fact to add the length statement solve that issue ? ... View more
Contact Me
Online Status
Offline
Date Last Visited
a week ago
Likes given to
Likes from
Quick links