The URL is a service returning the data which your browser is displaying.   To capture the data you have to use either proc http or proc soap.   I have added a code snippet for your reference.   filename resp "&WORKING_DIR./output.xml"; proc http url="&URL_ADVERSE." out=resp METHOD='GET'; run; Please let us know if it worked for you. ... View more

@art297   The link is broken.   I am looking at a Oracle DMW app Auto generated SAS code, it is trying to read contents of CPORT file using proc contents.    libname Source "/u04/dataloader/FILEWATCHER/FileWSASDev/AccentureFixitol"; option nofmterr; proc contents data=Source.RAVE_ODM_20180727T095357_part1 out=Contents noprint; run; /*RAVE_ODM_20180727T095357_part1.CPORT is the cport file in the path passed in libname.*/ How ever this is not working, I did not find any documentation to read the contain of cport file.   I could really use some help here.   Thank you in advance. ... View more

The macro variables are local to the macro function so they are not resolved outside the macro.   Fix: %let vector=1804+1803+1712; %let k=3; %put &vector.; %macro Macro0; %DO i=1 %TO &k.; %global mon&i.; /*Added*/ %let mon&i.=%scan(&vector.,&i.,+); %end; %mend; %Macro0; %put &Mon1.; %put &Mon2.; %put &Mon3.; Please let us know if it helped.  ... View more

Use SAS XML mapper to create a mapper file for your XML. It is clear from the log your XML file is not in standard XML format   filename xml_lib "/path/filename.xml"; filename MAP "/mapfile_path/YOUR_MAPER.map"; libname xml_lib xmlv2 xmlmap=MAP; /*Creates the XML library*/ option replace; proc copy in=xml_lib out=work memtype=data; /*Copies all XML tables to work*/ run; Now use SQL join or Data step Merge to create your final table from the downloaded tables in PROC COPY.   Or You can Create a Single mapper using replace functionality to create your data set without any additional join.   Same mapper can be then used to create your output XML file after manipulation.   Documents: http://www2.sas.com/proceedings/forum2008/099-2008.pdf http://documentation.sas.com/?docsetId=engxml&docsetTarget=p0194ofvsm9jw0n16bo5atjn33f3.htm&docsetVersion=9.4&locale=en   Let us know if it helped.  ... View more

We can create a XML mapper to get only one output table instead of 20 small tables and joining them to get data.   There is retain functionality that can be used to achieve the one table output result.   But I am not sure if it is really going to save any time.   XML in data analysis is very bad kind of data. ... View more

data have; infile datalines dlm=',' dsd; input InvoiceNo StockCode:$12. Description:$30. Quantity InvoiceDate:ANYDTDTE. UnitPrice:best12.2 CustomerID Country:$20.; format InvoiceDate date9.; datalines; 536365,85123A,WHITE HANGING HEART T-LIGHT HOLDER,6,01-12-10 8:26,2.55,17850,United Kingdom 536365,71053,WHITE METAL LANTERN,6,01-13-10 8:26,3.39,17850,United Kingdom 536365,84406B,CREAM CUPID HEARTS COAT HANGER,8,01-14-10 8:26,2.75,17850,United Kingdom 536365,84029G,KNITTED UNION FLAG HOT WATER BOTTLE,6,01-15-10 8:26,3.39,17850,United Kingdom 536365,84029E,RED WOOLLY HOTTIE WHITE HEART.,6,01-16-10 8:26,3.39,17850,United Kingdom 536365,22752,SET 7 BABUSHKA NESTING BOXES,2,01-17-10 8:26,7.65,17850,United Kingdom 536365,21730,GLASS STAR FROSTED T-LIGHT HOLDER,6,01-18-10 8:26,4.25,17850,United Kingdom 536366,22633,HAND WARMER UNION JACK,6,01-19-10 8:28,1.85,17850,United Kingdom 536366,22632,HAND WARMER RED POLKA DOT,6,01-20-10 8:28,1.85,17850,United Kingdom 536367,84879,ASSORTED COLOUR BIRD ORNAMENT,32,01-21-10 8:34,1.69,13047,United Kingdom 536367,22745,POPPY'S PLAYHOUSE BEDROOM ,6,01-22-10 8:34,2.1,13047,United Kingdom 536367,22748,POPPY'S PLAYHOUSE KITCHEN,6,01-23-10 8:34,2.1,13047,United Kingdom 536367,22749,FELTCRAFT PRINCESS CHARLOTTE DOLL,8,01-24-10 8:34,3.75,13047,United Kingdom 536367,22310,IVORY KNITTED MUG COSY ,6,01-25-10 8:34,1.65,13047,United Kingdom 536367,84969,BOX OF 6 ASSORTED COLOUR TEASPOONS,6,01-26-10 8:34,4.25,13047,United Kingdom 536367,22623,BOX OF VINTAGE JIGSAW BLOCKS ,3,01-27-10 8:34,4.95,13047,United Kingdom 536367,22622,BOX OF VINTAGE ALPHABET BLOCKS,2,01-28-10 8:34,9.95,13047,United Kingdom 536367,21754,HOME BUILDING BLOCK WORD,3,01-29-10 8:34,5.95,13047,United Kingdom 536367,21755,LOVE BUILDING BLOCK WORD,3,01-30-10 8:34,5.95,13047,United Kingdom 536367,21777,RECIPE BOX WITH METAL HEART,4,01-31-10 8:34,7.95,13047,United Kingdom ; run; proc sql; create table want as select *, (select max(InvoiceDate) from (select InvoiceDate from ( select InvoiceDate,sum(UnitPrice) as _price from have where InvoiceDate between h.InvoiceDate-1 and h.InvoiceDate-8 group by InvoiceDate ) group by InvoiceDate having max(_price) ) ) format date9. as Last_week_max_sale from have h; quit; This is a long file, please post small examples or sample input output, that way it becomes easy for us to solve an issue. Please let us know if it helped.  ... View more