Lets say I have a dataset that produces two columns     ATTY                FIRM Scott                 Scott and Wagner Hampshire        Mills and Walker Beasley            Jones and Beasley   In this case I want to have a flag that says if any part of the name DOES NOT MATCH (ATTY and FIRM)  then put a 'Y' in a flag called Choose, else do not choose it.  So in this case only Hampshire      Mills and Walker would get chosen.  Is there a way to do this?   ATTY                FIRM                                          choose Scott                 Scott and Wagner Hampshire        Mills and Walker                            Y Beasley            Jones and Beasley ... View more

data montreal baltimore jersey; set sashelp.baseball(keep= name team nhits); if nhits >=20 and nhits <= 60; if team = 'Montreal' then output Montreal; if team = 'Baltimore' then output Baltimore; if team = 'Jersey' then output Jersey; run; %macro eof(report); data &report.;   if eof then output; modify &report. end=eof;   run; %mend;   %eof(montreal); %eof(baltimore); %eof(jersey);   In this case the only dataset that has no records is Jersey.  How would I insert a statement in the "Team" variable that says "No Records" ... View more

data have; input DOW $ HOLIDAY_FLG $ DATE DATE9.; FORMAT DATE DATE9.; DATALINES;     MON Y 1JAN2018 TUE N 2JAN2018 WED N 3JAN2018 THU N 4JAN2018 FRI N 5JAN2018 SAT N 6JAN2018   notice that 1jan2018 is a holiday.  If I encounter a holiday on a Monday I want to add a field called date_flg and say MON Y 1JAN2018    4 TUE N 2JAN2018     2 WED N 3JAN2018    2 THU N 4JAN2018     2 FRI N 5JAN2018      2 ; RUN; If Mon is a holiday I want the date_flg to equal 4, the remaining days of the week should equal 2 If Mon is NOT a holiday I want the date_flg to equal 3 and the remaining days of the week should equal 1  I tried the lag function without success.  Essentially I am attempting to evaluate previous row and populate based on this.  Any ideas ... View more

data a; input my1:$2. my2:$2. clm drg tin; datalines;   aa bb 1 2 3 bb cc 2 3 4 dd ee 3 4 5 ff gg 4 5 6 hh ii 6 7 8 ; run; data b; input cust1:$2. cust2:$2. clm drg tin; datalines;   aa bb 1 2 3 bb cc 2 3 4 zz xx 3 4 5 yy ww 4 5 6 hh ii 2 7 8 ; run; I am attempting to create a dataset where the contents of both tables DO NOT EQUAL   So in this case I want the first two rows in both are the same so i want to eliminate them.  I then want to create a dataset of the unique values Can this be done in a proc sql or datastep   ... View more

data have; length Teammate $50; input Process $  Teammate $; datalines AAAA     John AAAA    Charles BBBB  Samuel run;   input_record LN     PROCESS      TEAMMATE 1        AAAA     2        AAAA 3      BBBB   PROC SQL; CREATE TABLE COMBINE AS SELECT * FROM HAVE  A LEFT JOIN INPUT_RECORD  B ON A.PROCESS = B.PROCESS ;QUIT   If I run this code process AAAA will be assigned to teammate    John for both 1 and 2.  Is there a way to assigned this randomly (John would get 1 and Charles would get 2).  The reason for this is because the customer provided a spreadsheet similar to input_record in which multiple people can be assigned the same process.   ... View more

data have1; length Group $50; input Group $ _NAME_ $ Value date $; datalines;   WWWW AARP 50 1jun2018 TTTT BBRP 123 5may2015 DDDD BBRP 123 5may2015 run; data have2; length Group $50; input Group $ _NAME_ $ Value date $; datalines;   DDDD AARP 50 1jun2018 QQQQ BBRP 123 5may2015 CCCC BBRP 123 5may2015 run; data have3; length Group $50; input Group $ _NAME_ $ Value date $; datalines;   AAAA AARP 50 1jun2018 BBBB BBRP 123 5may2015 DDDD BBRP 123 5may2015 run; %macro Final(final,sheet_nm);   ODS TAGSETS.ExcelXP options(sheet_interval='none' default_column_width='9' sheet_name=&sheet_nm. center_horizontal="no" frozen_headers = "Yes" Orientation='Landscape' embedded_titles='Yes' fittopage="No" blackandwhite="No" Embedded_Footnotes='Yes' absolute_column_width='9' autofit_height="Yes"); PROC REPORT DATA= &final. headskip split='*' wrap nowd;   COLUMNS _all_; RUN; 　 　 %mend final;     %Final(HAVE1,"HAVE"); %Final(HAVE2,"HAVE2"); %Final(HAVE3,"HAVE2");   The above mentioned code is designed to output 3 different tabs of output, have 1 have2 and have3 I want to output have1 separately however I want to output have2 and have 3 in the same tab and identify each with its unique title TAB1 have1   TAB2 have2 "have2" have3 "have3"   How could I do this and would I need a second macro statement to capture the unique tite ... View more

While in sas eg I am unable to choose save as.  When I choose it, sas eg freezes.  I cleared out the search in regedit sas 7.1 however the issue persists.  Has anyone else experienced this ?   I can choose save but not save as.  This means I am unable to create a new program and save it. ... View more

data have; input Group $  Value $ datalines; BBBB $250 CCCC $500 ; run   I did the following; data want; set have; val_1 = input(Value,8.);  Also tried other numeric such as 12 to convert to a numeric run; My results do not convert to a number.  Instead I get error message such as Invalid argument to function INPUT   Is it because even though it shows as a character it includes dollar signs.  How can I get this to convert to a numeric. ... View more

data test1; input Group $ Date1 date9.; datalines;   AARP 1JUN2013 BBPP 12AUG2016 ; run; data test2; set test1; format date1 date9.; run;   　 proc export = test2 OUTFILE= "&dorsshare.\GS\citiday..txt" dbms=DLM replace; delimiter='|'; run;   When the end user receives the file and imports it, for some reason the date1 imports as a text.  The exact thing happened when I imported in MS Access.  The date defaults to text even though it was defined as a date in the datastep.  Do I need to change date1 to a numeric or date at proc export runtime???   ... View more