Hello,   I would like to create a macro list from 0001 to 1000 with '|' separation.   Please advice.  Thanks. ... View more

Hello,   I would like to remove all the numeric but keep one space between the text as I show in the result column.   Please help.  Thank you.   data datain9; infile datalines dsd; input Name : $300. Result : $ 100. ; datalines; Car_ID_6666, Car ID, Home_000_9463_Address, Home Address, 30890_Zip_Code, Zip Code, ; run; ... View more

Hello,   I would like to extract 4 continuous numbers (not including 000)  from the Name in the dataset.  I list the result I am looking for in the dataset too.   data datain1; infile datalines dsd; input Name : $300. Result : $100. ; datalines; __5648_, 5648 0009463, 9463 000_4721, 4721 4721__, 4721 __0065_, 0065 9463__1, 9463 __5648__000, 5648 _5648_77, 5648 ; run; Is there a way to appoach this?   Thank you.     ... View more

Hello,   How to select the people less than 5 days in the 'Birthdate' column?  For example, 02/25/2020 <= 5 days. ... View more

Hello,   I would like to remove 000 in the front and two letters in the end in the TempID?  Thanks.   data datain; format TempID $ 200. ; input TempID & ; cards; 5648MA 0009463 0004721 6325IL 0065VN 0435KK ; run; ... View more

Hi all,   I would like to do the following searching in my sample test dataset.   1.  Searching 4 numbers + 2 letters afterwards 2.  Searching any numbers starting with 000.    The result I am looking for is in the Find column.   data Text; infile datalines dsd; input TempID : $15. TempID_1 : $15. TempID_2 : $15. TempID_3 : $15. TempID_4 : $15. Find : $10. ; datalines; 1156 IL, 89__46, 88--53, , , 1156IL 1487-KM, __8956, _78-52__, Car 4632, , 1487KM 000-597, -1596_, 4113, , , 000597 C_ _-1156, 4986__, 0_0-0_8, , , 0008 208, 8M _ O23, , , Car ID 7788 GH, 7788GH HB_21156--, 89 66, 885 - 2, 5 5 5 9, 0056, ; ... View more

Hello,   An error massage is shown in my coding.   Please correct, thanks.   198 DATA Text; 199 set Text; 200 IF result ^= '' and Source__Type in ('Nasopharyngeal swab' or 'Throat                                                                                                       --- 79 388 200 76 200! (Oropharyngeal) swab' or 'Oral swab'); ERROR 79-322: Expecting a ). ERROR 388-185: Expecting an arithmetic operator. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 201 run;   DATA want; set text; if Result_t ^= '' and Source__Type_ in ('Nasopharyngeal swab' or 'Throat (Oropharyngeal) swab'); run; ... View more