cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DBailey
‎03-18-2025
  • 618 Posts
  • 1 Likes Given
  • 10 Solutions
  • 262 Likes Received

Re: pie charts

by Lapis Lazuli | Level 10 in Graphics Programming
‎01-30-2013 03:36 PM
‎01-30-2013 03:36 PM
I think the suggested approach for this is to use the SAS Add-in for Office.  Its a simple matter to then link the SAS Data range to the chart. ... View more

Re: Exception was thrown while waiting (Olap)

by Lapis Lazuli | Level 10 in SAS Web Report Studio
‎01-30-2013 03:04 PM
‎01-30-2013 03:04 PM
Sounds like a job for SAS Support. ... View more

Re: Using first and last function with ties

by Lapis Lazuli | Level 10 in SAS Programming
‎01-30-2013 03:00 PM
3 Likes
‎01-30-2013 03:00 PM
3 Likes
If you're truly trying to track team dates, then something like this might be better: proc sql; create table team_dates as select distinct team, game_date from have order by team, game_date; quit; data want; set team_dates; format game_lag 8.; by team; if first.team then game_lag=0; else game_lag=game_date - lag(game_date); run; should produce something like Team Game_Date game_lag A 4/3/12 0 A 4/4/12 1 A 4/6/12 2 A 5/1/12 24 B 5/1/12 0 B 5/5/12 4 ... View more

Re: Set to missing if date is a repeat

by Lapis Lazuli | Level 10 in SAS Programming
‎01-30-2013 02:22 PM
‎01-30-2013 02:22 PM
proc sort in=in out=in; by c_id ckd_dt; run; data want; set in; by c_id ckd_dt; if not first.ckd_dt then ckd_dt=.; run; ... View more

Re: Rolling 12 months data

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-30-2013 12:27 PM
3 Likes
‎01-30-2013 12:27 PM
3 Likes
I added a true date column in your test data: data test;    input year  month  a $ count;    format dt date9.;    dt = mdy(month,1,year);    cards;    2012   1   aa  160    2012   1   bb  260    2012   2   aa  760    2012   2   bb  860    2012   3   aa  260    2012   3   bb  960    2012   4   aa  760    2012   4   bb  660    2012   5   aa  560    2012   5   bb  660    2012   6   aa  460    2012   6   bb  460    2012   7   aa  360    2012   7   bb  260    2012   8   aa  260    2012   8   bb  960    2012   9   aa  160    2012   9   bb  860    2012   10  aa  575    2012   10  bb  775    2012   11  aa  690    2012   11  bb  390    2012   12  aa  760    2012   12  bb  560    2013   1   aa  490    2013   1   bb  290    2013   2   aa  809    2013   2   bb  709    2013   3   aa  609    2013   3   bb  309 ; run; proc sql; select     case         when t1.dt = t2.curr_dt then 'Current'         when t1.dt > intnx('month',t2.curr_dt,-13) then 'Prior Rolling 12 Months'         end as Period     ,count(*) as Obs     ,avg(count) as Mean_Count     ,min(count) as Min_Count     ,max(count) as Max_Count from       test t1,     (select max(dt) format=date9. as curr_dt from test) t2 where calculated period is not null group by calculated period ; quit; produces this dataset: Current 2 459 309 609 Prior Rolling 12 Months 24 570.3333 160 960 ... View more

Re: Help!!!!

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-30-2013 12:01 PM
‎01-30-2013 12:01 PM
would you be able to use something like this? proc sql; select     t1.* from     have t1 where     mkt_row_eff_dt = (select max(mkt_row_eff_dt) from have where taxid=t1.taxid); quit; ... View more

Re: Logic help required?

by Lapis Lazuli | Level 10 in SAS Programming
‎01-30-2013 09:47 AM
‎01-30-2013 09:47 AM
I'm not quite sure I follow what you need...It sounds like you want a cal_money to be a running total of money transactions. Assuming the data is sorted by id, and transaction order... data want; set have; by id; retain Running_Balance 0; if first.id then Running_Balance=0; Running_Balance = Running_Balance - money; run; results in this dataset: 1 10 10 -10 1 20 0 -30 1 10 0 -40 1 -30 0 -10 2 5 0 -5 2 -5 0 0 2 4 0 -4 2 4 0 -8 2 -8 0 0 If this isn't what you're looking for, you'll need to provide some clarification. ... View more

Re: proc export

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-30-2013 07:45 AM
‎01-30-2013 07:45 AM
try this: proc export data=mylib.susp_reasons_previous outfile=  'C:\Users\tiliev\Desktop\report.xls' dbms=csv replace;      run; When you try to open the file with excel, you might get an error message that says the file is in a different format than the file extension, but if you click OK, excel should open the file. ... View more

Re: How could I make this code efficient?

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-29-2013 03:10 PM
4 Likes
‎01-29-2013 03:10 PM
4 Likes
or...if you didn't want to have a different dataset at the end: proc sql; update have set Wiiii_okk_Total = Wiiii_okk_Total * -1 where      (TTT_TYPE  = "Khgrgi-lff Peveksel: 3" and Wiiii_okk_Total > 0)      or      (TTT_TYPE  = "Aaaaa Bnumb nn Bhrrrr-Hff: 66" and Wiiii_okk_Total < 0) ; quit; ... View more

Re: Length of macro variable

by Lapis Lazuli | Level 10 in SAS Programming
‎01-29-2013 02:19 PM
‎01-29-2013 02:19 PM
I'm not sure you need the double ampersand. ... View more

Re: creating a new column

by Lapis Lazuli | Level 10 in Graphics Programming
‎01-29-2013 10:42 AM
1 Like
‎01-29-2013 10:42 AM
1 Like
Do you have flexibility in creating the spreadsheet?  It would be much easier if you aligned the entries in column c to the date ranges you need. ... View more

Re: proc export

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-29-2013 09:56 AM
‎01-29-2013 09:56 AM
I believe the sheet statement is only used with excel exports, not csv's. ... View more

Re: Find the missing values in the year

by Lapis Lazuli | Level 10 in SAS Programming
‎01-29-2013 09:27 AM
‎01-29-2013 09:27 AM
If you don't mind creating a tmp table to hold all of the possible records: data have; input no year sal; cards; 10 2001 100 10 2002 102 11 2001 90 11 2002 12 11 2003 13 23 2002  100 23 2003 112 run; data years; input year; cards; 2001 2002 2003 ; run; proc sql; create table work.tmp as select     tmp.no     ,tmp.year     ,have.sal from     (select distinct         t1.no         ,t2.year     from have t1, years t2) tmp     left outer join have         on tmp.no=have.no and tmp.year=have.year order by tmp.no, tmp.year; quit; data want(keep=no year sal); set tmp nobs=_Nobs; by no year; sal_prev = lag(sal); sal_next=.; RecPointer=_N_+1; if sal=. then do;     if first.no then do;         /* get next sal*/         if RecPointer < _Nobs then do;             set tmp (keep=sal rename=(sal=sal_next)) point=RecPointer;             sal=sal_next;             end;         end;     else sal = sal_prev; end; run; ... View more

Re: tranwrd() replace comma with linebreak

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎01-28-2013 04:57 PM
‎01-28-2013 04:57 PM
data have; input month $ sale; datalines; jan 2000 feb 1400 mar 2300 apr 3400 may 2700 jun 3200 july 800 aug 2900 sep 1700 oct 2100 nov 2600 dec 3200 ; run; data want; format        Month_Num 8.; set have; month_num=month(input(month||' 01, 2000',anydtdte20.0)); run; ... View more

Re: Running sum in a transactions table

by Lapis Lazuli | Level 10 in SAS Procedures
‎01-28-2013 11:29 AM
‎01-28-2013 11:29 AM
data have; input tx_id tx_date account_id amt; informat tx_date date9.; format tx_date date9.; cards; 1 01jan2012 101 1000 2 02jan2012 101 1000 3 03jan2012 101 1000 4 04jan2012 101 1000 5 05jan2012 101 1000 6 06jan2012 101 1000 7 07jan2012 101 1000 8 08jan2012 101 1000 9 09jan2012 101 1000 10 10jan2012 101 1000 11 01jan2012 102 5000 12 01jan2012 103 100 ; run; proc sql; select distinct account_id from (select     t1.account_id     ,t1.tx_date    from     work.have t1     left outer join work.have t2         on t1.account_id=t2.account_id             and t1.tx_date <= t2.tx_date             and intnx('year',t1.tx_date,1)>=t2.tx_date group by t1.account_id, t1.tx_date having sum(t2.amt)>=5000) ; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-18-2025 04:40 PM
Likes given to
View All
Quick links