I am learning to import/export xml file using sas and for my learning I have manually created the data set and xml map file by copying the data and code given in the sas online documentation available here (page 59) https://go.documentation.sas.com/api/collections/pgmsascdc/9.4_3.5/docsets/engxml/content/engxml.pdf?locale=en I used the same code to export nhl data set using a xml map. libname myfiles 'c:\myfiles\'; filename out 'c:\output\nhlout.xml'; libname out xmlv2 xmltype=xmlmap xmlmap='c:\example\nhlexport.map'; data out.TEAMS; set myfiles.teams; run; I was expecting the same output as shown in the documentation but my output lost indentation that looks like this and every xml file record is aligned to left without showing proper  <?xml version="1.0" encoding="utf-8" ?> <!-- SAS XML Libname Engine (SAS92XML) SAS XMLMap Generated Output Version V.03.03M0P10122017 Created 2017-10-13T15:54:55 --> <NHL description="Teams of the National Hockey League"> <CONFERENCE>Eastern <DIVISION>Southeast <TEAM name="Thrashers" abbrev="ATL" /> <TEAM name="Hurricanes" abbrev="CAR" /> <TEAM name="Panthers" abbrev="FLA" /> <TEAM name="Lightning" abbrev="TB" /> <TEAM name="Capitals" abbrev="WSH" /> </DIVISION> </CONFERENCE> <CONFERENCE>Western <DIVISION>Pacific <TEAM name="Stars" abbrev="DAL" /> <TEAM name="Kings" abbrev="LA" /> <TEAM name="Ducks" abbrev="ANA" /> <TEAM name="Coyotes" abbrev="PHX" /> <TEAM name="Sharks" abbrev="SJ" /> </DIVISION> </CONFERENCE> </NHL> Need advice from experts here to get my indentation issue fixed. ... View more

Hello experts, I am working on a project where I need to find 1. Spreadsheet names ( I have done that) 2. Names of the tabs in each spreadsheet 3.Count of number of tabs in each spread sheet from  a folder containing numerous spreadsheets(Xls files). I am struggling on second step, if you have any resources or advice, please share with me. Thanks, Raghu. ... View more

I have a number of macro programs that take different data sets for processing. For example, %macro Abc; /* Takes data set abc*/ .............. ............. %Mend Abc; This way I have created a number of macro programs. Now I need to execute macro program 'Abc' if data set Abc exists, %Macro  Action(Dsn); %IF  %SYSFUNC(EXIST(Dsn))>0  %THEN %DO;         %(&Dsn);  /*Here is the problem*/ %END; %ELSE %DO; %PUT***********Dataset &Dsn does not exist; %END; %MEND Action; Now if I use %Action(Abc);     The program fails to execute because  in %(&Dsn) , &Dsn fails to resolve so %Abc does not execute. Is there a way to fix this? Thanks every one for your attention. Raghu. ... View more

In EG, The automatic macro variable   "_CLIENTUSERNAME"    Extracts user name of the user/client but does not work in base SAS. Is there an equivalent  automatic macro variable in Base SAS that extracts the user name? Thanks for you attention. Raghu. ... View more