Hi , I am trying to generate XMl out put from SAS Data set which is having more than two are more rows .also i want to add user defined tags in XML file i am attaching desired xml out put file and sample data set below REPORT_CODE BAL_SHEET_FOOT CAPITALFUNDS MIN_CAP_PRESC_REG MIN_CAP_ADEQU_PRESC_REG CAP_ADEQU_RATIO NOTIONAL_CAP_FUNDS RISK_WEIGHTED_ASSETS NOTIONAL_CAP_ADEQU_RATIO CAP_RESERV_BAL_SHEET 639106 122345 122345 122345 122345 122345 122345 122345 122345 122345 639110 122345 122345 122345 122345 122345 122345 122345 122345 122345 639127 122345 122345 122345 122345 122345 122345 122345 122345 122345 639129 122345 122345 122345 122345 122345 122345 122345 122345 122345 639130 122345 122345 122345 122345 122345 122345 122345 122345 122345 Regards, Ramesh
... View more
Dear Team, i am accessing informap from sas idp getting results but i am not able to save as a data exploration but i am able to save as a report Thanks & regards, Ramesh Reddy Vemula 9930928809
... View more
Hi I am trying to generate .csv file from sas data set with " as text delimiter and , as delimite but for date it is taking as charater and inserting date as "15/03/2012" i need the date format as numeric and some numeric colulmns i want as character ie "63586900" i want output in this way "63586900",15/03/2012,"4568012145","Kumar" is this possible..........? Regards, Santhosh
... View more
Hello, I am executing macro based on condition ,in that macro i want to execute another macro program, its not working ,can any one help one this .? for your referennce i given example below. %macro A; %if Count=0 %then %do; proc print data=a; run; %else %if Count>0 %then %do; ods pdf file='TEST/TEST....pdf'; Proc report Data=TEST; run; %put 'TESTING'; %macro B; %if Count1=0 %then %do; proc print data=TEST2; run; %else %if Count1>0 %then %do; proc print data=TEST3; run; %end; %mend B; %B; proc report dat=Test2 ; run; ods pdf close; %end; %mend A; %A; Thanks, Ramesh %end; %mend A; %A;
... View more
Hi, I am generating .prn fromat form sas using this code DATA NULL; FILE "path /sample.prn" SET datasetname; put JOB_CODE $2. YEAR_MONTH $6. ' ' BRANCH_CODE $7. ITEM_CODE 3. NO_OF_ACCOUNT_OTHERS zeros. ; RUN; These are diffent formats applied while opening .prn in word pad i am able to get result but when iam opening it in notepad i am unable to get result in each line as second line of result is comming in first line of .txt kindly look into issue and help
... View more
Dear Team, i got below requirement any one can suggest ...? I have pdf document is there in oracle database with B-file datatype how can we fetch this document in to sas environment .is there any way?
... View more
hi, I am trying to execute below mentioned code , syserror is resolving always ZERO ,if any error occurs still its resolving 0 , any one can tell what"s wrong on this code %macro test; proc print data=sashelp.clss; run; proc sql noprint; select Count(*) into :CONT from sashelp.class; quit; options symbolgen ; %put &SYSERR; %if (&cont = 0 and &syserr=0) or (&cont = 0 and &syserr > 0) or (&cont > 0 and &syserr > 0) %then %do ; %let V_STATUS=0; %end; %else; %IF &cont > 0 and &syserr=0 %THEN %do ; %let V_STATUS=1; %end; %mend; %test; Regards, Ramesh
... View more
first thanks for ur replay...Duke I am using this code in SAS EG with SAS MAIN Server and ,no i am unable to see log because of printto procedure Yes i have mail acess.with out macro's i am able to send mails i'm not using any mail options Thank You, Ramesh
... View more
below code i am trying to execute but im not getting mails as mentioned in this code ...any one can tell whts wrong on this code,, %MACRO MAIL; filename myfile "D:/LOG/&sysdate _ &systime _log.txt" ; proc printto log=myfile; run; %if &SYSerr =0 %then %do; FILENAME outmail EMAIL SUBJECT="generated succesfully" FROM="....." to=".........."; FILE outmail; PUT "Dear Sir/Madam"; PUT " "; PUT "Report generated succesfully"; RUN; %end; %ELSE %IF &SYSerr > 1 %THEN %DO; /*this is mail body to send mails */ FILENAME outmail EMAIL SUBJECT="report generated" FROM="................" to="................." attach="D:/LOG/&sysdate _ &systime _log.txt"; FILE outmail; PUT "Dear Sir/Madam"; PUT " "; PUT "ERROR OCCURED"; RUN; %END; %MEND; %MAIL; Thanks in advance
... View more
Dear Team, I have A,B,C Jobs in Data integration Studio,if I run A job B,C jobs need to run Automatically,,how can i do this ,, any one can help on this.. Regards, Ramesh
... View more
Thank you very much Synthia ,but still headers are not comimg which i require in vertical format .that means it should come cahracters also require in 90 degree format.that i have already appended in Excel Sheet.
... View more
