Dear all, I'm working with the data, which contains dates with missing either month (replaced with UNK) or day (replaced with UN). UPD: the values look like this: 2022JAN15, 2022JANUN and 2022UNKUN. I have seen multiple posts on the same topic, but I'm still in pursue of the most elegant solutions.   I have made it following:     data want; set have; date_new=tranwrd(tranwrd(upcase(date), 'UNK', 'JAN'), 'UN', '01'); run; I wonder if it's possible to make with PRXCHNAGE:   data want; set have; date_new=prxchange('s/(\d{4})((?(?=U)UNK|(\w{3})))((?(?=U)UN|(\d{2})))/$1 $3 $5/i', -1, AE.aestdat); run; But it fails to put JAN or 01, if the condition is met. Replace portions of the PRXCHANGE doesn't accept " | " as OR. Thank you in advance for your help and advice!       ... View more

Hi all! I'm trying to build a macro that will read the variables in given dataset based on PROC CONTENTS output. It should check if the variable has invalid variable (that are replaced with ? symbol and interrupt data processing). I have built following macro:   %macro cleanvar; proc contents data=mc1.customers out=varlist noprint; proc sql noprint; select name into :var1- from varlist where Type=2; quit; %do i=1 %to &sqlobs; data dataset; set mc1.customers; check&i=notalnum(trim(&&var&i)); run; proc sql noprint; select min (check&i) into :flag from dataset; quit; %if &flag=0 %then %do; data output; set mc1.customers; Clean_&&var&i=compress(&&var&i, " ", "f k"); run; %end; %end; %mend cleanvar; %cleanvar But it's obvious that this version re-writes the last Clean_var column. I have done another option, which I won't publish (it moves the DO loop in the DATA step) which does COMPRESS to all character variables (columns).  But in my opinion it should: - pull the list of variables, where they are type 2 - character; - check if at least one value in the variable is invalid with NOTALNUM (I think there should be SMALLEST in array, but I don't know how to do it); - and do COMPRESS only for those variables which contain invalid values.   I'm studying SAS using SAS VLE, so the dataset in MC1.CUSTOMERS, which I attach to the post. UPD: I have removed attached dataset to avoid misconceptions about the content of it. The file is taken from SAS VLE Macro 1 lesson at: https://vle.sas.com/pluginfile.php/783487/mod_scorm/content/23/coursefiles.zip folder data/customers SAS Data Set.   P.S. Strangely enough, in educational videos and in solutions, which are based on this dataset it doesn't contain invalid chars (those replaced with ?). Maybe it makes better sense to prevent these character to appear in first place, hence I will be glad to receive any kind of hint either how to change the macro or how to avoid the interruption in data processing. Thank you!     ... View more