I have been using the following in my autoexec file for the last 12 years or so:   PROC FORMAT /*LIB=BBBANAL.SEGFORMATS*/ ;    VALUE MISSING .="Missing" Other="Not Missing" ;   VALUE $MISSING ' '="Missing" Other="Not Missing" ; RUN ; ... View more

data Have;   input ID $2. HaveAge HaveGender HaveIncome; call sortn(HaveGender, HaveIncome); cards; 1 0 0 0 2 1 1 1 3 0 1 0 4 1 1 0 5 1 1 1 6 1 1 0 7 1 0 1 8 1 0 0 9 1 0 1 run; proc freq; ................ Xia Keshan ... View more

Transpose dataset by MERGE . data have;    input cbg $12. date $5. TOTAL_ADDR SDU MDU;    cards; 010010201001Q1'14 251 237 14 010010201001Q3'13 252 238 14 010010201001Q4'13 251 237 14 010010201002Q1'14 454 449 5 010010201002Q3'13 450 445 5 010010201002Q4'13 454 449 5 010010202001Q1'14 348 346 2 010010202001Q3'13 370 368 2 010010202001Q4'13 348 346 2 ;;;;    run; proc sql; select distinct 'have(where=(date="'||date||'") rename=(total_addr=total_addr_'||translate(date,'_',"'")||' sdu=sdu_'||translate(date,'_',"'")||' mdu=mdu_'||translate(date,'_',"'")||'))'   into : list separated by ' '   from have; quit; data want; merge &list ; by cbg; drop date; run; Xia Keshan ... View more

I would like to use CALL EXECUTE . data fold; input f : $40.; cards; c:\x d:\d ; run; data _null_; set fold; call execute('%let f='||f ||' ; '); call execute('%include a1 ;  '); call execute('%include a2 ;  '); call execute('%include a3 ;  '); call execute('%include a4 ;  '); run; and change libname statement in all of program. Libname MyLib " &f "; Ksharp ... View more

RW9, that's exactly what i was looking for. Thanks! Tom, Thank you for going above and beyond and showing me a few approaches to solve this. much appreciated. ... View more

Most likely the end of line characters are not carriage return and line feed like you coded in your INFILE statement. You might also need to up the LRECL. The simple way to check is to read the and let SAS show you want is in the first record. data _null_;   infile 'E:\Jeff B\Open\ClickStream\Data/centris-11252013.txt'  termstr=crlf lrecl=100000 ;   input;   list ;   stop; run; When I do that on my Unix machine I see that SAS is showing that the last character has hexadecimal code value of '0A'x which is a line feed. You can eliminate the TERMSTR option or set it to LF and try again. ... View more

Hello - Sure - you will need to change the lead option to 12 (as you have monthly data) - I also added a plot statement to visualize the forecasts: proc arima data=YOURDATA plots(only)=forecast(forecasts);             identify var=URATE( 1,12 )             nlag=29 noprint;             estimate p=2 q=( 1,2 )( 12 )              noint method=ML                outmodel=_est_ converge=.0001 delta=.0001 maxiter=500                noprint;             forecast                id=DATE interval=MONTH align=BEGINNING lead=12                alpha=0.05  out=forecasts; quit; You will find a table call forecasts in your WORK library. Alternatively you may want to run our new ESM procedure: proc esm data=YOURDATA out=_null_ outfor=esmfc plot=forecasts; id date interval=month; forecast urate / method=addwinters; run; Thanks! Udo ... View more

Thanks PG! it worked just as expected with the real data! there was a case that had 31 commas and i was able to easily identify and build off your code to accommodate. you are the man! ... View more

There might be, but I would suspect it is quite large.  If you are generating macro calls then use %NRSTR() so that only the call is pushed onto the stack and not all of the code that it generates. Note that this trick also solves some timing issues that can occur when macros are executed by SAS as they are pushed onto the stack by CALL EXECUTE, but the actual generated code is not called until after the current datastep tops. You can avoid this by just writing the code to temporary file and including it instead of using CALL EXECUTE.  This has two other advantages. 1) PUT statement syntax is much more flexible for generating the code. 2) You can generate the file and view its contents to verify that you are generating the code properly. filename code temp; data _null_;   set list;   put ..... ; run; %inc code /source2 ; ... View more

: the first line of the file and every 77th row afterword will have a value of mod(_n_,76) equal to 1.  Thus, for those records, they are read and then simply ignored. The fields in all of the other records are read and then output. ... View more

A hash variety: data one;     input member site start :anydtdtm19.;     obs = _n_;   cards;   3304 6747  01JUN2012:05:32:00   3304 6747  01JUN2012:05:32:00   3304 6990  01JUN2012:05:32:00   3304 6747  01JUN2012:05:39:00   3304 6747  01JUN2012:07:28:00   3304 6747  01JUN2012:07:28:00   3304 7254  01JUN2012:07:28:00   3304 47814 01JUN2012:07:28:00   3304 6747  01JUN2012:07:29:00   3304 6747  01JUN2012:07:29:00   3304 6990  01JUN2012:07:29:00   5569 7254  01JUN2012:07:29:00   5569 7254  01JUN2012:07:30:00   5569 6747  01JUN2012:08:15:00   5569 6747  01JUN2012:08:15:00   5569 6748  01JUN2012:08:16:00   5569 6748  01JUN2012:08:16:00   5569 6747  01JUN2012:09:14:00   5569 6747  01JUN2012:09:14:00   5569 6747  01JUN2012:09:14:00   ;   run;   data _null_;        if(1=2) then set one;        length sequence 8;        declare hash seq(ordered:"a");            rc1=seq.defineKey("member", "site", "start");                    rc2=seq.defineData("sequence");            rc3=seq.defineDone();        declare hash want(ordered:"a");            rc1=want.defineKey("obs","member", "site", "start");            rc2=want.defineData("obs","member", "site", "start","sequence");            rc3=want.defineDone();        sequence=0;        do until(done1);             set one end=done1;             by member site notsorted;        rc1=seq.add();        x=first.site;             if first.member then sequence=0;        sequence=sequence+((rc1=0)*x);        rc2=seq.replace();        end;        call missing(of _all_);        do until(done2);        set one end=done2;        seq.find();        want.add();        end;        want.output(dataset:"sequenced");   stop;   run; ... View more