I'm trying to build a url from user generated input(to access different information using the same code), but I'm having an interesting error with the string I build. The error is the same whether I use cats(args) or compress(args). When I hard-code the url it works perfectly. I'm using SAS 9.3. Here's my code snippet: %let nptyr1 = "2012"; %let nptyr2 = "2013"; %let nptqtr1 = "1"; %let nptqtr2 = "1"; %let indstry = "10"; data Temp0; y1 = &nptyr1; q1 = &nptqtr1; y2 = &nptyr2; q2 = &nptqtr2; nn = &indstry; y3 = compress("http://www.bls.gov/cew/data/api/"||y1||"/"||q1||"/industry/"||nn||".csv"); call symput('z1', y5); y4 = compress("http://www.bls.gov/cew/data/api/"||y2||"/"||q2||"/industry/"||nn||".csv"); call symput('z2', y4); run; /************************************************************************/ /* Download data */ /************************************************************************/ /* Set filenames*/ filename website1 url &z1; filename copy1 'C:\temp\file1.csv'; filename website2 url &z2; filename copy2 'C:\temp\file2.csv'; and this is the error I get: ERROR: Error in the FILENAME statement. NOTE: Line generated by the macro variable "Z1". 1 http://www.bls.gov/cew/data/api/2012/1/industry/10.csv -- 23 ERROR 23-2: Invalid option name //. 1 ! http://www.bls.gov/cew/data/api/2012/1/industry/10.csv --- 23 ERROR 23-2: Invalid option name cew. 1 ! http://www.bls.gov/cew/data/api/2012/1/industry/10.csv ---- 23 ERROR 23-2: Invalid option name data. 1 ! http://www.bls.gov/cew/data/api/2012/1/industry/10.csv --- 23 ERROR 23-2: Invalid option name api. 1 ! http://www.bls.gov/cew/data/api/2012/1/industry/10.csv -------- 23 ERROR 23-2: Invalid option name industry. 1 ! http://www.bls.gov/cew/data/api/2012/1/industry/10.csv --- 23 ERROR 23-2: Invalid option name csv.
... View more