Search results for query: *

Hey Chris, I don't have any variable with same values within each counter group. That is why I am creating one such with this code. The logic of my Code is the following: In the 2nd step, first, I am creating a temporary array which "reads" all the dates within each counter group. Then I...

Hey Chris, thank you very much for your reply. You are - as always - right, since your "basic" code would do the job in the data sample that i have provided above. However, I haven' t mentioned that in my actual set, I have stock trading trades rather calendar dates. Therefore, they don't...

Hey all, I think that i have worked it out, but I would like to ask your view on how safe my solution is ? I proceed in 3 steps : 1) I split my data into two parts: One data set containing just the name and date variables and another containing the name and all the other variables (counter...

Hey all, I am a non-expert, learning SAS for the past 10 months. I am having one data set with 3 constant counter {-1, +1) windows of dates for one name (ABC): data vertical ; input @1 name $3. +1 counter 2. +1 date mmddyy10. +1 price 3.1 ; format date mmddyy10. ; datalines ; ABC -1...

Thank you both guys, This puts a lot of studing & testing for me. I will use both suggestions and will let you know. I am sincerely indebted, Vassilis

Hey mdieckman, First of all, i would like to thank you for your immediate response. You are right, my query is not well explained by me: My objective is delete the obs that exhibit a missing Value on the VO variable from the tail of each Name-Group ONLY, and not the obs that exhibit a...

Hey, I am having a SAS data set of the form: Name P VO ABC 4.80 1000 ABC 4.80 . ABC 4.80 . EFG 6.40 2000 EFG 6.40 . EFG 6.40 . but of course, with hundreds of names and thousands of observations (P & VO) for each name value. My objective is to "clean" the tail of each name group for...

Hey kdt82, thanks for the tek-tip! I have started using SAS as a by-product of my research work, with no expertise help whatsoever. Initially, i was deterred by the fact that my only support/help would be the Manuals of SAS Institute which lack coverage/variety in their examples given...

Hey again, after quite of effort.. i managed to solve my 2nd problem on my own (Beginner's luck..). I am providing all of the details for your reference: Available input data in a csv file: DATE Price,Volume,Price,Volume ABK,EFG,ABK,EFG 25/03/2005,15.78,1000,1.88,1500...

Hey kdt, your code does resolve my case, since i know exactly the number of observation (repetitions) per line. In fact, there is a second level/problem in my query but I will give it a try first , based upon your guidance above. In the case that I cannot find it on my own, i will let you...

Thank you very much for your response. If i had just 2 pairs of Price/Volume per record, then your written code would do the job. However, in my data set, each line (record) holds HUNDREDS of observations (pairs of Price/Volume): 25/03/2005,15.78,1000,1.88,1500........,33.52,2000(200th Obs)...

Hey , Just to let you know that I am not an experienced user. My input data - in a comma delimited form - is the following : Date,Price,Volume,Price,Volume 25/03/2005,15.78,1000,1.88,1500 05/09/2006,10.88,2000,0.77,2500 My desired input format would be : Date Price Volume 25/03/2005...

Chris , thank you very much for helping out. In fact, this way i was introduced to SQL . Just for the record, the code i used, using your advice is: proc sql; create table pract.assignstate as select ex.exdate, interval.state from pract.exdatesample as EX left join pract.Nber as...

Hey ! i am not a much experienced user and i would like your help. I have two SAS datasets only including dates. Dataset1: 'Pract.Listofdates' containing just one variable ie. a list of Xdates Dataset2: 'Pract.Nber_expansion' containing two variables/ lists of dates : a startdate & an enddate...