I'm trying to import a text file that is stacked by a group. the first line of the file and every 77th row afterword is simply i header i wish to do away with. There are seven fields in the file: date lower_est mid_est upper_est std_dev subsystem forecast Attached is the file i'm trying to import. Any Hints? Thank you ! ... View more

Hi All,      I'm working with website tracking data. and my dataset looks like the following: Member ID Website ID Website URL Page View Start Time 3304 6747 www.google.com 01JUN2012:05:32:00 3304 6747 www.google.com 01JUN2012:05:32:00 3304 6990 en.wikipedia.org 01JUN2012:05:32:00 3304 6747 www.google.com 01JUN2012:05:39:00 3304 6747 www.google.com 01JUN2012:07:28:00 3304 6747 www.google.com 01JUN2012:07:28:00 3304 7254 slickdeals.net 01JUN2012:07:28:00 3304 47814 www.wpxi.com 01JUN2012:07:28:00 3304 6747 www.google.com 01JUN2012:07:29:00 3304 6747 www.google.com 01JUN2012:07:29:00 3304 6990 en.wikipedia.org 01JUN2012:07:29:00 5569 7254 slickdeals.net 01JUN2012:07:29:00 5569 7254 slickdeals.net 01JUN2012:07:30:00 5569 6747 www.google.com 01JUN2012:08:15:00 5569 6747 www.google.com 01JUN2012:08:15:00 5569 6748 www.facebook.com 01JUN2012:08:16:00 5569 6748 www.facebook.com 01JUN2012:08:16:00 5569 6747 www.google.com 01JUN2012:09:14:00 5569 6747 www.google.com 01JUN2012:09:14:00 5569 6747 www.google.com 01JUN2012:09:14:00 I want a data set that looks like this: Member ID Website ID Website URL Page View Start Time Sequence 3304 6747 www.google.com 01JUN2012:05:32:00 1 3304 6747 www.google.com 01JUN2012:05:32:00 1 3304 6990 en.wikipedia.org 01JUN2012:05:32:00 2 3304 6747 www.google.com 01JUN2012:05:39:00 3 3304 6747 www.google.com 01JUN2012:07:28:00 3 3304 6747 www.google.com 01JUN2012:07:28:00 3 3304 7254 slickdeals.net 01JUN2012:07:28:00 4 3304 47814 www.wpxi.com 01JUN2012:07:28:00 5 3304 6747 www.google.com 01JUN2012:07:29:00 6 3304 6747 www.google.com 01JUN2012:07:29:00 6 3304 6990 en.wikipedia.org 01JUN2012:07:29:00 7 5569 7254 slickdeals.net 01JUN2012:07:29:00 1 5569 7254 slickdeals.net 01JUN2012:07:30:00 1 5569 6747 www.google.com 01JUN2012:08:15:00 2 5569 6747 www.google.com 01JUN2012:08:15:00 2 5569 6748 www.facebook.com 01JUN2012:08:16:00 3 5569 6748 www.facebook.com 01JUN2012:08:16:00 3 5569 6747 www.google.com 01JUN2012:09:14:00 4 5569 6747 www.google.com 01JUN2012:09:14:00 4 5569 6747 www.google.com 01JUN2012:09:14:00 4 Where sequence is a counter that resets for every member_id website_id page_view_start_time combination, but does not get reset if the start time changes within the same website. In the future i would like to build in a a control that would allow me to say if you spent more than 20 minutes idle on google and then clicked on google again then that would reset the sequence counter back to 1. This is a good one! I've been messing around with first. last. processing all morning but can't quite get the results i want. Thank you all in advance. ... View more

Hi All, I'm trying to export a SAS dataset to a text file using the SAS labels as headers in my text file. i've specified the label option but I still get variable names instead. here is an example of what i'm doing and the results i get: data Have; input X Y 1.  ; label x = "X Label" y = "Y Label"; cards; 1 3 2 4 ; run; PROC EXPORT DATA= Have             OUTFILE= "E:\Jeff B\Open\Want.txt"             DBMS=DLM REPLACE;             DELIMITER='7C'x;             PUTNAMES=YES;             Label; /* variable names print despite label option being specified */ RUN; Here is the log, you can see that the "PUT" statment is still using variable names. 347  data Have; 348  input X Y 1.  ; 349  label x = "X Label" y = "Y Label"; 350  cards; NOTE: The data set WORK.HAVE has 2 observations and 2 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds 353  ; 354  run; 355 356  PROC EXPORT DATA= Have 357              OUTFILE= "E:\Jeff B\Open\Want.txt" 358              DBMS=DLM REPLACE ; 359                   Label; 360       DELIMITER='7C'x; 361       PUTNAMES=YES; 362  RUN; 363   /********************************************************************** 364   *   PRODUCT:   SAS 365   *   VERSION:   9.2 366   *   CREATOR:   External File Interface 367   *   DATE:      07AUG12 368   *   DESC:      Generated SAS Datastep Code 369   *   TEMPLATE SOURCE:  (None Specified.) 370   ***********************************************************************/ 371      data _null_; 372      %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 373      %let _EFIREC_ = 0;     /* clear export record count macro variable */ 374      file 'E:\Jeff B\Open\Want.txt' delimiter='|' DSD DROPOVER lrecl=32767; 375      if _n_ = 1 then        /* write column names or labels */ 376       do; 377         put 378            "X" 379         '|' 380            "Y" 381         ; 382       end; 383     set  HAVE   end=EFIEOD; 384         format X best12. ; 385         format Y best12. ; 386       do; 387         EFIOUT + 1; 388         put X @; 389         put Y ; 390         ; 391       end; 392      if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */ 393      if EFIEOD then call symputx('_EFIREC_',EFIOUT); 394      run; NOTE: The file 'E:\Jeff B\Open\Want.txt' is:       Filename=E:\Jeff B\Open\Want.txt,       RECFM=V,LRECL=32767,File Size (bytes)=0,       Last Modified=07Aug2012:12:21:50,       Create Time=07Aug2012:12:15:44 NOTE: 3 records were written to the file 'E:\Jeff B\Open\Want.txt'.       The minimum record length was 3.       The maximum record length was 3. NOTE: There were 2 observations read from the data set WORK.HAVE. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds 2 records created in E:\Jeff B\Open\Want.txt from HAVE. NOTE: "E:\Jeff B\Open\Want.txt" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time):       real time           0.07 seconds       cpu time            0.07 seconds ... View more

I want to generate all possible unique combinations for a series. For Example, data have;   input combinations $1.;   cards; A B C D E ; run; I want a column that has ( i think this works out to 32 distinct combinations, 2^5, no?) A AB ABC ABCDE B BC ...... Thank you, ... View more

Hi,      i want a way to check to see if any variables in my named range are negative. is there a more efficient way of accomplishing this ? data have;     input   (x1-x3) (2.);     cards; 0 1 2 1 -2 3 3 4 5 -1 0 2 2 2 2 3 3 -3    ; run; data want;     set have;     if x1<0 or      x2<0 or      x3<0; run; ... View more