Hello, I would like to search 'ECZEMA' in the six columns from string1 to string6.  Then I tried to run a do loop command.  But an error message was shown in the log window.  Please help, thank you. data want; set have ; array string_{*} String1 - String6; do i = 1 to 6; if prxmatch('/ECZEMA/i',string_) then allergy=1; end; run;   The error messages were list below, and also why in the 'Note' statement, 'Numeric values have been converted to character values?'   ERROR: Illegal reference to the array string_. NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 105:38 106:38 107:42 108:47 109:27 110:34 111:34 113:44 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.have may be incomplete. When this step was stopped there were 0 observations and 18 variables. WARNING: Data set WORK.have was not replaced because this step was stopped. ... View more

Hi Experts,   I have a sample dataset 'datain1',  it contains a column 'Name' mixed with some various text separated by comma ' , '.   I would like to distribute the 'Name' text into different columns, result1-result3, based on the comma ' , '.    Please check the result I am looking for is 'Dataout1' Please let me know how to approach it.   One thing I would like to point out that the 'Name' text includes different mixed names, sometime only have one name, sometime have three names, sometime have multiple names.   Therefore, the 'result' columns should be based on the largest 'Name' numbers in the 'Name' text.  The result3 column in the dataset is only the sample dataset I created.   Thanks.   data datain1; infile datalines delimiter='/'; input Name : $300. ; datalines; ACUTE OTITIS MEDIA,ASTIGMATISM, CONSTIPATION/ ACUTE URI, GERD/ BILATERAL. HYDRONEPHROSIS/ ; run; data dataout1; infile datalines delimiter='/'; input Name : $300. Result1 : $100. Result2 : $100. Result3 : $100.; datalines; ACUTE OTITIS MEDIA,ASTIGMATISM, CONSTIPATION/ACUTE OTITIS MEDIA/ASTIGMATISM/CONSTIPATION ACUTE URI, GERD/ACUTE URI/GERD/ / BILATERAL. HYDRONEPHROSIS/BILATERAL. HYDRONEPHROSIS/ / / ; run; ... View more

Hello, I have dataset list below. data have; infile datalines dsd; format ID 2. first_name $10. last_name $10. birthdate mmddyy10. enroll $1.; input ID : 2. first_name : $10. last_name : $10. birthdate : mmddyy10. enroll : $1.; datalines; 1, John, Doe, 01/01/2020, Y, 12, John, Doe, 01/01/2020, N, 2, Joe, Smith, 12/01/2019, Y, 22, Joe, Smith, 12/01/2019, Y, 27, Joe, Smith, 12/01/2019, Y, 32, Kevin, Mao, 02/06/2000, N, 36, Kevin, Yao, 02/06/2000, Y, 24, Beky, Lee, 08/23/2005, N, 41, Beky, Lee, 08/21/2005, N, 48, Beky, Lee, 08/23/2005, N, 49, Beky, Lee, 08/23/2005, Y, 15, Ashley, Taylor, 09/18/2000, N, 54, Ashley, Taylor, 09/18/2000, N, 65, Ashley, Taylor, 09/18/2000, N, ; run; I would like to list all the unmatching names/dob/enroll as the result shown below.   Please advice how to approach it, thanks.   data want; infile datalines dsd; format ID 2. first_name $10. last_name $10. birthdate mmddyy10. enroll $1.; input ID : 2. first_name : $10. last_name : $10. birthdate : mmddyy10. enroll : $1.; datalines; 1, John, Doe, 01/01/2020, Y, 12, John, Doe, 01/01/2020, N, 27, Joe, Smith, 12/01/2019, Y, 32, Kevin, Mao, 02/06/2000, N, 36, Kevin, Yao, 02/06/2000, Y, 24, Beky, Lee, 08/23/2005, N, 41, Beky, Lee, 08/21/2005, N, 48, Beky, Lee, 08/23/2005, N, 49, Beky, Lee, 08/23/2005, Y, ; run; ... View more

Hello, I have PROC PRINT statement below.  Because I would like to print out a lof of variables, it took two lines to print out one ID.    Although I have used 'landscape' option in 'RTF'  ODS,  the MS WORD printed out two lines.   Is there a way to enforce all the columns into one line while outputing?  Thanks.    ods rtf file = "Pathway.rtf" style=atc sasdate; options orientation=landscape; proc print data=test; var repeat_id id studysite date Sex DOB county zipcode Race1_12 totppl check site_repeat check_n site_repeat_n; format county $25.; by studysite; run; ods rtf close;   ... View more

Hi all,   I would like to print out a report by grouping studysites for a dataset 'test'.   I have a code below.  However, I found out that the output file was order by studysite, it print out the studysite and the IDs one by one.   I don't like that, I would like to out put the file with grouping the studysite first, then sorting the IDs later.  I found there is no 'GROUP' option in the PROC PRINT,  please advice how to approach it?  Thanks.   options orientation=portrait; proc print data=test; var id repeat_id studysite DOB months days; where repeat_id in (&replistdob.); by studysite repeat_id; title 'More than 1 dob for a repeat ID'; run; ... View more

Hello,W I have program list below, I found out when I add underscore '_' behind the macro i, the log showed that error message.  But it works fine after I removed it.   What if I would like to add _ behind i?   %let Y1=Cin; %let Y2=Kan; %let Y3=Vand; %macro import; %do i = 1 %to 3; %let folder="Pathway"; PROC IMPORT OUT=work.Repeater_&&Y&i. datafile=&folder dbms=xlsx replace; sheet=ARI; run; data Repeater_&&Y&i._; set Repeater_&&Y&i.; %do k = 1 %to 5; CaseID_&k. =upcase(compress(CaseID_&k., '-')); put CaseID_&k.; %end; run; %end; %mend; %import;  It seems like the warning message shown from the codes: data Repeater_&&Y&i._; WARNING: Apparent symbolic reference Y3_ not resolved.   ... View more