About luu

luu · ‎04-27-2018

I tried to rewrite the code again, and the SYS_PROCHTTP_STATUS_CODE can solve my problem! Thank you very much!

luu · ‎04-16-2018

Great! I will see these documents and let you know the results! Thanks again for your great help!!!

luu · ‎04-16-2018

Thank you very much for your explanation! It is very helpful! I guess it is the # char make the error because the other records can run without any problem. But I cannot change the original data. My work is cleaning these messy records to get the matched information from the website. So is there any way to detect these error and write a if condition statement to avoid running these kinds of records? I try to use "syserr" to prevent this error but it is not worked. Do you have any suggestion about it? Thanks again!

luu · ‎04-16-2018

Thank you for you reply! Yes, you are right, there is an illegal JSON character in the file. But I don't know how to deal with it. I don't know how to see the file generated by proc http. And i post my code. Could you give me further suggestion of it! Thank you very much! filename med1 temp; proc http url="https://rxnav.nlm.nih.gov/REST/approximateTerm.json?term=acetaminophen w/codeine #3" method= "GET" out=med1; run; libname resp1 JSON fileref=med1; data Approximategroup_candidate; set resp1.Approximategroup_candidate; run;

luu · ‎04-09-2018

You are right, this program can run through. I notice there are some other places I used &test2 I have modified it. Thank you very much for your great help!

luu · ‎04-09-2018

Thank you for your great help! Part of my data is like this, there is a variable named "medicine_name" medicine_name levothyroxin 100mgcg antidepressant -can't remember name Simvastatin Tabs gabapentin 300mg I put them into a list of macro vairables: proc sql noprint; select medicine_name into : test1-:test99999 from xxx; quit; And then assign macro variable into a dataset variable: data result; med="&test2"; run; Because &test2 is "antidepressant -can't remember name", at this point, i get the error.

luu · ‎04-09-2018

Thank you very much! That works! But do you know how to only change test1="&test" writing instead of change the define of &test? Because i simplied the code for the question. In my original code the &test variable is the value of a column of a dataset not the variable using %let defined.

luu · ‎04-09-2018

Thank you for your reply. I write it as test1="&test" but still has error. It seems the single quote in macro variable test cannot be resolved well. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. ERROR 388-185: Expecting an arithmetic operator.

luu · ‎04-09-2018

Thank you for your reply. I write it as test1="&test" but still has error. It seems the single quote in macro variable test cannot be resolved well. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. ERROR 388-185: Expecting an arithmetic operator.

luu · ‎04-09-2018

There is a single quote in macro variable test. How could i assign macro variable test to test1 in data set test? Thanks! %let test=%str(antidepressant -can't remember name); data test; test1=&test; run;

luu · ‎04-09-2018

I'm using 9.4_m5. I can run through the other medicine but not worked for this one.

luu · ‎04-09-2018

I got an error when i run the proc http. I try to get the json file of medicine named "acetaminophen w/codeine #3 tablets". But there is an error when i run the "libname m JSON fileref=resp2;". The error is "ERROR: Invalid JSON in input near line 1 column 1: Encountered an illegal character. ERROR: Error in the LIBNAME statement.". However from the url, i can see there is a valid json file. I do not know why I cannot get it. filename resp2 temp; proc http url="https://rxnav.nlm.nih.gov/REST/approximateTerm.json?term=acetaminophen w/codeine #3 tablets" method= "GET" out=resp2; run; libname m JSON fileref=resp2; ERROR: Invalid JSON in input near line 1 column 1: Encountered an illegal character. ERROR: Error in the LIBNAME statement.

luu · ‎03-30-2018

Thank you for your reply! You are right, this is a value list instead of a variable list. I think your answer can solve my problem! I will check it. Thanks again!

luu · ‎03-30-2018

How can I using macro to check if a value is in a list. For example, I have a macro variable 'med_rx', %let med_rx=7804; And i have a variable list %put &var_list; 1007383 1012123 103755 1151123 1151126 1151127 1151130 ...823181 866331 8785 995869 How can i check if 'med_rx' is in 'var_list'? Is there any way to do it like " if &med_var in &var_list then ..." in the macro? Thanks!

Online Status	Offline
Date Last Visited	‎05-04-2018 11:48 AM

Re: PROC HTTP error

Re: PROC HTTP error

Re: PROC HTTP error

Re: PROC HTTP error

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

single quote in macro variable

Re: PROC HTTP error

Re: sas macro how to check a value in a list

Re: PROC HTTP error

Re: PROC HTTP error

Re: PROC HTTP error

Re: PROC HTTP error

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

Re: single quote in macro variable

single quote in macro variable

Re: PROC HTTP error

PROC HTTP error

Re: sas macro how to check a value in a list

sas macro how to check a value in a list