About akberali67

akberali67 · ‎11-11-2012

Hi, I didnt summarize this using code, that is what I was TRYING to find out. I wanted to pick all rows with 'Var2' being exactly the same and together in sequence and delete the rest. Is there anyway to achieve this? I mean occurrence of Var2 say equal to 2 more than once in continuous sequence. Thanks for trying to help. -Akber.

akberali67 · ‎11-11-2012

Hi, Is there a procedure or data step to group same values in variables together. This is my data and what I am trying to achieve: Data: Var1 Var2 A 1 B 2 C 2 D 1 E 3 F 6 G 6 H 6 I 6 J 5 K 4 Desired Result: Var1 Var2 B 2 C 2 F 6 G 6 H 6 I 6 I basically want all the same value in the variable along side each other to be extracted and delete the rest. I am not sure whether its possible technically because manually the dataset is way too large. Thanks in advance for the help. -Akber.

akberali67 · ‎10-30-2012

Hi, I need help coding a condition. I have four numeric fields and I want to say if any one is zero then do a certain action. Data looks like this: A B C D 1 0 0 2 3 1 2 0 4 2 8 4 0 6 1 9 I want to say if these fields contain one zero then do this, two zeros then do that action. I know we can do it by making all possibilities one after another like If A = 0 and b ne 0 and c ne 0 and d ne 0 but wanted to know whether there is any other way to avoid all that code. Thanks in advance for the help. -Akber.

akberali67 · ‎04-04-2012

Hi, The reason why I want to do this is because these are actually parts of line but some data system is outputting them into different lines. So I want to retain until you have LAST in the data. So, what it will do is create one line in the final dataset. But this works and is quite simple. Thanks again. -Akber.

akberali67 · ‎04-04-2012

Is there a way to readin a raw file by delimiter or is a line by line read-in the only option. Because I have split lines with quite weird scenarios. A B C 1 2 3 1 3 6 1 5 8 It should have been A B C 1 2 3 1 3 6 1 5 8 Please help!

akberali67 · ‎03-30-2012

didnt you get those required statiistics using my code for Proc summary??

akberali67 · ‎03-30-2012

Need help please!!!!

akberali67 · ‎03-30-2012

PROC SUMMARY DATA = HAVE NWAY MISSING; CLASS EVENTID ITEMID; OUTPUT OUT = HAVE1; RUN; _FREQ_ WILL BE YOUR COUNT AND YOU SHOULD ALSO HAVE OTHER STATISTICS DISPLAYED

akberali67 · ‎03-30-2012

data have; input date num 3.; informat date mmddyy8.; cards; 01/8/2012 9 02/2/2012 5 01/7/2012 9 03/2/2012 8 01/31/2012 10 01/30/2012 6 ; run; data have1; set have; if '1JAN2012'd < date < '1FEB2012'd; monthly_range = month(date); run; proc summary data = have1 nway missing; class monthly_range; var num_column; output out = have2 sum=; run; Remove nway missing if you want overall total too. Make sure that the num_colum is numeric. If not then add then use this: data have1; set have; if '1JAN2012'd < date < '1FEB2012'd; monthly_range = month(date); num_colum1 = input(num_column, best32.) run; proc summary data = have1 nway missing; class monthly_range; var num_column1; output out = have2 sum=; run;

akberali67 · ‎03-30-2012

Hi, Is there a way to create variable names using string from an observation. This is where I got with the code: DATA SASDATA.BAD1_REPAIRED; SET SASDATA.BAD1; COUNT + (-(LAG(FLAG) EQ 'LAST')*COUNT) + 1; DO FIELD&S. = TOTAL_TEXT (S = COUNT); END; RUN; I am trying to do this INPUT: total_text count abcdef 1 adfgh 2 LAST 3 OUTPUT: total_text count field1 field2 field3 abcdef 1 abcdef adfgh 2 adfgh LAST 3 LAST Please help. Thanks again for your help. -Akber.

akberali67 · ‎03-30-2012

This does work but it is very inefficient. It takes hours to run on even a small dataset. Probably because it assigns the values manually.

akberali67 · ‎03-30-2012

Hi, What can I do to reset the counter on a given condition. Example Data; Variable1 a b c N q r a w e N usually you would use _N_ to sequence but how do I get this output a 1 b 2 c 3 N 4 q 1 r 2 a 3 w 4 e 5 N 6 How do I get it to reset. Maybe I do not understand what _N_ denotes properly. Please help. Thanks in advance. -Akber.

akberali67 · ‎01-03-2012

Hi, I had one more question. How can we sum up variables. I want to add up about 50 variables to create a new one. I am using a macro statement that has all these variables seperated by a space. Any function which can help me use this statement. Data: Name Score1 Score2 Score3 A 10 8 10 B 7 6 5 C 4 10 8 How can I add Score1, Score2 and Score3 to form Total as the sum of these fields. Thanks, Akber.

akberali67 · ‎01-03-2012

Thanks Tom, that worked great! Just what I wanted to do, thanks again for the time. Thanks Arthur, the code did work but some variables of the 300 did not need conversion, so need to do some manual work there but a really good suggestion when I need to convert all the character fields. I learn a lot from your answers and truly appreciate the fact that you take time for us. Don't know how I would have managed without your help.

akberali67 · ‎01-03-2012

Hi, I am trying to convert character fields to numeric. Is there a better way than a regular Input statement to convert multiple variables to numeric from character. I am working with about 300 fields which need to be converted to the same BEST32. format from character. Same data formats too. Please help. This is what I was doing so far: DATA WORK.SAMPLE; SET WORK.DETAILS; FORMAT PRICE1 RENT1 EXPENSE1 BEST32.; PRICE1 = INPUT(PRICE, BEST32.); RENT1 = INPUT(RENT, BEST32.); EXPENSE1 = INPUT(EXPENSE, BEST32.); RUN; Thanks & Regards, Akber.

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

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: All Possible Combinations Loop

Re: How to create random samples from dataset?

Re: How to create random samples from dataset?

Re: Grouping same values together

Converting character to numeric

Converting character to numeric

Converting character to numeric

Re: Grouping same values together

Grouping same values together

Either field condition

variables names by string

Reading by delimiter

Getting the average amount of transaction for specifics event

variables names by string

Re: Getting the average amount of transaction for specifics event

Frequency by date range

variables names by string

Re: Resetting counter on condition

Resetting counter on condition

Converting character to numeric

Converting character to numeric

Converting character to numeric