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: 
KachiM
yesterday
  • 585 Posts
  • 13 Likes Given
  • 54 Solutions
  • 198 Likes Received

Re: How do you use an array to convert all numeric to missing?

by Rhodochrosite | Level 12 in SAS Procedures
‎01-04-2015 10:46 AM
1 Like
‎01-04-2015 10:46 AM
1 Like
Here is another example. data want;    set sashelp.class;    array k _numeric_;    do i = 1 to dim(k);       k = .;    end; drop i; run; ... View more

Re: Array subscript out of range question

by Rhodochrosite | Level 12 in SAS Programming
‎01-03-2015 02:39 AM
‎01-03-2015 02:39 AM
You Say MOVING Maximum and Minimum. Can you post the required OUTPUT of the data set, HAVE? ... View more

Re: Any easy way to look for a value in multiple columns

by Rhodochrosite | Level 12 in SAS Programming
‎11-18-2014 04:58 AM
‎11-18-2014 04:58 AM
Yet other ways .. data _null_;      set have;      array k _character_;      if 'London' IN k then put 'Found'; run; You can use: whichC('London', of k ); ... View more

Re: Arithmetic calculations that involved figures from different rows

by Rhodochrosite | Level 12 in SAS Programming
‎11-17-2014 04:37 AM
‎11-17-2014 04:37 AM
There are several ways to do this. There is lag() function that can be used. Here, even that is not needed for the present data set. Just hold the current value as PREV and use it in calcuations. data need; retain prev;    set have;    if prev then do;       return = (Price - prev) / prev;       prev = Price;     end;    if _n_ = 1 then prev = Price; drop prev; run; ... View more

Re: Comparing IDs across tables

by Rhodochrosite | Level 12 in SAS Programming
‎11-13-2014 12:33 PM
‎11-13-2014 12:33 PM
A data step solution: data A; input ID X1 X2; cards; 100  10 20 200  20 30 500  50 70 ; run; data B; input ID; cards; 100 150 200 100 200 300 ; run; data want;    if 0 then set B;    declare hash h(dataset:'B');    h.definekey('ID');    h.definedone();    do until(last);       set A end = last;       flag = 'N';       if h.find() = 0 then flag = 'Y';       output;    end; stop; run; ... View more

Re: Getting the Max value

by Rhodochrosite | Level 12 in SAS Procedures
‎11-11-2014 11:31 AM
‎11-11-2014 11:31 AM
data need;    set have;    value = max(of value1 - value4); run; ... View more

Re: Ranking across rows instead of column

by Rhodochrosite | Level 12 in SAS Programming
‎11-11-2014 04:13 AM
‎11-11-2014 04:13 AM
Take the 3-rd largest value. Compare it with A and decide the top3_A flag. data want;    set have;    top3_A = 'N';    array k A -- H;    top = largest(3, of k );    if A >= top then top3_A = 'Y'; drop top; run; ... View more

Re: How to count frequency of columns?

by Rhodochrosite | Level 12 in SAS Data Management
‎11-10-2014 12:19 PM
‎11-10-2014 12:19 PM
Will this help you? data want;    set temp;    array k var1 - var3;    count = dim(k) - cmiss(of k ); run; ... View more

Re: Find out the nearest branch for the customers

by Rhodochrosite | Level 12 in SAS Programming
‎11-06-2014 08:43 AM
‎11-06-2014 08:43 AM
[1] Use SMALLEST() function to get the smallest by passing i = 1, 2, 3. [2] Use WHICHN() function to the numeric order of variable for [1] [3] Use VNAME() function to get the NAME for [2] ... View more

Re: Best way to use user defined formats in SAS

by Rhodochrosite | Level 12 in SAS Procedures
‎11-01-2014 06:12 AM
‎11-01-2014 06:12 AM
Try OPTIONS NOFMTERR; If getting the format is not an option, you can use the nofmterr system option. This will tell SAS to read the data set without the formats. SAS will replace the missing formats with the w. or $w. default format, and SAS will issue a warning in the log telling you that it couldn't    find the format file. ... View more

Re: Sequence Array

by Rhodochrosite | Level 12 in SAS Programming
‎10-30-2014 05:24 AM
‎10-30-2014 05:24 AM
Another Solution with Data Step. You need to have the data set, HAVE. to be pre-sorted by Child. The array size is taken as 4 but can be extended as desired. data want; array t $1 Treatment_1 - Treatment_4; do until(last.Child);    set have;    by Child;    if first.Child then i = 1; t = Treatment; i + 1; end;    else if Treatment ^= t[i - 1] then do; t = Treatment; i + 1; end; end; drop i Treatment; run; ... View more

Re: Across observation comparison, a data merge question

by Rhodochrosite | Level 12 in SAS Programming
‎10-30-2014 04:43 AM
‎10-30-2014 04:43 AM
data a; input id mid fid; datalines; 1 .  1 2 2  . 3 .  . ; run; data b; input id X $1.; datalines; 1 a 2 b 3 c ; run; Get the ID for Mother(m) and Father(f) data have; retain m f;    set a end = eof;    if mid then m = _N_;    else if fid then f = _N_;    if eof then output; keep m f; run; Use m and f to name the Variables, X_Mother and X_Father respectively. data want;    if _n_ = 1 then set have;    set b end = last;       retain X_Mother X_Father;       if id = m then X_Mother = X;       else if id = f then X_Father = X;    if last and X = 'c'; keep X:; run; ... View more

Re: Need help on substr and scan function

by Rhodochrosite | Level 12 in SAS Programming
‎10-28-2014 06:15 AM
‎10-28-2014 06:15 AM
data have; length Name $18  ALine1 $18  ALine2 $25; input Name @24 ALine1 $18. @44 ALine2 $25.; datalines; VALERIE C SANDMIRE  1302 ELLENWOOD DR MADISON WI 53714-1006 JONAH Z HAUGLEY     884 HUNTERS TRL    SUN PRAIRIE WI 53590-2585 DOROTHY A GENSKE     700 DOUGLAS TRL    MADISON WI 53716-2125 ; run; This program depends on: [1] count the number of words in ALine2. [2]  Gets the Zip at the last word adjusting for '-'. [3] State is last but one word. [4] Taking the beginning location of State, Addr2 is found in the first location - 1 positions. data want; format Name ALine1 Addr2 State Zip; keep Name ALine1 Addr2 State Zip; length State $2 zip $5 Addr2 $12;    set have;    num = countw(ALine2, ' ');    Zip = scan(ALine2, num, ' -');       State = scan(ALine2, num - 1, ' ');    loc = index(ALine2, State);    Addr2 = substr(ALine2,1, loc - 1); run; ... View more

Re: Mean and std of partial array

by Rhodochrosite | Level 12 in SAS Programming
‎10-27-2014 01:21 PM
‎10-27-2014 01:21 PM
Function to find mean and STD for partial array ie for a 2-dimensional array is not provided by SAS as far as I know. Instead compute the mean and std by adding some more steps as; data _null_; set have; array s(5,2); do i = 1 to 5;      do j = 1 to 2;           s(i,j) = age + i + j;      end; end; array mx(2); array sx(2); do k = 1 to 2;    do i = 1 to dim1(s);       X + s[i, k];       XX + (s[i,k] * s[i,k]);    end;      mx(k) = X / dim1(s);      sx(k) = (XX - X * X / dim1(s)) / (dim1(s) - 1);      put mx = ;      put sx = ; end; stop; run; Correction: Take square root of SX for STD. ... View more

Re: calculating lag

by Rhodochrosite | Level 12 in SAS Programming
‎10-25-2014 06:53 AM
3 Likes
‎10-25-2014 06:53 AM
3 Likes
Assuming that the company_id is unique then sort the data set by it. proc sort data = have; by company_id; run; There is a SAS LAG() function available. The following code just saves the previous ASSET and writes it on the next observation. The empty format statement retains the order of the variables. data want; format year company_id asset _lag; retain prev_asset _lag; drop prev_asset;    do until(last.company_id);       set have;       by company_id;       if first.company_id then do; prev_asset = asset; _lag = .; end;       else prev_asset = asset;       output;       _lag = prev_asset;    end; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
yesterday
Group Hubs for KachiM
View All
Likes given to
Likes from
Quick links