About silvergrenade

silvergrenade · ‎03-14-2018

Hi Kurt, Thank you for your reply. I figured out a way on achieving my problem. Is there a better way of achieving the same? OpportunityDescription is my variable while "F2F", "face to face" are my test strings. data out.open_records_opp_desc; set out.open_records; Count_1 = count(OpportunityDescription,'F2F','i'); Count_2 = count(OpportunityDescription,'face to face','i'); Count_3 = count(OpportunityDescription,'in person','i'); Count_4 = count(OpportunityDescription,'meeting','i'); Count_5 = count(OpportunityDescription,'met','i'); Count_6 = count(OpportunityDescription,'discussed','i'); Count_7 = count(OpportunityDescription,'one on one','i'); Count_8 = count(OpportunityDescription,'discussed','i'); Count_9 = count(OpportunityDescription,'contact','i'); count_f2f_occurance = sum(Count_1,Count_2,Count_3,Count_4,Count_5,Count_6,Count_7,Count_8,Count_9); run;

silvergrenade · ‎03-14-2018

Hi Paige, I'm sorry for that error. I didnt see the is in This. Yes, the count should be 3. Thank you.

silvergrenade · ‎03-14-2018

Hi All, How can I count the number of times a string occurs in a bigger string in SAS? Basically a variable with a lot of text and I need to determine how many times a certain thing occurs in each of the rows Example: A variable has a value "This is is a great day" for row 1 I need to know how many time 'is' occurred. Similarly for all rows I have been using prxmatch to know if it occurs or not. Cant figure out how to calculate number of occurrences. Thanks.

silvergrenade · ‎04-19-2017

Hi, Use the following snippet. data final.; merge first_data(in=a) second_data(in=b); by common_variable1 common_variable2 ; if a and b ; mi_ind=compress(a||b); run; Take a freq of mi_ind. It should only have 11 Cheers

silvergrenade · ‎04-19-2017

Hi Asheesh, Use the following snippet to find a data merge in data step. data test; merge X(in=a) Y (in=b) Z (in=c); by common_variable; mi_ind=compress(a||b||c); run; The mi_ind would help you in determining from where the particular row is coming from

silvergrenade · ‎03-28-2017

Thank you for replying.. Your help really helped. 🙂

silvergrenade · ‎03-27-2017

Hi All, I have a test population with an average spend of 4520 while the control population has an average spend of 3700$. My aim is to remove certain Control people so as to make the average spends similar. The control and test are about 20000 obs each. How do I do this in SAS? Your help would be greatly appreciated.

silvergrenade · ‎03-16-2017

Hi, My sample was selected based on a calling campaign. If they were pitched its a test population. The control is anybody not pitched the campaign. The problem with the control is that they might be pitched another campaign as it is quite different from the test population as compared in the average spend. So, the aim is to make the control similar to the test population. Ideally, we also have industry to which they were pitched the idea to. We also have individual spends of these ppl in that industry. So, coming to your question..How do I want to make them similar: Possibly the spend overall, as well as industry spend.

silvergrenade · ‎03-15-2017

Hi, I have a test population of 928 customers and I have their spends. I also have a control population with 86k customers. I want to make both these populations similar according to its spend. How do I go about this? Your help would be greatly apprecaited. Thanks..

silvergrenade · ‎01-17-2017

Hi, I actually looked it up online and found a function that finds GUIDs. data wastedGuids; do x=1 to 10; guid = uuidgen(); output; end; run; Thanks.

silvergrenade · ‎01-17-2017

I want to create a random 32 digit number containing both characters and numbers like 4b212e34-056f-413a-8dd8-d04e9b4c7756. How can I do this in SAS? Thanks in advance.

silvergrenade · ‎01-17-2017

Thankks for taking the time to help me out. Its working perfectly. Your suggestions too, helped. Thanks.

silvergrenade · ‎01-17-2017

Hi, Thanks for your swift replies. Really appreciated. I'm not getting any output though. proc import datafile="xxxxx.csv" out=out.tkt_rte_tx_cleaning dbms=csv replace; getnames=yes; run; The above file contains my V1 and V2 called Keyword and Replacement. TKT_RTE_TX_4 contains the V3. data _null_; set out.tkt_rte_tx_cleaning end=done; /* this is the one with the translation values */ if _n_ = 1 then call execute('data out.Multicity_HKG_Route_call_V1;set out2.GCG_HKG_OD_2;'); /* This starts the data step */ call execute('TKT_RTE_TX_4 = tranwrd(TKT_RTE_TX_4,"' !! trim(Replacement) !! '","' !! trim(Keyword) !! '");'); /* This executes the tranwrd function for every v1/v2 pair */ if done then call execute('run;'); /* ends the created data step */ run; I exported out.Multicity_HKG_Route_call_V1. Theres no change in my V3. What am I doing wrong? Thanks in advance.

silvergrenade · ‎01-17-2017

Hi, I have a data set which consists of say 10 obs. Every observation has 2 variables.(V1, V2) Also, in another data set i have a list of strings.(V3) V1 consists of a string present in V3. V2 is the value I want to replace it with. So, V3 is a long string and I want to put tranwrd(V3, V1, V2) on every value of V3 with all the ten obs of V1 and V2 How do I do this in SAS? Your help would be greatly appreaciated.

Online Status	Offline
Date Last Visited	‎03-21-2018 05:09 AM

Re: How many times a word occurs in a string?

Re: How many times a word occurs in a string?

How many times a word occurs in a string?

Re: find only common records from both he datasets

Re: please help in inner join

Re: Creating a Population Similar to Test Population

Creating a Population Similar to Test Population

Re: kNN to make Test and Control Similar

kNN to make Test and Control Similar

Re: Creating a random GUID for every Row in a dataset

Re: How many times a word occurs in a string?

Re: How many times a word occurs in a string?

Re: sorting technique in datastep

Re: write a code

Re: please help in inner join

Re: find only common records from both he datasets

Re: Creating a random GUID for every Row in a dataset

Re: How many times a word occurs in a string?

Re: How many times a word occurs in a string?

How many times a word occurs in a string?

Re: find only common records from both he datasets

Re: please help in inner join

Re: Creating a Population Similar to Test Population

Creating a Population Similar to Test Population

Re: kNN to make Test and Control Similar

kNN to make Test and Control Similar

Re: Creating a random GUID for every Row in a dataset

Creating a random GUID for every Row in a dataset

Re: Using a dataset values in a function

Re: Using a dataset values in a function

Using a dataset values in a function