About renjithr

renjithr · ‎05-19-2016

Thanks Ksharp, PGStats!

renjithr · ‎05-18-2016

Thank you!

renjithr · ‎05-18-2016

Hi Reeza, No, my list is hardcoded.

renjithr · ‎05-18-2016

Thanks PG Stats! Contians works but only with one value. It does not work in my test, where I checked for a list of values. eg: where store_name in ('COSTCO') works. but not ('COSTCO', 'APPLE', 'SAMS') - does not support I think.

renjithr · ‎05-18-2016

Thanks Reeza! yes, I am not searching for the exact values. for eg: I need to find APPLE COMPUTERS in the desired output file with a filter of 'APPLE'. I tested the where conditon but it did not work.

renjithr · ‎05-18-2016

Hi, I have a character string where that contains the names of various stores and I would like to filter the observations based on certain store values. I tried substring function but it does not work all the time. Below is an example of what I am looking for. Input file: Store_names ABC STORE APPLE COMPUTERS MICROSOFT CORPORATION COSTCO STORE WALMART SAMS CLUB Desired Output file Store_names ABC STORE COSTCO APPLE COMPUTERS Please let me know. Thank you!

renjithr · ‎03-28-2016

Thank you!

renjithr · ‎03-28-2016

Hi, I have a dataset where I have names in upper case and mixed case. I only want to retain observations with upper case names. ID Name 1 John Doe1 2 JOHN DOE 3 JOHN DOE1 4 John Doe2 Desired output: ID Name 2 JOHN DOE 3 JOHN DOE1 Please help.

renjithr · ‎03-28-2016

Thank you!

renjithr · ‎03-28-2016

Thank you Reeza. I plan to use the technique you mentioned in your paper for a dashbord where the columns and rows are static. Any reccomendatins ( links, books ) for creating dynamic dashboards using VBA?

renjithr · ‎03-28-2016

Hi, I am looking for options to update an excel dashboard( contins comparion of regions for each month, graphs etc) with SAS data. I heard people saying this can be done using VBA but I do not have any VBA experience. Is there any good resources that I can utilize? Please advise.

renjithr · ‎03-19-2016

Thanks a lot!! Aprreciate your help!

renjithr · ‎03-19-2016

Thank you! Apologies for not being clear. I ran your code but it did not run successfully. I got the below error: WARNING: Apparent symbolic reference COLON not resolved. ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. ERROR 79-322: Expecting a ). Could you please advise?

renjithr · ‎03-18-2016

Thank you. I am looking for the below output: 10001 101 201 10002 101 201 10002 101 301 10002 102 202 10003 101 201 10003 102 301 10004 101 201 Thanks.

renjithr · ‎03-17-2016

Hi, Thanks for the response. Apologies for not being clear. In the case of 10002, I only want to keep code2 when code2 values are different. 10002 101 201 10002 101 301 10002 102 202 In the case of 10003, I only want to keep one row for code1 and code2 combo, because there is duplicate values in code1 and code 2. So I only want to keep one combination of code1/code2 which could be either (101/201 and 102/301) or (101/301 and 102/201). 10003 101 201 10003 101 301 10003 102 201 10003 102 301

Online Status	Offline
Date Last Visited	‎12-22-2020 07:33 AM

Re: How to create sub-totals ?

Re: How to create sub-totals ?

Re: How to create sub-totals ?

Re: How to create sub-totals ?

How to create sub-totals ?

Re: PROC SQL : How to exclude records based on the values of a column ...

Re: PROC SQL : How to exclude records based on the values of a column ...

Re: PROC SQL : How to exclude records based on the values of a column ...

Re: PROC SQL : How to exclude records based on the values of a column ...

PROC SQL : How to exclude records based on the values of a column in a...

Re: Sample code to refresh an excel sheet using vba from SAS

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

Re: How to remove observations with mixed case names?

How to effectively manage version control on SAS EG(UNIX platform)?

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

Re: How to look for a list of values in a character variable?

How to look for a list of values in a character variable?

Re: How to remove observations with mixed case names?

How to remove observations with mixed case names?

Re: How to update a dashboard in excel with SAS data.

Re: How to update a dashboard in excel with SAS data.

How to update a dashboard in excel with SAS data.

Re: How to select non duplicate values?

Re: How to select non duplicate values?

Re: How to select non duplicate values?

Re: How to select non duplicate values?