About RamKumar

RamKumar · ‎08-14-2014

thanks, but in the interest of time could you please tell me the significance of !! in the line Phone_Text2=Repeat('0',10-Length(Phone))!!Phone;

RamKumar · ‎08-14-2014

If my input is character, then how to add leading zeros for the variable with character datatype?

RamKumar · ‎08-14-2014

Your code is perfect.Many thanks for your inputs. But i could not understand the purpose of 'mod' function ( i = mod(i+1,3);) from your program.

RamKumar · ‎08-13-2014

Please see attached and suggest me on the error.

RamKumar · ‎08-13-2014

I've not done any changes to the program. I'm getting error in the line 'do name="Raj","Ravi","Ram" stating that 'statement used out of order near second line (do statement). any problem with my session or SAS version? Please share me your output please.

RamKumar · ‎08-12-2014

Any possibilities to schedule a EG project in SAS management console?

RamKumar · ‎08-12-2014

I tried your code, but it is not working and error is 'statement used out of order. near second line (do statement). Please suggest me the other way around.

RamKumar · ‎08-12-2014

I don't have any of the details either. It was a question thrown to me during seminar. Any possibilities to guess the solution without the log?

RamKumar · ‎08-11-2014

I've a requirement to create a error control table via status handling in DI job. But I couldn't do it (getting error) since my staging and target table is Oracle. Please suggest to come past the error.

RamKumar · ‎08-07-2014

I need to create a schedule for three persons Raj, Ravi and Ram to download the daily trigger files. The schedule needs to cover a year, 2014. There are 3 columns, start date, end date and name. Start date is always a Monday and end date is always a Friday. The order that the names have to be in are Ram, Ravi then Raj. The first start date is 6/2/2014 and end date is 6/6/2014, but the first dates you need to print are for the following week. Output will look like this: Obs start_date end_date name 1 06/09/2014 06/13/2014 Ram 2 06/16/2014 06/20/2014 Ravi 2 06/23/2014 06/27/2014 Ravi I need this data from June to December 2014. It is OK if we receive the data from January.

RamKumar · ‎08-05-2014

I already seen the Zw. format but I'm not sure how it can be incorporated in SAS code as it is been often used with Input and Put function

RamKumar · ‎08-05-2014

Thanks for your response. Do you meant to say that SMC profile never be shared with SAS EG? Also may I ask you the steps to setup a internal SAS account? Please let me know how does it differs from general account. We don't have a SAS admin and hence i'm posting in this forum to understand more.

RamKumar · ‎08-05-2014

I've a SAS variable which is numeric with the same length for all records and I need to modify with one leading zeros and it still be numeric for all records like below. As Is: Mobilenumber 9167642524 9167642525 9167642526 To Be: Mobilenumber 09167642524 09167642525 09167642526 Please suggest me to achieve this task

RamKumar · ‎08-04-2014

I've SAS profile for production server which was set-up earlier (before I came to the project) in SAS EG 5.1. Now we've a requirement to work on SAS management console with the same production server account where i connect EG. When i produced the server details and it's relevant stuff to connect the server, I could not connect. Error message i got is 'username or password is invalid'. Can someone suggest me to succeed in this step? Because I could connect EG with the same credentials. On a related point, I see most of my production server operates with the port 8561, test server with 8562 and development server with 8563. Just I would like to know the process to set-up the port number for specific servers. Also i could see that some SAS accounts (mostly pre-prod) are ending with @saspw (eg. sasvt3@saspw). What does it mean? Can we have (set-up) the similar SAS account for production server?

RamKumar · ‎08-01-2014

Hi Ksharp, I don't have the copy of the original dataset. If I'm not wrong, audit trail table will hold only the details like number of rows processed and not the output which I expect.

Online Status	Offline
Date Last Visited	‎09-07-2018 06:08 AM

Case Study with SAS Campaign Management

Sum and Group by

Time Series Analysis in Banking sector

Data reporting for decline in sales

Re: Reading a list of files and conditionally export the files

Read the file names and create a dataset

Re: Parameterized Job

Re: Parameterized Job

Re: Parameterized Job

Re: Proc SQL Explicit pass through and Memsize

Re: Data reporting for decline in sales

Re: Do loops not sure if I am using the right step

Re: how to import excel with headings

Re: how to import excel with headings

Re: first. and last.

Re: Proc SQL Substring

Re: problem with proc import

Re: how to stack variables in different columns?

Re: How to give unique id to group of similar values in a column?

Re: Create Multiple Files Conditionally

Re: How to print a numeric SAS variable with leading zeros?

Re: How to print a numeric SAS variable with leading zeros?

Re: How to get the data based on weekdays?

String error in data variables

Re: How to get the data based on weekdays?

EG project scheduling

Re: How to get the data based on weekdays?

Re: Error Control Table for Oracle Staging table

Error Control Table for Oracle Staging table

How to get the data based on weekdays?

Re: How to print a numeric SAS variable with leading zeros?

Re: SAS connections profile via SMC

How to print a numeric SAS variable with leading zeros?

SAS connections profile via SMC

Re: Which transformation should use to get only the updated records in...