SAS Support Communities

vomer · ‎08-16-2013

anyone^ ??

vomer · ‎08-01-2013

Hi there, I am wondering what the best way is to get this kind of analysis? Lets assume if my data looks like: ClientID | Transaction 001 | A1 001 | A1 001 | A2 001 | A3 002 | A4 002 | A5 003 | A6 003 | A6 Result would be: Client 001 has 3 unique transactions Client 002 has 2 unique transactions Client 003 has 1 unique transactions Thanks!

vomer · ‎06-24-2013

Hi there, I have a question around Haikou's code: data want; merge have have(firstobs=2 keep=event reason rename=(event=_e2 reason=_r2)) have(firstobs=3 keep=event reason rename=(event=_e3 reason=_r3)); RETAIN N; if event='S1' AND _E2='S5' AND _E3='S8' AND REASON='Reason 1' AND _R2 ='Reason 1' AND _R3 ='Reason 1' THEN N=3; IF N>0 THEN OUTPUT; N=N-1; drop n _:; RUN; I would like to know how I can add in an "ID" variable to consider in this code. For example - right now this code only considers the veriables "event" and "reason". What if I also have a customer ID variable that I would like to chunk this result by? For example: If I only want Ccustomer #1's data that follows that pattern? Obviously I would not know every customer's number in a large data set but rather would like the query about to "sort" by a customer ID variable.

vomer · ‎06-20-2013

Thanks everyone. There are some great suggestions here and I will take some time to explore them all. Haikou & PGStats - your updated solutions are new concepts for me - so many thanks for sharing these. I will have to read/experiment into these further. I will try to report back on my experience as I think it can help others like me in similar scenarios.

vomer · ‎06-20-2013

Try this: PROC IMPORT DATAFILE="c:\<path>\test.xls" OUT=seq(<for dataset options - see below> ) DBMS=excel REPLACE; GETNAMES=yes; * variable names are in row 1 ; RANGE="< range-name OR absolute-range"; * omit if you want to read the entire worksheet; Of course, you will need to save the file in xls instead of csv.

vomer · ‎06-20-2013

Hello Reeza, my dataset is quite large (close to a million rows of data). I am working with a smaller subset to see what solutions are possible in SAS as a testing ground. Thanks Reeza and Haikuo - I will attempt both these solutions and report back on my findings. Any other tips/solutions for large data are always welcome as I am still learning this scenario.

vomer · ‎06-20-2013

Try this: PROC IMPORT OUT=cla DATAFILE= "C:\shiva\not.csv" DBMS=CSV REPLACE; SHEET="sheet 1"; GETNAMES=YES; MIXED=YES; USEDATE=YES; SCANTIME=YES; RUN;

vomer · ‎06-20-2013

Hi all, I have a question on how the following can be achieved: Sample Data: Event Reason S1 Reason 1 S5 Reason 1 S8 Reason 1 S2 Reason 2 S1 Reason 4 S5 Reason 1 S8 Reason 5 S0 Reason 0 S3 Reason 7 S7 Reason 1 S1 Reason 1 S5 Reason 1 S8 Reason 1 Basically, I am trying to identify when a certain set of conditions are satisfied -> give me the count of this senario. So in the example above - I want to pull out the data where the sequence of "Event" goes from S1 to S5 to S8 and the Reason is Reason 1. Looking at the example above - I should get a total count of 2 and if I were to pull the data out into a new data set it would pull out the 2 sets where that sequence occurred and the reason was "Reason 1". Thanks for your help!

vomer · ‎05-24-2013

I looked up prx, but cannot get it to work. This sample I modified seems to be what I need, but it is not working: data _null_; if _N_ = 1 then do; retain patternID; /* The i option specifies a case insensitive search. */ pattern = "/Mount|TGH|Joe|Michael|Sunny|Toro|Bay|Brid|Provi/i"; patternID = prxparse(pattern); end; input service_provider $90.; call prxsubstr(patternID, service_provider, position); if position ^= 0 then do; match = substr(service_provider, position); put match:$QUOTE. "found in " service_provider:$QUOTE.; end;

vomer · ‎05-24-2013

I tried scan and index - both give me this error: function call has too many arguments I have a bunch of keywords I am searching for in my code. Like this: got_value=SCAN(var_1,"key1","key2" etc.);

vomer · ‎05-24-2013

Hi everyone, I am wondering how I can do the following: I have a data set with about 6000 rows of information - each field contains a string (something like this -> This is a sample text string) I was wondering what I can do to "search" all the rows of information for specific key words and then only keep those in my new smaller data set. Basically I want to say: if the words "this" "now" "then" appear in the column then keep that row or identify it somehow. Any sample codes would be greatly appreciated!

vomer · ‎05-08-2013

Thank you!

vomer · ‎05-07-2013

Hi there, I would like some help with the following macro: %let dt = %SYSFUNC(today(),MONYY.); This outputs the result: MAY13 How can this code be modified to show the previous month? i.e. APR13? Secondly, how can I make it look a bit different? Let's say like: April 2013 Thanks!

vomer · ‎03-20-2013

thanks! that works wonderfully well.

vomer · ‎03-20-2013

Hi all, Quick question: I have 2 datasets (ds1 and ds2) and they have some common variables (like ID, site name etc.) and some uncommon variables (flags and markers I have created in each) Is there any way using proc SQL to create a new dataset - that sources from ds1 and ds2 and computes sums from different variables? Example: DS1 DS2 Site Unit var Site Unit num A P1 0 A P1 1 B O1 1 B O1 1 B O1 1 B O1 1 C I1 0 C I1 0 C I1 0 C I1 1 Final DS Site Unit varsum numsum A P1 0 1 B O1 2 2 C I1 0 1

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

SAS Support Communities

Re: Identifying a sequence of events

Transactions per client

Re: Identifying a sequence of events

Re: Identifying a sequence of events

Re: proc import error

Re: Identifying a sequence of events

Re: proc import error

Identifying a sequence of events

Re: searching words in a variable

Re: searching words in a variable

Stopping SAS program if an error occurs

Stopping SAS program if an error occurs

searching words in a variable

Re: Copying Files from one directory to another

Question on SQL to SAS

Re: Identifying a sequence of events

Transactions per client

Re: Identifying a sequence of events

Re: Identifying a sequence of events

Re: proc import error

Re: Identifying a sequence of events

Re: proc import error

Identifying a sequence of events

Re: searching words in a variable

Re: searching words in a variable

searching words in a variable

Re: Question on Date Macro

Question on Date Macro

Re: Creating new data set from 2 seperate datasets (SQL)

Creating new data set from 2 seperate datasets (SQL)

Follow Us

What is...