Hello Everyone: I have a column with names, but there are extra spaces in the names. I provided a sample dataset below. My goal is to remove the space between single letters and combine them into one word. However, I do not want to merge the single-letters with multi-letter words. Is it possible to write a script such that if it will search in a string and stop where a multi-letter word first appears (for example, the word Supply in the first case) and it will merge all the letters to the left of it? I would really appreciate your help with step. Thank you so much   Actual Desired A B Supply Inc AB Supply Inc A B C Machines Inc ABC Machines Inc A B C D Operations Inc ABCD Operations Inc A B C D E US Inc ABCDE US Inc   ... View more

Hello Everyone: I am working with a SAS macro to winsorize my data (please see attached). The SAS macro is below. When I run the program, it appears to be running okay (no error is generated), however there is no output. Could you help me identify what might be the problem? I tried closing the SAS program and opening back again, but it did not help. Thank you so much!   /******************************************************************************* http://www.byuaccounting.net/mediawiki/images/5/51/WinsorizeMacro.txt Winsorize macro Can winsorize or trim at specified percentiles; dsetout = leave blank to overwrite dsetin byvar = none for no byvar (trims/winsorizes pooled sample) type = delete/winsor ex: %winsor(dsetin=mydata, dsetout=mydata2, byvar=year, vars=assets earnings, pctl=0 98); winsorizes by year at 98%, puts resulting dataset into mydata2 %winsor(dsetin=mydata, vars=assets earnings, type=delete); trims pooled sample at 1% and 99%, puts resulting dataset back into mydata ********************************************************************************/ %macro winsor(dsetin=sasregrr, dsetout=aregrr, byvar=none, vars=equal, type=winsor, pctl=15 85); %if &dsetout = %then %let dsetout = &dsetin; %let varL=; %let varH=; %let xn=1; %do %until ( %scan(&vars,&xn)= ); %let token = %scan(&vars,&xn); %let varL = &varL &token.L; %let varH = &varH &token.H; %let xn=%EVAL(&xn + 1); %end; %let xn=%eval(&xn-1); data xtemp; set &dsetin; run; %let dropvar = ; %if &byvar = none %then %do; data xtemp; set xtemp; xbyvar = 1; run; %let byvar = xbyvar; %let dropvar = xbyvar; %end; proc sort data = xtemp; by &byvar; run; proc univariate data = xtemp noprint; by &byvar; var &vars; output out = xtemp_pctl PCTLPTS = &pctl PCTLPRE = &vars PCTLNAME = L H; run; data &dsetout; merge xtemp xtemp_pctl; by &byvar; array trimvars{&xn} &vars; array trimvarl{&xn} &varL; array trimvarh{&xn} &varH; do xi = 1 to dim(trimvars); %if &type = winsor %then %do; if trimvars{xi} ne . then do; if (trimvars{xi} < trimvarl{xi}) then trimvars{xi} = trimvarl{xi}; if (trimvars{xi} > trimvarh{xi}) then trimvars{xi} = trimvarh{xi}; end; %end; %else %do; if trimvars{xi} ne . then do; if (trimvars{xi} < trimvarl{xi}) then delete; if (trimvars{xi} > trimvarh{xi}) then delete; end; %end; end; drop &varL &varH &dropvar xi; run; %mend winsor;     ... View more

Hi Everyone: I have a data set that looks like this: ABC INVESTMENT TR CO TR ABC WORLD CO TRANSPORTATION ABC SKYE INVESTMENT TR ABC CLOUD PROPERTY TR ABC MOVIES PRODUCTION TRUSTME TRUST YOURSELF TR TRUE TRACTOR   Strings vary in length. My goal is to replace "TR" at the end of the string with "TRUST". I want to do this if and only if the last word is TR. Ideally, the data will look like this: ABC INVESTMENT TR CO TRUST ABC WORLD CO TRANSPORTATION ABC SKYE INVESTMENT TRUST ABC CLOUD PROPERTY TRUST ABC MOVIES PRODUCTION TRUSTME TRUST YOURSELF TR TRUE TRACTOR I used tranwrd successfully to replace other parts of the strings, but got stuck on the last one. Could you help me with this? I am using SAS 9.4.   Thank you so much!         ... View more

Hi Everyone:   I posted below an example data set along with a column that I would like to create. In this data set, I have different people (personid) and for some observations, an event is present (1) and for some it is not (0). The data are sorted by personid and date, which I did not show. I want to create a new column (want): -whenever, event=0, it should be 0. -for a given personid: for the first event=1, it should be 1, and should stay as 1 as long as event=1. -for a given personid: each time, the event transitions from 0 to 1, its value increases by 1.   I do not know how exactly I should go about this. I would very much appreciate your help. Thank you   personid event want 1    0    0 1    0    0 1    0    0 1    0    0 1    0    0 1    1    1 1    1    1 1    1    1 1    1    1 1    1    1 1    0    0 1    0    0 1    1    2 1    1    2 1    1    2 1    0    0 1    1    3 2    1    1 2    1    1 2    0    0 2    0    0 2    0    0 2    0    0 2    1    2 2    1    2 2    1    2 2    0    0 2    0    0 2    1    3 2    1    3 2    1    3 2    0    0 2    1    4 ... View more

Hello Everyone:   I have a particular event (election) that takes place at different intervals for different states (sometimes at different intervals for the same state). Below is a sample data. Even though the election does not take place every year, I have some other data that have values every year (such as population). I would like to be able to copy the election data (Votes) from the election year to the subsequent year(s) until the next election date. For example, at the end, Alabama should have 100,000 votes for 2001 and 2002, Alaska should have 50,000 votes for 1993, 1994, and 1995. Since there is no data for the election data preceding 1992 for Alaska, 1990 and 1991 should stay blank.   I used various statements involving lags, but could not get what I need. Thank you for your help in advance.   State          Year       ElectionYear         Votes Alabama    2000      2000                       100,000 Alabama    2001    Alabama    2002            Alabama    2003       2003                     105,000 Alabama    2004 Alabama    2005 Alabama    2006       2006                      112,000 Alaska        1990         Alaska        1991 Alaska        1992         1992                    50,000 Alaska        1993         Alaska        1994 Alaska        1995 Alaska        1996          1996                    52,000 ... View more