Hi, I had five columns named as cust_id, cust_tin, cus_tin_suf, guar_tin, guar_tin_surf and the data is like this. 1,11,11111,22,22222 2,11,11111,22,22222 3,11,11111,22,22222. Need to concatenate (cust-tin and cus_tin_surf) or (guar_tin and guar_tin with G as suffix) as tin. I need output as follows cust_id, tin 1, 11-11111 1G, 22-22222 2, 11-11111 2G, 22-22222 3, 11-11111 3G, 22-22222   Can anyone advice me on this. Regards, Sid ... View more

Hi, While connecting to the SAS EG 5.1, I am getting the following error: Exception type:  System.Runtime.InteropServices.COMException Message:         The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) Source:          mscorlib Target Site:     Unadvise Stack Trace:    at System.Runtime.InteropServices.ComTypes.IConnectionPoint.Unadvise(Int32 dwCookie)    at SAS.CILanguageEvents_EventProvider.remove_SubmitComplete(CILanguageEvents_SubmitCompleteEventHandler )    at SAS.LanguageServiceClass.remove_SubmitComplete(CILanguageEvents_SubmitCompleteEventHandler )    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection.SubmitWorkspaceInitializationCode(Boolean gridVersion, IJobLog initializationLogThatCouldBeNull)    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection.InitializeConnection(IJobLog initializationLogThatCouldBeNull)    at SAS.EG.JobManagement.Adapters.ExecutionWorkspaceConnection..ctor(String serverName, Boolean usePrimaryWorkspace, Boolean useGridIfAvailable, IJobLog initializationLogThatCouldBeNull)    at SAS.EG.JobManagement.JobManager.InitWorkspaceSession(String serverName, Boolean initializeGridIfAvailable)    at SAS.EG.MainForm.Broker_StateChanged(Object sender, EventArgs e)    at System.EventHandler.Invoke(Object sender, EventArgs e)    at SAS.EG.SDS.Model.Broker.FireStateChange(Base sdsObj)    at SAS.EG.SDS.Model.Server.SASWorkspace()    at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op) Could anyone suggest what could be reason behind this, as we restarted the RPC services  as well. The same thing is coming. Regards, Siddhartha ... View more

Hi, I have a two data set named dataset1 and dataset2 and want to create output like the one in attached excel workbook Test sheet name output Both the dataset are in same format as in excel sheet attached. Could anyone help me with SAS code or macro to create dataset as the one in output sheet All the variable except central are created using dataset1 and counting region for example proc sql; create table NEW AS SELECT region,COUNT(region)AS _61OMP from perf.input WHERE region="Kundelinjen (Ledelse & stab)" and fejltype="3829 RD BACO" and fejltekst="Sag sendt for sent ind" GROUP BY REGION, fejltype,fejltekst  ; QUit; output files has all the conditions in form of excel formula. and  Central variable is created using sum function and dataset2 regards. ... View more

Hi, I am facing some challenges in converting the following dataset into the table mentioned below using SAS. Please try to give some suggestions on this. Dataset: Var1 Var2 Var3 Var4 London New York Ireland Bangalore Bangalore Helsinki Helsinki Oslo Bangalore Bangalore London New York Oslo Helsinki Output Table. Bangalore Helsinki Ireland London New York Oslo Bangalore 0 2 1 2 2 1 Helsinki 2 0 2 Ireland 1 0 1 1 London 2 1 0 2 New York 2 1 2 0 Oslo 1 2 0 Regards, Siddhartha ... View more

Dear All, Can anyone please help me on the following code. I am facing difficulty while downloading the data from TSV file, the issue is the code that I have mentioned below is not reading all the characters per column and stops reading the data afterwards including the rest of the columns in the same row ( column / variable is having 350+ characters.) getting following errors. ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 　 ERROR: Import unsuccessful. See SAS Log for details. 　 filename in 'Path\meetings.tsv' encoding='utf8'; proc import datafile=in      out=tele.base_data      dbms=dlm      replace;      delimiter='09'x;      datarow=2; run; Regards, Siddhartha ... View more

While Importing TSV ( tab separated value) data as a SAS data set all the Danish letters are not appearing as the same. I was using the following code: proc import datafile='C:\Documents and Settings\Desktop\ExpMeet.tsv'      out=base_data      dbms=dlm      replace;      delimiter='09'x;      datarow=2; run; Sample Data: Siddhartha  Helsinki 001/TelePresence || Lersø Parkalle 001/TelePresence Bangalore 001/TelePresence ||Høje Taastrup 001/TelePresence Anyone can help me in reading the Danish and swedish letters while importing . Regards, ... View more

Hi, I tried to use the MVSW as well as analysis environment to execute the below query on DB2 (SAS code) for single day, as I need to fetch the data for the entire month. Unfortunately, I still get an error due to insufficient ASU time: ERROR: Error fetching from cursor. DB2 error is DSNT408I SQLCODE = -905, ERROR: UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED, RESOURCE NAME = ASUTIME LIMIT = 000000000009 CPU SECONDS (000000450000 SERVICE UNITS) DERIVED FROM SYSIBM.DSNRLST01. Could any one advise on this. SAS code: signoff host; %let host = mvsw  9450; signon host user = sid_14 pass = _prompt_; rsubmit host; libname outlib "sid_14.SAS.COLL.SERV.DATA" disp=old; proc sql inobs =max;   connect to db2;   create table outlib.opk_r_A as     select * from connection to db2 (select opts from  DKDDBPE_DB2P.EO.CS_OPK_FASTE_S      WHERE   DATE(OPTS) >= '2011-06-01'                                  AND     DATE(OPTS) <=  '2011-06-01'                                  AND     BEAKST IN ('U')       );   %put &sqlxrc &sqlxmsg;   disconnect from db2; quit; proc download in=outlib out=sid; select opk_r_A; run; endrsubmit; Thanking you, Siddhartha ... View more

I want to do the encryption for the importing /exporting different file formats. How can I do this in SAS. Can anyone help me on this. Regards, Siddhartha ... View more

I want to do the encryption for the importing /exporting different file formats. How can I do this in SAS. Can anyone help me on this. Regards, Siddhartha ... View more

I want to add two company logos, one at Upper Left corner and other at Upper Right corner above the title statement and I am using proc report. It's a html output. Can anyone help me on this. Regards, Siddhartha ... View more

I have four columns named prd_grp,prd-subgroup,prd_desc and loan_amount. The output columns in sequence are: Item Total Loan_amount The data is as follows: prd_grp prd_subgroup prd_desc loan_amount ASSETS All_Other Loans 234 ASSETS All_Other abc 345 ASSETS All_Other Quoted_Shares 213 LIABILIITES Deposits Current_Deposs 435 LIABILIITES Deposits Fixed 325 LIABILIITES Deposits NIDs & Repos 256 LIABILIITES Deposits Savings 218 I want the output with Item,total and loan_amount columns: Below is the output I needed Item Total Loan_amount ASSETS All_Other Loans 234 abc 345 Quoted_Shares Held 213 Total 692 LIABILIITES Deposits Current Deposits 435 Fixed 325 NIDs & Repos 256 Savings 218 Total 1234 Can anone help me on this,as this is critical. Thanks in advance. ... View more

I have four columns named prd_grp,prd-subgroup,prd_desc and loan_amount. The output columns in sequence are: Item Total Loan_amount The data is as follows: prd_grp prd_subgroup prd_desc loan_amount ASSETS All_Other Loans 234 ASSETS All_Other abc 345 ASSETS All_Other Quoted_Shares 213 LIABILIITES Deposits Current_Deposs 435 LIABILIITES Deposits Fixed 325 LIABILIITES Deposits NIDs & Repos 256 LIABILIITES Deposits Savings 218 I want the output with Item,total and loan_amount columns: Below is the output I needed Item Total Loan_amount ASSETS All_Other Loans 234 abc 345 Quoted_Shares Held 213 Total 692 LIABILIITES Deposits Current Deposits 435 Fixed 325 NIDs & Repos 256 Savings 218 Total 1234 Can anone help me on this,as this is critical. Thanks in advance. ... View more

I have four columns named prd_grp,prd-subgroup,prd_desc and loan_amount. The output columns in sequence are: Item Total Loan_amount The data is as follows: prd_grp prd_subgroup prd_desc loan_amount ASSETS All_Other Loans 234 ASSETS All_Other abc 345 ASSETS All_Other Quoted_Shares 213 LIABILIITES Deposits Current_Deposs 435 LIABILIITES Deposits Fixed 325 LIABILIITES Deposits NIDs & Repos 256 LIABILIITES Deposits Savings 218 I want the output with Item,total and loan_amount columns: Below is the output I needed Item Total Loan_amount ASSETS All_Other Loans 234 abc 345 Quoted_Shares Held 213 Total 692 LIABILIITES Deposits Current Deposits 435 Fixed 325 NIDs & Repos 256 Savings 218 Total 1234 Can anone help me on this,as this is critical. Thanks in advance. ... View more

data outst_amt; input prd_cat : $25. cus_cat & $20. Date_values & $20. Out_amount ; datalines; Hire-Purchase Business-banking 25thaug2010 234 Housing-Loans Consumer-banking 26-Aug-2010 243 Credit-card Business-banking 26-Aug-2010 342 Personal-Loan Consumer-banking 25-Aug-2010 456 Co-op-Personal-Loan Business-banking 27-Aug-2010 356 Share-Margin-Financing Consumer-banking 28-Aug-2010 123 Revolving-Credits Business-banking 25-Aug-2010 213 Syndicated-Loans Consumer-banking 24-Aug-2010 432 Trade-Financing Business-banking 29-Aug-2010 124 Term-Loans Consumer-banking 31-Aug-2010 145 Overdraft Business-banking 25-Aug-2010 234 Other-loans Consumer-banking 26-Aug-2010 187 ; run; I want the output as follows: Item Descriptions - -----Date values------- 25-Aug 26-Aug 27-aug 28-Aug A.Loans by Business Segment Business banking 314 345 Consumer banking 234 213 Total Gross Loans B.Gross Loans by Products Hire Purchase 367 276 Housing Loans 342 Credit card Personal Loan 243 Co-op Personal Loan Share Margin Financing 234 567 Revolving Credits 546 Syndicated Loans Trade Financing Term Loans Overdraft 345 657 546 Other loans Total Gross Loans Can anyone help me on this, as I was strucked from morning onwards. Thanks in advance ... View more