i have a dataset sno name m1 m2 s1 s2 e1 e1 1 A 20 30 25 45 26 27 1 B 25 32 55 20 41 25 1 C 27 40 28 44 46 37 1 D 29 50 35 42 36 42 i want output as ______________________________________________________________ |                   |          maths         |     Science             |     English             | |SNo    name |  maths1| maths2  |science1 | science2  | english1|  english2| |                    |           (1)           |           (2)                |         (3)                | ------------------------------------------------------------------------------------------------------------- |1         A           20          30              25           45           26       27          | |1         B           25          32             55           20           41        25          | |1         C           27          40             28           44           46       37           | |1         D           29          50             35           42           36          42        | ------------------------------------------------------------------------------------------------------------- i want 1st level header as (1) (2) (3) 2nd level header as  maths1  maths2  |science1   science2  | english1   english2 3rd level headers as maths              Science                  English            ... View more

I am fetching huge data from oracle based on ASOFDATE conditionbut it is taking more then 50 minutes PROC SQL; connect to oracle(user=XXXXXXX password="XXXXXXXX" path='XXXXXXXXXXXX'); CREATE TABLE ABC AS SELECT * FROM CONNECTION TO ORACLE (SELECT * XYZ where ASOFDATE='15-AUG-2014'); DISCONNECT FROM ORACLE; QUIT; is there any way to minimise time taking ... View more

I am using proc export with | as delimiter proc export data= xyz outfile="path/sashelp.class.TXT"  dbms=dlm replace ; delimiter='|' ; run; Name|Sex|Age|Height|Weight Alfred|M|61|2400|112.5 Alice|F|61|50|84 Barbara|F|61|50|98 Carol|F|61|50|102.5 Henry|M|61|50|102.5 James|M|61|50|83 Jane|F|61|50|84.5 Janet|F|61|50|112.5 Jeffrey|M|61|50|84 John|M|61|50|99.5 Joyce|F|61|50|50.5 Judy|F|61|50|90 Louise|F|61|50|77 Mary|F|61|50|112 Philip|M|61|50|150 Robert|M|61|50|128 Ronald|M|61|50|133 Thomas|M|61|50|85 but when i am uploading into software then it is not taking next line after completion of 1st line Name|Sex|Age|Height|Weight Alfred|M|61|2400|112.5Alice|F|61|50|84Barbara|F|61|50|98Carol|F|61|50|102.5Henry|M|61|50|102.5 i am getting output like this is there any solution to get 5Alice|F|61|50|84 in next row ... View more

I use Microsoft Excel 97-2003 Worksheet (.XLS) opens with  (LibreOffice Calc) from my system i am using following code to generate output in excel /*Defining Styles of the report in pdf*/ proc template; define style Styles.newpdf;   parent = Styles.Printer;   STYLE SystemTitle /    FONT_FACE = "Zurich bt,Arial,Helvetica "    FONT_SIZE = 11;   STYLE data /    FONT_FACE = "zurich bt,Arial,Helvetica"    FONT_SIZE = 11pt;   STYLE usertext /    FONT_FACE = "zurich bt,Arial,Helvetica"    FONT_SIZE = 11pt;   STYLE Header /    FONT_FACE = "zurich bt,Arial,Helvetica"    FONT_SIZE =11pt;   STYLE systemFooter /    FONT_FACE = "Zurich bt,Arial,Helvetica "    FONT_SIZE = 11pt; end; run; /*Defining Styles of the report to EXCEL*/ proc template; define tagset tagsets.width;   parent=tagsets.htmlcss;   define event data;    put "<td";    trigger pre_post;    putq " class=" HTMLCLASS;    trigger align;    trigger style_inline;    trigger rowcol;    put ' style=' htmlstyle;    put ">";    put "<pre>" / if exist( asis );    put VALUE;    finish:     trigger pre_post;    put "</pre>" / if exist( asis );    put "</td>" NL;   end; end; run; ods markup tagset=tagsets.width path='path' file="sample.XLS" stylesheet='css.css'; ods pdf file="path/sample.pdf" startpage=no style=styles.newpdf; title1 h=5 'Class'; ods escapechar='^'; /*Generating report using proc report*/ proc report data=sashelp.class nowd split='~'; run; ods pdf close; ods markup close; previous it use to open in LibreOffice Calc now it has been updated  we are unable to open this excel files is there any other method to generate excel that opens in liber office Kindly find the attached error saved in word ... View more

I have a sample data set and output format data sample ; input emp $ 1-4 sal 5-12 date 13-20; datalines; 1111 5000 31OCT2013 1112 3200 31OCT2013 1113 4200 31OCT2013 1114 5100 31OCT2013 1115 7200 31OCT2013 1116 6000 31OCT2013 1111 5000 30NOV2013 1112 3200 30NOV2013 1113 4200 30NOV2013 1114 5100 30NOV2013 1115 7200 30NOV2013 1116 6000 30NOV2013 1111 2000 31DEC2013 1112 3200 31DEC2013 1113 5200 31DEC2013 1114 7100 31DEC2013 1115 6200 31DEC2013 1116 2000 31DEC2013 output sample format emp  sal-31OCT2013 sal-30NOV2013 sal-31DEC2013 1111     5000               5000                         2000 1112     3200               3200                         3200 1113     4200               4200                         5200 1114     5100               5100                         7100 1115     7200               7200                         6200 1116     6000               6000                          2000 date wise salary are in rows i need to put them in columns as month increase rows increase and i need to increase columns how can i dynamically increace columns and map salary to output ... View more

I am using the following code to generate an XBRL file Here i am creating macros and using in programs I have attached output generated I want to know is it correct format of XBRL or any other way to generate Filename outxml "path/xbrl_sample.xml"; data _null_; file outxml; /*XML Output File */ put '<?xml version="1.0" encoding="UTF-8" ?>' ; put '<xbrli:xbrl xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ref="http://www.xbrl.org/2004/ref" xmlns:xbrldt="http://xbrl.org/2005/xbrldt" xmlns:xbrldi="http://xbrl.org/2006/xbrldi" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:in-XXX-rep="http://www.xbrl.in/XXX/pbg/2009-02-06">'; put  '<link:schemaRef xlink:type="simple" xlink:href="in-XXX-rep-2009-02-06.xsd" />'; put '<xbrli:context id="'&asdate'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put  '</xbrli:entity>'; put '<xbrli:period>' ; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>'; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&OneMonth'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:OneMonth</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>' ; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&TwoMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:TwoMonths</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>'; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&ThreeMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>' ; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:ThreeMonths</xbrldi:explicitMember>'; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>'; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&FourMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:FourMonths</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>' ; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&FiveMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:FiveMonths</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>'; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&SixMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:SixMonths</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>'; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:context id="'&ExceedingSixMonths'">'; put '<xbrli:entity>'; put  '<xbrli:identifier scheme="'&datelink'">712</xbrli:identifier>'; put '<xbrli:segment>'; put  '<xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:ExceedingSixMonths</xbrldi:explicitMember>' ; put  '</xbrli:segment>'; put  '</xbrli:entity>'; put '<xbrli:period>'; put  '<xbrli:instant>' "&DATEY" '</xbrli:instant>' ; put  '</xbrli:period>'; put  '</xbrli:context>'; put '<xbrli:unit id="USD">'; put  '<xbrli:measure>iso4217:USD</xbrli:measure>' ; put  '</xbrli:unit>'; put '<xbrli:unit id="INR">'; put  '<xbrli:measure>iso4217:INR</xbrli:measure>' ; put  '</xbrli:unit>'; put  '<in-XXX-rep:Version contextRef="'&asdate'">V1.0</in-XXX-rep:Version>' ; put  '<in-XXX-rep:ForeignCurrencyBalances contextRef="'&asdate'" unitRef="USD" precision="INF">' "&FCY" '</in-XXX-rep:ForeignCurrencyBalances>' ; put  '<in-XXX-rep:NetOpenExchangePosition contextRef="'&asdate'" unitRef="INR" precision="INF">' "&NET" '</in-XXX-rep:NetOpenExchangePosition>' ; put  '<in-XXX-rep:NetOpenExchangePositionDomesticCurrency contextRef="'&asdate'" unitRef="INR" precision="INF">' "&FCYINR" '</in-XXX-rep:NetOpenExchangePositionDomesticCurrency>' ; put  '<in-XXX-rep:AggregateGapLimitMaintained contextRef="'&asdate'" unitRef="USD" precision="INF">' "&AGL" '</in-XXX-rep:AggregateGapLimitMaintained>' ; put  '<in-XXX-rep:ValueatRiskMaintained contextRef="'&asdate'" unitRef="INR" precision="INF">' "&VAR" '</in-XXX-rep:ValueatRiskMaintained>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&OneMonth'" unitRef="USD" precision="INF">' "&one" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&TwoMonths'" unitRef="USD" precision="INF">' "&two" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&ThreeMonths'" unitRef="USD" precision="INF">' "&three" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&FourMonths'" unitRef="USD" precision="INF">' "&four" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&FiveMonths'" unitRef="USD" precision="INF">' "&five" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&SixMonths'" unitRef="USD" precision="INF">' "&six" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>' ; put  '<in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="'&ExceedingSixMonths'" unitRef="USD" precision="INF">' "&seven" '</in-XXX-rep:ForeignCurrencyMaturityMismatch>'; put  '</xbrli:xbrl>'; end; run; Output generated <?xml version="1.0" encoding="UTF-8" ?> - <xbrli:xbrl xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ref="http://www.xbrl.org/2004/ref" xmlns:xbrldt="http://xbrl.org/2005/xbrldt" xmlns:xbrldi="http://x brl.org/2006/xbrldi" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:in-XXX-rep="http://www.xbrl.in/XXX/bpg/2009-02-06">   <link:schemaRef xlink:type="simple" xlink:href="in-XXX-rep-2009-02-06.xsd" /> - <xbrli:context id="asof_20130527"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.xxx.xxx.in/712/2013-05-27">712</xbrli:identifier>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_OneMonth"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.xxx.xxx.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:OneMonth</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_TwoMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.xxx.xxx.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:TwoMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_ThreeMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.XXX.gov.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:ThreeMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_FourMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.XXX.gov.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:FourMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_FiveMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.XXX.gov.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:FiveMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_SixMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.XXX.gov.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:SixMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:context id="asof_20130527_ExceedingSixMonths"> - <xbrli:entity>   <xbrli:identifier scheme="http://www.XXX.gov.in/712/2013-05-27">712</xbrli:identifier> - <xbrli:segment>   <xbrldi:explicitMember dimension="in-XXX-rep:CurrencyMismatchDurationDimension">in-XXX-rep:ExceedingSixMonths</xbrldi:explicitMember>   </xbrli:segment>   </xbrli:entity> - <xbrli:period>   <xbrli:instant>2013-05-27</xbrli:instant>   </xbrli:period>   </xbrli:context> - <xbrli:unit id="USD">   <xbrli:measure>iso4217:USD</xbrli:measure>   </xbrli:unit> - <xbrli:unit id="INR">   <xbrli:measure>iso4217:INR</xbrli:measure>   </xbrli:unit>   <in-XXX-rep:Version contextRef="asof_20130527">V1.0</in-XXX-rep:Version>   <in-XXX-rep:ForeignCurrencyBalances contextRef="asof_20130527" unitRef="USD" precision="INF">12456589.00</in-XXX-rep:ForeignCurrencyBalances>   <in-XXX-rep:NetOpenExchangePosition contextRef="asof_20130527" unitRef="INR" precision="INF">12345678.00</in-XXX-rep:NetOpenExchangePosition>   <in-XXX-rep:NetOpenExchangePositionDomesticCurrency contextRef="asof_20130527" unitRef="INR" precision="INF">98765432.00</in-XXX-rep:NetOpenExchangePositionDomesticCurrency>   <in-XXX-rep:AggregateGapLimitMaintained contextRef="asof_20130527" unitRef="USD" precision="INF">12365523.00</in-XXX-rep:AggregateGapLimitMaintained>   <in-XXX-rep:ValueatRiskMaintained contextRef="asof_20130527" unitRef="INR" precision="INF">917900.00</in-XXX-rep:ValueatRiskMaintained>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_OneMonth" unitRef="USD" precision="INF">-12345678.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_TwoMonths" unitRef="USD" precision="INF">12345678.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_ThreeMonths" unitRef="USD" precision="INF">13597862.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_FourMonths" unitRef="USD" precision="INF">54623189.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_FiveMonths" unitRef="USD" precision="INF">-47813596.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_SixMonths" unitRef="USD" precision="INF">471258936.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   <in-XXX-rep:ForeignCurrencyMaturityMismatch contextRef="asof_20130527_ExceedingSixMonths" unitRef="USD" precision="INF">-96325874.00</in-XXX-rep:ForeignCurrencyMaturityMismatch>   </xbrli:xbrl> ... View more

i have a text in column with $END$  which i need to break into multiple rows As part of the bank s DR strategy, it has a well laid out DR plan in place, which inter-alia covers details of alternative site in a different city/seismic zone and also provides for resource mappings for all the critical activities identified by the Bank.$END$ In order to fulfill the DR requirements, ICICI Bank has deployed various replication features as offered by the RDBMS and also the hardware based replication in order to fulfill the DR requirements.$END$The Recovery Time Objective (RTO) for all the critical applications identified by the Bank is between 2-8 hours.$END$ TheBank has undertaken periodic DR drills of these critical systems as per the regulatory guidelines to ensure that the alternate systems at the DR site are always available in case of system unavailability due to any catastrophic event. where ever i get $END$ it needs to insert into new row ... View more