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: 
Alpay
‎07-30-2018
  • 96 Posts
  • 0 Likes Given
  • 0 Solutions
  • 46 Likes Received

Re: Row/column headings colors in tabulate

by Fluorite | Level 6 in ODS and Base Reporting
‎07-03-2012 04:53 PM
1 Like
‎07-03-2012 04:53 PM
1 Like
You can set the background/foreground colors using style elements. To change text color for column/row headers use "style" option after "class" statement. To change text color for column/row categories use "style" option after "classlev" statement. Ex: proc tabulate data=sashelp.class;   class sex / style=[background=white foreground=red];   classlev sex / style=[background=yellow foreground=blue];   class age / style=[background=red foreground=white];;   classlev age / style=[background=blue foreground=yellow];   table sex='Gender',   age='age'*n=''*[style=[background=green foreground=white]]   / box=[label='Box Label' style=[background=white foreground=green]]; run; ... View more

Re: What are the functions to repalce words but not substrings in a ch...

by Fluorite | Level 6 in SAS Data Science
‎07-03-2012 12:51 PM
‎07-03-2012 12:51 PM
Hi PG, Thanks for the tip. I will keep that in mind from now on. Alpay ... View more

Re: What are the functions to repalce words but not substrings in a ch...

by Fluorite | Level 6 in SAS Data Science
‎07-03-2012 09:20 AM
‎07-03-2012 09:20 AM
Your words may be at the beginning/end of a sentence, preceeded/followed by periods/commas/exclamation marks, etc. \b: word boubdary ABC: Search string xyz: Replace string data have;   string = 'ABC abcde dabc abc abc, abc.';   new_string = PRXCHANGE("s/\bABC\b/xyz/i",-1,string);   put (_all_)(=); run; string=ABC abcde dabc abc abc, abc. new_string=xyz abcde dabc xyz xyz, xyz. ... View more

Re: Regarding Gap month

by Fluorite | Level 6 in SAS Procedures
‎07-03-2012 02:46 AM
‎07-03-2012 02:46 AM
Counting number of months between EXPDAT from previous record and EFFDAT for current record for a given MembNo. If a gap exists in enrollment then gap variable incremented. data have; input Membno $ GRPNUM $ EFFDAT anydtdte. EXPDAT anydtdte.; format EffDat ExpDat date9.; datalines; ABC LI 20120201 20120201 ABC H1NAS 20120201 20120331 ABC PAMAS 20120401 99999999 DEF LI 20120101 20120229 DEF H1NAS 20120401 20120430 DEF PAMAS 20120601 99999999 GHI LI 20120201 20120229 GHI H1NAS 20120301 20120331 GHI PAMAS 20120401 20120430 GHI PAMAS 20120601 20120630 JKL LI 20120401 20120430 JKL H1NAS 20120501 20120531 JKL PAMAS 20120601 99999999 MNO LI 20120101 20120331 MNO H1NAS 20120401 20120430 ; run; data want; set have; by membno; lag_expdat = LAG(ExpDat); if first.membno then gap = 0; else gap + (MAX(0,INTCK('month',lag_expdat,effdat)-1)); retain gap; if last.membno and gap; keep membno grpnum gap; run; ... View more

Re: Why the order of execution is changing here? (SAS follows the stan...

by Fluorite | Level 6 in SAS Data Science
‎07-02-2012 06:34 AM
‎07-02-2012 06:34 AM
Order of operations followed here. Multiplication and division have the same precedence in which case operations performed from left to right. ... View more

Re: a simple PRINT proc with one obs/page

by Fluorite | Level 6 in SAS Procedures
‎06-28-2012 06:50 AM
‎06-28-2012 06:50 AM
You can do that with a proc report statement. Need a variable to break records row by row. In this example, Idx varianble is used to break report one page per observation but not shown in the output. data x;   set sashelp.class;   Idx + 1; run; proc report data=x nowd missing;   column Idx Name Sex Age Height Weight;   define Idx / order noprint;   define Name / display;   define Sex / display;   define Age / display;   define Height / display;   define Weight / display;   break after Idx / page; run; ... View more

Re: converting character field to date field

by Fluorite | Level 6 in SAS Programming
‎06-28-2012 05:18 AM
‎06-28-2012 05:18 AM
There is an exclamation mark, "!", in your data set name. You can add "dt" after the closing quote to treat the value as a datetime value (number of seconds since 1/1/1960). Use DATEPARTF() function to extract the date. %let Next_Day_1 =  23Jun2012:00:00:00; %let Next_Day_2 =  25Jun2012:00:00:00; DATA WORK.TABLE_A; set WORK.TABLE; if day = 'D1_VOL' then DAY_DATE = DATEPART("&NEXT_DAY_1"dt); else if day = 'D2_VOL' then DAY_DATE = DATEPART("&NEXT_DAY_2"dt); %* The following should work, too; /* if day = 'D1_VOL' then DAY_DATE = "%SUBSTR(&NEXT_DAY_1,1,9)"d; else if day = 'D2_VOL' then DAY_DATE = "%SUBSTR(&NEXT_DAY_2,1,9)"d; */ format Day_Date date9.; Run; ... View more

Re: Summary Table questions in EG

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-28-2012 04:52 AM
‎06-28-2012 04:52 AM
Hi, can you post some data? Also, can you explain why the percentage values are the same on a given row? For A School, Count values are different (4, 5, 6) but percentages the same (8.7, 8.7, 8.7). For B School, Count values are the same as A School (4, 5, 6) but percentage values (7.7, 7.7, 7.7) not the same as percentage values for A School. ... View more

Re: Replace strings using prxchange

by Fluorite | Level 6 in SAS Procedures
‎06-28-2012 04:00 AM
‎06-28-2012 04:00 AM
You may also use "i" option to make search case insensitive. data x; length original_credit_provider $32; input original_credit_provider $1-32; ocp=prxchange("s/PTY\.? (Limited|Ltd\.?)//i", -1, original_credit_provider); datalines; ABC Pty. Ltd. ABC Pty. Limited ABC Pty Limited ABC Pty Ltd. ; run; ... View more

Re: error about macro

by Fluorite | Level 6 in SAS Procedures
‎06-28-2012 03:41 AM
3 Likes
‎06-28-2012 03:41 AM
3 Likes
You are referring to c2 to c6 macro variables defined inside intialize macro. Their scope is the issue here (local macro variable, not known outside of the macro in which they are defined). Also, I did not see a closing parenthesis and semicolon at the end of %let statement. Added "%global c&j;" statement. Added ");". Can you try with the following macro defintion? %macro initialize;   %do j= 2 %to 5;          %let k = %eval(&j-1);          %global c&j;          %let c&j = %eval(&&c&k + 31*&&f&j);   %end; %mend; ... View more

Re: Transforming dataset. Using values to create new variable names an...

by Fluorite | Level 6 in SAS Programming
‎06-27-2012 10:38 AM
4 Likes
‎06-27-2012 10:38 AM
4 Likes
data x; input ID   QSN $  VALUE $; datalines; 1 Prep Zov 1 Prep Pan 1 Prep Dol 1 Strength 50 1 Strength 50 1 Strength 100 2 Prep Zov 2 Prep Zov 2 Prep Zov 2 Strength 55 2 Strength 50 2 Strength 60 ; run; data want; length ID 8; array p[1:3] 8 Zov Pan Dol; array s[1:3] 8 ; array st[1:3] 8 Zov_Strength Pan_Strength Dol_Strength; call missing(of Zov_: Pan_: Dol_: s:); do idx=1 to 3;    p[idx]=0; end; idx = 0; do until(last.ID);   set x;   by ID;     idx + 1;     if Idx = 4 then Idx = 1;     if QSN = 'Prep' then do;      if Value = 'Zov' then do;Zov + 1;_Zov_Idx = Idx;end;      else if Value = 'Pan' then do;Pan + 1;_Pan_Idx = Idx;end;      else if Value = 'Dol' then do;Dol + 1;_Dol_Idx = Idx;end;     end;     else if QSN = 'Strength' then do;      s[Idx] = INPUT(Value,best12.);     end; end; if Zov = 3 then do;CALL SORTN(of s:);Zov_Strength = s[3];end; else if Pan = 3 then do;CALL SORTN(of s:);Pan_Strength = s[3];end; else if Dol = 3 then do;CALL SORTN(of s:);Dol_Strength = s[3];end; else do;   Zov_Strength = s[_Zov_Idx];   Pan_Strength = s[_Pan_Idx];   Dol_Strength = s[_Dol_Idx]; end; keep Zov: Pan: Dol: ID; run; ... View more

Re: HELP: 3 precise and challenging commands

by Fluorite | Level 6 in SAS Procedures
‎06-27-2012 02:42 AM
‎06-27-2012 02:42 AM
How would you calculate Change when DIVAMT varies within a given year? In 1963 DIVAMT started at 0.625 and changed to 0.70 and then to 0.40 within the same year. Do these count as Change? What is the DIVAMT for a given year (first/last recorded amount)? In 1964 DIVAMT started at 0.40 and changed values several times. When compared the last record of 1963 with the first record of 1964 DIVAMT values are the same. What will Change be in this case? PERMNO DIVAMT YEAR 10006 0.45 1965 10006 0.75 1965 10006 0.75 1965 10006 0.625 1965 10006 0.625 1964 10006 0.625 1964 10006 0.5 1964 10006 0.4 1964 10006 0.4 1963 10006 0.7 1963 10006 0.7 1963 10006 0.625 1963 ... View more

Re: error in proc format

by Fluorite | Level 6 in SAS Procedures
‎06-26-2012 09:41 AM
‎06-26-2012 09:41 AM
Can you post some data as to how your proc format is defined? ... View more

Re: HELP: 3 precise and challenging commands

by Fluorite | Level 6 in SAS Procedures
‎06-26-2012 05:39 AM
‎06-26-2012 05:39 AM
Data set seems to be sorted by PERMNO and descending YEAR, but there are multiple records for a given YEAR. How do they get sorted within a year? Can you provide some examples to the above cases with your data? e.g.: What record would have 1 for Initiation column for PERMNO 10001? ... View more

Re: Help in SAS Program automation

by Fluorite | Level 6 in SAS Programming
‎06-26-2012 03:16 AM
‎06-26-2012 03:16 AM
data x; input client_id $ Est_Amount Max_Play Avg_Play in_date anydtdte. out_date anydtdte. Start_Time time11. End_Time time12. timeplayed Room_Number ; IN_Datetime = in_date * 86400 + Start_Time; Out_Datetime = out_date * 86400 + End_Time; format IN_Datetime Out_Datetime datetime20. In_Date Out_Date Date9. Start_Time End_Time time8.; datalines; P1 33000 20000 5000 3/7/2012 3/7/2012 04:17:00 PM 06:34:00 PM 137 4444 P2 -30000 7000 2000 3/7/2012 3/7/2012 04:31:00 PM 06:16:00 PM 105 4444 P1 -233000 30000 15000 3/7/2012 3/7/2012 06:34:00 PM 07:55:00 PM 81 4444 P3 -50000 50000 50000 3/7/2012 3/7/2012 06:59:00 PM 07:00:00 PM 1 4444 P1 -47000 20000 10000 3/7/2012 3/7/2012 09:05:00 PM 09:48:00 PM 43 6789 P2 42000 25000 10000 3/7/2012 3/7/2012 09:24:00 PM 10:49:00 PM  85 6789 P4 8000 21000 8000 3/7/2012 3/7/2012 09:38:00 PM 10:55:00 PM  77 6789 ; run; data want1;     if _n_ = 1 then GroupId = 0;     retain GroupId;     set x;     by Room_Number notsorted;     Lag_Out_Datetime = LAG(Out_Datetime);     if first.Room_Number or Lag_Out_Datetime < In_Datetime then do;         GroupId + 1;     end;     drop Out_Datetime In_Datetime Lag:; run; proc sql noprint;   select max(Freq) into :maxfreq   from (   select GroupId, Count(1) as Freq from want1 group by GroupId); quit; data want2;   array p[1:&maxfreq] $3;   array total[1:&maxfreq];   do k=1 to &maxfreq;     p = ' ';     total = .;   end;   n = 0;   if _n_ = 1 then do;     declare hash h(ordered:'a');     h.defineKey('client_id');     h.defineData('client_id');     h.defineDone();     declare hiter hi('h');   end;   do until(last.GroupId);       set want1;       by GroupId;     n + 1;     p = client_id;     total = est_amount;   end;   do k=2 to n;     ncomb = comb(n,k);     do i=1 to ncomb;       rc=allcomb(i, k, of p );       rc=allcomb(i, k, of total );       tot = 0;       length Combinations Flagged $200;       h.clear();       Combinations = '';       do j=1 to k;         tot = SUM(tot,total );         client_id = p ;         h.add();       end;       rc = hi.first();       do while(rc = 0);         Combinations = CATX(',',Combinations,client_id);         rc = hi.next();       end;       tot_flag = (ABS(tot) <= 5000);       if tot_flag ne 1 then Flagged = '';       else Flagged = Combinations;       output;    end; end; keep GroupId Combinations Flagged; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-30-2018 04:57 PM
Likes from
Quick links