Your last description sums it up. I don't know which column the named range will be referring to. I have now sorted out a work-around. A bit clunky, but I can rely on the range being just a single column, and so the imported datafile will only have one variable. Then I can use this code to pull out the name of the variable.   %macro FirstVName(data); %* returns the name of the first variable in the file; %let dsid = %sysfunc(open(&data,i)); %sysfunc(varname(&dsid,1)) %mend FirstVName; ... View more

Thanks. Very helpful. ... View more

I'll use that for now. Would be nice if there was a way of flagging which variables are constant within personID so I could just keep them - but for now I'll get by with just using the first value of each variable. ... View more

No. Don't have the code or original datasets. I'm prepared to assume that any variable that is constant within personid comes from the person file. (Even if not, the fact that it is constant within person is useful enough). ... View more

Thanks for the suggestions. I did miss the trailing slash requirement. However, I've fixed that and still have the same error. As I read the documentation, the libname statement does the downloading, I don't need to do it first. But it is a bit confusing.   However, when I run the program with macro debugging I see that it is calling the autocall library search path just before the error. If I run the program without my autoexec.sas which sets up my autocall library, it runs without error. (Haven't checked for sensible output yet). So I think there is something wrong with either my autoexec.sas, or there is a bug in the code where it doesn't handle an autocall library properly (not handling the comma in the augmented search path properly). The relevant code in my autoexec.sas is similar to that below.   options sasautos=("%sysget(userprofile)\Data\SASMACRO",sasautos); ... View more

The ETSMACRO appears to be a macro in the SAS/ETS autocall library which is being called by Proc SASEOECD. It has a few %index statements. I can't work out which one is not working. Looks like a call to support is needed. ... View more

Thanks Chris. I've managed to get it to work. Another question: Are these app passwords linked to a particular computer?  The dialog for creating them suggests they might be. I have a SAS program which sends an email using the filename email method. I've now put the app password in the program (using pwencode). Sometimes I run this program on computer A, and sometimes on computer B. Do I need to setup different app passwords for each computer? ... View more

This code runs. It returns a set of files which I would have to merge together to get the basic data table I'm after. Has this reassembly process been packaged into a procedure or macro for data in the SDMX format?   %let url = https://api.data.abs.gov.au/data/CPI/1.10001.10.1.Q/all?startPeriod=2019; filename temp1 "%sysget(TEMP)\temp1.txt"; filename map "%sysget(TEMP)\temp.map"; proc http url="&url" out=temp1;run; libname temp1 xmlv2 automap=replace xmlmap=map; proc copy in=temp1 out=work;run; ... View more

Returning to this problem. I have the (perhaps mistaken) guess that the solution to this should be simple. Below is my most recent attempt using the xml engine. I get an error message saying an xmlmap might be required. How do I create this? The data structure is very simple (the https file can be opened in a browser). %let url = https://api.data.abs.gov.au/data/CPI/1.10001.10.1.Q/all?startPeriod=2019; filename in url "&url" debug; libname in xml xmltype=generic; data temp; set in.series; run; ... View more