Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vassilisef

  1. vassilisef

    Using date window counters

    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...
  2. vassilisef

    Using date window counters

    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...
  3. vassilisef

    Using date window counters

    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...
  4. vassilisef

    Using date window counters

    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...
  5. vassilisef

    Iterations applied to Updated new Data set

    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
  6. vassilisef

    Iterations applied to Updated new Data set

    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...
  7. vassilisef

    Iterations applied to Updated new Data set

    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...
  8. vassilisef

    Input Statement with multiple observations per record

    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...
  9. vassilisef

    Input Statement with multiple observations per record

    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...
  10. vassilisef

    Input Statement with multiple observations per record

    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...
  11. vassilisef

    Input Statement with multiple observations per record

    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)...
  12. vassilisef

    Input Statement with multiple observations per record

    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...
  13. vassilisef

    Use IF.....THEN with dates in multiple SAS datasets

    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...
  14. vassilisef

    Use IF.....THEN with dates in multiple SAS datasets

    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...
See more

Part and Inventory Search

Back
Top