this is my test data: type date A 01-Oct-09 A 01-Jan-10 A 01-Apr-10 A 01-Jul-10 A 01-Oct-10 A 01-Jan-11 A 01-Apr-11 A 01-Jul-11 this is the test program data work.fy1 (KEEP=TYPE DATE FY); set work.fy; format FY crpyrf.; YEAR=YEAR(DATE) ; QTR=QTR(DATE) ; MTH=MONTH(DATE); if qtr=4 then FY=year; else FY=year-1 ; if qtr=4 then qtr=1; else qtr=qtr+1; RUN; this is the results: type date FY A 01-Oct-09 09-Oct A 01-Jan-10 09-Oct A 01-Apr-10 09-Oct A 01-Jul-10 09-Oct A 01-Oct-10 2010 A 01-Jan-11 2010 A 01-Apr-11 2010 A 01-Jul-11 2010 how do I manage to get this: type date FY A 01-Oct-09 09/10 A 01-Jan-10 09/10 A 01-Apr-10 09/10 A 01-Jul-10 09/10 A 01-Oct-10 10/11 A 01-Jan-11 10/11 A 01-Apr-11 10/11 A 01-Jul-11 10/11 thank you very much for your help ... View more

The only thing I look against is that it would become a long list... as I have more than 25 years data per quarter! Thank you very much for the display format. ... View more

Well I have sas 9.1.3 and I would like to import an excel file *.xlsx file, but so far I haven't being able to import this type of file. Is there something special I have to do? a add-in? I hope someone who has experienced this, could be able to help me. Thanks coba ... View more

do not worry about my date format, I managed ... View more

That's great! Yes, that is what I was looking for. (I must confess that my sas skills are rather limited!) I would like to have my date on date7. format I know the long way already (by separating the year and the quarter and then joining then back) , how could I accomplish that in a short way? Thank you very much. ... View more

I do not know what I am doing wrong but the result is for m=1960Q1 for all observations. I already checked if year and month are numeric values, they are! I put together this: data test1; input Product $ country $ year month quantity; datalines; 10010000 Brazil 2007 1 100 10010000 Brazil 2007 1 23 10010000 Brazil 2007 3 100 10010000 Brazil 2007 3 360 ; proc means nway data= work.test1 missing noprint; var quantity ; class country product year month; format month YYQ. ; /* with C,D,N,P or S for that x */ output out=work.test2( drop= _TYPE_ _FREQ_ ) sum= ; run ; but the result is not what I expect. ... View more

I have something like this: data work.test1; set work.test; if Month in (1,2,3) then m=1; else if Month in (4,5,6) then m=4; else if Month in (7,8,9) then m=7; else if Month in (10,11,12) then m=10; run; data work.test2; set work.test1; format date date7.; date=mdy(m,01,year); run; proc means nway data=work.test2 missing noprint; class country date product code ; var quantity; output out=work.test3 (drop=_TYPE_ _FREQ_) sum=quantity; run; ... View more

Probably I am doing something wrong. Before I use the proc means I put my data and quarters (if month in (1,2,3) then qtr=1, etc... Then I summarize them. Should I think of another way to sum my quantities? Thanks for your help. ... View more

how do you manage when you have more variables to classify, following you example, age, color of eyes? would you if first.sex then genderheight=0; allheight + height; add else and use the other variables? ... View more

I manage to make cumulative series, but how do I manage to have by year and by type? data work.cum; input date date7. volume type $; datalines; 01jan07 2000 a 01feb07 1000 a 01jan07 2000 b 01feb07 1000 b 01jan07 2000 c 01feb07 1000 c 01jan08 2000 a 01feb08 1000 a 01jan08 2000 b 01feb08 1000 b 01jan08 2000 c 01feb08 1000 c ; data work.cum2; set work.cum; format date date7.; retain cumvol 0; cumvol = sum( cumvol, volume, type); run; ... View more