Hello, I would like to change the variables which are YYMMDD to MMDDYY.    I have the codes below.  When I tried to change one by one, everything is fine.  However, after I used create macro and ran, I found out all the YYMMDD change to 01/01/1960.   I have no idea why this happened.   Please help, thank you.   BTW, the test is only the sample dataset.   I have more variables like 'YYMMDD'.   Also, I am not good at create date sample dataset.  I think the code for creating the test is not very correct.   If you could help me fix it too.  That would be great.   data test; format scrdate YYMMDD10. scrAdmitdate YYMMDD10.; input Hstatus $1 scrdate : yymmdd10. scrAdmitdate :yymmdd10.; datalines; 1 2016-12-01 2016-12-01 2 2016-12-03 2016-12-03 3 2016-12-10 2016-12-12 4 2016-12-06 2016-12-07 ; run; proc contents data=test out=test_cont noprint; run; data new_dates; set test_cont; if format in ('YYMMDD'); run; proc sql noprint; select name into :numdvar separated by ' ' from new_dates; quit; %put &numdvar; data test_newdate; set test; array bb &numdvar; do over bb; bb=Datepart(bb); end; informat &numdvar yymmdd10.; format &numdvar mmddyy10.; run;   ... View more

Hi Experts,   I have been using SAS for a few years.   Are there any keyboard shortcuts for SAS users?  For example, Crtl+C=copy, Crtl+V=Paste, Ctrl+X=Cut, something like when I use the above in Windows.   Any literature or weblink would be helpful...    I know Ctrl+F=Find, Ctril+/=disable the highligt codes are some of keyboard shortcuts in SAS.  Anything else?   Thank you! ... View more

Hello,   I have a sample test dataset.  I would like to put 0 in front of the digit shown the result column.   data test; infile datalines dsd; input Name : $300. Result : $200. ; datalines; 01, 0001 4000, 4000, 78790, 78790, 2, 0002, 111, 0111 ; run; ... View more

Hello,   I would like to remove the 'CAR|ID|IL|PA|KK' in the ID column.  The result is shown in the 'Result' column.   Please advice.   data TEST; infile datalines dsd; input ID : $300. Result : $200.; datalines; CAR ID MA, MA ILH, H PAUL VN, UL VN KKK GGGG, K GGGG Card ID BMA, d BMA Care ID FMA, e FMA ; run;   ... View more

Hello,   The prxmatch program below is searching the created macro list as 'CAR|IL|VN|KK'.   However, I would like the search be more restricted.   Instead of containing the ''CAR|IL|VN|KK'' string in the text,  I like to match 100% these two letters.   Please advice how to change this prxmatch codes.  Thank you.   if prxmatch ("/&Jurisdiction_list./i",id) then TempID=id; The following sample data set is data datain; infile datalines dsd; input ID : $300. ; datalines; CAR ID MA, ILH, PAUL VN, KKK GGGG, Card ID BMA, Care ID FMA, ; run;   The final result I am looking for is only at the 1st and 3rd row. ... View more

Hello,   I would like to exclude the 'SUB' and 'NCV' in the PRXMATCH command.  I have the code below.   I found the texts are still in the result TEMPID.  Please help.  Thank you.   if prxmatch ('/000|^SUB|^NCV/i',id) then TempID=id; ... View more

Hello,   I created a macro list below.   proc sql noprint; select trim(State_Abbr) into : Jurisdiction_list separated by '|' from States; quit; %put &Jurisdiction_list;   and the result is shown below.   AL|AK|AZ|AR|CA|CO|CT|DE|FL|GA   Then I run a data step in PRXMATCH,  I found the &Jurisdiction_list. was NOT able to recognize.  Any idea why?   data want; SET test; if prxmatch ('/&Jurisdiction_list./i',ID) then TempID=ID; run; ... View more