About Aman4SAS

Aman4SAS · ‎04-19-2016

Hi All, I am using proc fastclus to do the cluster analysis, but i need value of centroid too. is there any possiblity to get centroid value using proc fastclus. Thanks in Advance.

Aman4SAS · ‎02-23-2016

Hi All i am getting "WARNING: (continued)%n194" in log window while i run any code. But its not effecting any output data. Please suggest if i need to ignore or do i need to do any changes.

Aman4SAS · ‎02-22-2016

Thanks, in my code x is a trigger as date() or today(). we can replace x by date() or today(). i use check the data/movement for whole year. in ur code its breaking for 4-4 month, its my mistake i have provided you output like that. Thanks a lot.

Aman4SAS · ‎02-22-2016

As i have mentioned in my previous post: i have only value is today(); in case if i will run the code in month of jan -16 then i will get out put : JAN15 T1M1 JAN15 T1M2 FEB15 T1M2 JAN15 T1M3 FEB15 T1M3 MAR15 T1M3 JAN15 T1M4 FEB15 T1M4 MAR15 T1M4 APR15 T1M4 MAY15 T2M1 MAY15 T2M2 JUN15 T2M2 MAY15 T2M3 JUN15 T2M3 JUL15 T2M3 MAY15 T2M4 JUN15 T2M4 JUL15 T2M4 AUG15 T2M4 SEP15 T3M1 SEP15 T3M2 OCT15 T3M2 SEP15 T3M3 OCT15 T3M3 NOV15 T3M3 SEP15 T3M4 OCT15 T3M4 NOV15 T3M4 DEC15 T3M4 WHEN I WILL RUN IN FEB16 THEN I WILL GET OUTPUT : JAN16 T1M1 WHEN I WILL RUN IN MAR16 THEN I WILL GET OUTPUT : JAN16 T1M1 JAN16 T1M2 FEB16 T1M2 WHEN I WILL RUN IN APR16 THEN I WILL GET OUTPUT : JAN16 T1M1 JAN16 T1M2 FEB16 T1M2 JAN16 T1M3 FEB16 T1M3 MAR16 T1M3 WHEN I WILL RUN IN MAY16 THEN I WILL GET OUTPUT : JAN16 T1M1 JAN16 T1M2 FEB16 T1M2 JAN16 T1M3 FEB16 T1M3 MAR16 T1M3 JAN16 T1M4 FEB16 T1M4 MAR16 T1M4 APR16 T1M4 WHEN I WILL RUN IN JUN16 THEN I WILL GET OUTPUT : MAY16 T2M1 WHEN I WILL RUN IN JUL16 THEN I WILL GET OUTPUT : MAY16 T2M1 MAY16 T2M2 JUN16 T2M2 WHEN I WILL RUN IN AUG16 THEN I WILL GET OUTPUT : MAY16 T2M1 MAY16 T2M2 JUN16 T2M2 MAY16 T2M3 JUN16 T2M3 JUL16 T2M3 WHEN I WILL RUN IN SEP16 THEN I WILL GET OUTPUT : MAY16 T2M1 MAY16 T2M2 JUN16 T2M2 MAY16 T2M3 JUN16 T2M3 JUL16 T2M3 MAY16 T2M4 JUN16 T2M4 JUL16 T2M4 AUG16 T2M4 WHEN I WILL RUN IN OCT16 THEN I WILL GET OUTPUT : SEP16 T3M1 WHEN I WILL RUN IN NOV16 THEN I WILL GET OUTPUT : SEP16 T3M1 SEP16 T3M2 OCT16 T3M2 WHEN I WILL RUN IN DEC16 THEN I WILL GET OUTPUT : SEP16 T3M1 SEP16 T3M2 OCT16 T3M2 SEP16 T3M3 OCT16 T3M3 NOV16 T3M3 WHEN I WILL RUN IN JAN1716 THEN I WILL GET OUTPUT : SEP16 T3M1 SEP16 T3M2 OCT16 T3M2 SEP16 T3M3 OCT16 T3M3 NOV16 T3M3 SEP16 T3M4 OCT16 T3M4 NOV16 T3M4 DEC16 T3M4 THIS IS A SAMPLE FOR MY DESIRE OUTPUT: HERE MMDDYYN10. COLUMN ALSO ADDED FOR RESPECTIVE FIRST DAY OF MONTH I.E FOR JAN15 - 01012015 I HOPE IT WILL HELP YOU TO UNDERSTAND MY REQUEST

Aman4SAS · ‎02-22-2016

data test; set date; array y[3] day1-day3; if _n_=1 then do; old_n=1; group=0; subgroup=0; end; do i = 1 to 3; if y[i] ne . then do; group=i; if group=old_n then subgroup=subgroup+1; else do; old_n=i; subgroup=1; end; output; end; end; retain old_n subgroup; drop old_n i; run;

Aman4SAS · ‎02-21-2016

Hi, Thanks a lot for your valuable time and solution over my problem. I need it dyanamic as i mention that when i will run it on December then it will give me output till november on same patter as ur code is providing output. i.e in Jan it will give complete last year output , in Feb it will give only Jan T1M1 and Mar it will give : Jan T1M1 Jan T2m2 Feb T2M2 as so on. Thanks

Aman4SAS · ‎02-21-2016

data test; infile cards truncover; input x $200.; cards; 1023 David Shaw red 189 165 1049 Amelia Serrano yellow 145 124 1219 Alan Nance red 210 192 1246 Ravi Sinha yellow 194 177 1078 Ashley McKnight red 127 118 1221 Jim Brown yellow 220 . ; run; data test2; set test; id=scan(x,1); name=catx(" ",scan(x,2),scan(x,3)); color=scan(x,4); no1=scan(x,5); no2=scan(x,6); drop x; run;

Aman4SAS · ‎02-19-2016

There is one limitation if words in name will vary i.e. 2 , 3 and 4 words in that case it will not work.

Aman4SAS · ‎02-19-2016

Hi, I using to generate few reports . my question is simple that can i get this output more simply methor/code?

Aman4SAS · ‎02-19-2016

LOGIC is if i will run the programe IN JAN-2016 then i will get output as MONTH PERIOD JAN15 T1M1 JAN15 T1M2 FEB15 T1M2 JAN15 T1M3 FEB15 T1M3 MAR15 T1M3 JAN15 T1M4 FEB15 T1M4 MAR15 T1M4 APR15 T1M4 MAY15 T2M1 MAY15 T2M2 JUN15 T2M2 MAY15 T2M3 JUN15 T2M3 JUL15 T2M3 MAY15 T2M4 JUN15 T2M4 JUL15 T2M4 AUG15 T2M4 SEP15 T3M1 SEP15 T3M2 OCT15 T3M2 SEP15 T3M3 OCT15 T3M3 NOV15 T3M3 SEP15 T3M4 OCT15 T3M4 NOV15 T3M4 DEC15 T3M4 I USED X AS TODAY() TO DO CROSS CHECK FOR EVERY MONTH'S OUTPUT CODE: DATA TEST; X="01JAN2016"D; /******FOR JAN TO APR MONTH******/ IF MONTH(INTNX("MONTH",X,-1))<=4 THEN DO ; DO I= MONTH(INTNX("MONTH",X,-1)) TO 1 BY -1; DO J= I TO 1 BY -1; TIME=CATS("T1_M",I,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; END; /********FOR MAY TO AUG MONTH********/ IF 4< MONTH(INTNX("MONTH",X,-1))<=8 THEN DO ; DO I= MONTH(INTNX("MONTH",X,-1)) TO 1 BY -1; IF I <=4 THEN DO; DO J= I TO 1 BY -1; TIME=CATS("T1_M",I,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; ELSE DO; DO J= I TO 5 BY -1; TIME=CATS("T2_M",I-4,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; END; END; /*******FOR SEP TO DEC MONTH*********/ IF 8< MONTH(INTNX("MONTH",X,-1))<=12 THEN DO ; DO I= MONTH(INTNX("MONTH",X,-1)) TO 1 BY -1; IF I <=4 THEN DO; DO J= I TO 1 BY -1; TIME=CATS("T1_M",I,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; ELSE IF 4< I <=8 THEN DO; DO J= I TO 5 BY -1; TIME=CATS("T2_M",I-4,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; ELSE IF 8< I <=12 THEN DO; DO J= I TO 9 BY -1; TIME=CATS("T3_M",I-8,"_",YEAR(INTNX("MONTH",X,-1))); YRMO=INPUT(PUT(INTNX("MONTH",X,-MONTH(INTNX("MONTH",X,-1))+J-1),YYMMN6.),6.); OUTPUT; END; END; END; END; RUN;

Aman4SAS · ‎02-19-2016

Hi All, I have created a programe to create table for trimester. I m looking for ur help/suggestion if that can be bit sort/small and with less complex. Code: data test; x="01jan2016"d; if MONTH(INTNX("MONTH",x,-1))<=4 then do ; DO I= MONTH(INTNX("MONTH",x,-1)) to 1 by -1; do j= i to 1 by -1; TIME=cats("T1_M",i,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; end; if 4< MONTH(INTNX("MONTH",x,-1))<=8 then do ; DO I= MONTH(INTNX("MONTH",x,-1)) to 1 by -1; if i <=4 then do; do j= i to 1 by -1; TIME=cats("T1_M",i,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; else do; do j= i to 5 by -1; TIME=cats("T2_M",i-4,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; end; end; /****************/ if 8< MONTH(INTNX("MONTH",x,-1))<=12 then do ; DO I= MONTH(INTNX("MONTH",x,-1)) to 1 by -1; if i <=4 then do; do j= i to 1 by -1; TIME=cats("T1_M",i,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; else if 4< i <=8 then do; do j= i to 5 by -1; TIME=cats("T2_M",i-4,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; else if 8< i <=12 then do; do j= i to 9 by -1; TIME=cats("T3_M",i-8,"_",Year(INTNX("MONTH",x,-1))); YRMO=INPUT(PUT(INTNX("MONTH",x,-MONTH(INTNX("MONTH",x,-1))+j-1),YYMMN6.),6.); output; end; end; end; end; run; Thanks in advance

Aman4SAS · ‎11-23-2015

can u please help me where can i put this option? my syntax is : proc x11 data= test yraheadout; monthly date=month; var=sales; table d11; output out =test1 b1=a d10=b d11=c; run;

Aman4SAS · ‎11-23-2015

Hi , I am trying to use proc X11 to forecast my sales. But i am facing a problem that there is a negative value in my time series(due to return on that particular month). please suggest me if there is any solution in proc x11 to handle this situation or do i need to handle it other way arround? Thanks in advance

Aman4SAS · ‎11-23-2015

can u please help me where can i put this option? my syntax is : proc x11 data= test yraheadout; monthly date=month; var=sales; table d11; output out =test1 b1=a d10=b d11=c; run;

Aman4SAS · ‎11-23-2015

Hi , I am trying to use proc X11 to forecast my sales. But i am facing a problem that there is a negative value in my time series(due to return on that particular month). please suggest me if there is any solution in proc x11 to handle this situation or do i need to handle it other way arround? Thanks in advance.

Online Status	Offline
Date Last Visited	‎05-25-2021 03:59 PM

Re: Data step with Lag function

Re: Data step with Lag function

Data step with Lag function

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

If condition with macro variables

Re: Data step with Lag function

Re: Data step with Lag function

Re: Need Data Step Solution

Re: How to read Raw data with embedded blank without increasing the sp...

Re: %let = if statement, or case?... confused...

Re: How to read Raw data with embedded blank without increasing the sp...

How to get centroid value in proc fastclus

Getting : WARNING: (continued)%n194

Re: Creating Trimester using data step

Re: Creating Trimester using data step

Re: create groups

Re: Creating Trimester using data step

Re: How to read Raw data with embedded blank without increasing the sp...

Re: How to read Raw data with embedded blank without increasing the sp...

Re: Creating Trimester using data step

Re: Creating Trimester using data step

Creating Trimester using data step

Re: How to handle negative value in Proc X11

How to handle negative value in Proc X11

Re: How to handle negative value in Proc X11

How to handle negative value in Proc X11