Hi! I used this script and I successfully generate an xml file. FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml";
LIBNAME source XML 'C:\Users\jgmanalo\Desktop\Sample1\From URL\outxml.xml';
PROC HTTP
OUT = outfile
URL = 'https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true'
METHOD = 'GET';
RUN; The XML file that I want is this But what I'm only getting is this Is there something wrong with the script? Thank you!
... View more
Hi, I followed the query filename nhl url 'http://www.a.com/Nhl.xml';
filename map 'C:\My Documents\XML\Nhl.map';
libname nhl xml xmlmap=map;
proc copy indd=nhl outdd=work;
select nhl;
run; But the resulted data set has no rows as shown in the image below. Do you have any idea about it?
... View more
Okay,here's the scenario. The XML file is from the Cisco Prime API. What I am doing in order to get the XML file is by right clicking and then "save page as...". Now, what I am askin' / want to know is if there's a way in SAS in order to automatically generate the XML file.
... View more
Hi @FreelanceReinhard, No, what I mean is I wanted to get the current date. But when I'm getting it the resulted format is in Julian Datetime. That is, what I want is to get the current date (which is in Julian DateTime) in DateTime Function. :))
... View more
Hello @FreelanceReinhard, That what I was looking for. I am also able to convert the other Julian dates. Thank you very much! If it is okay, I still have a question. I wanted to get the current date in which the format is similar to the Julian date format. How am I going to extract or get the current date? Thank you!
... View more
