%macro get_num_char(dst,v1,f1) ; data nc_&dst.; set &dst.; length &v1._num 8.; length &v1._char $20.; &v1._type = vtype(&v1.); if &v1._type='N' then do; &v1._num=&v1.; &v1._char=strip(put(&v1.,&f1.)); end; if &v1._type='C' then do; &v1._char=&v1.; &v1._num=input(&v1.,&f1.); end; run; %mend get_num_char; data test; a1 = '2025-12-05'; a2 = 45996; run; %get_num_char(test, a1, yymmdd10.); %get_num_char(test, a2, yymmdd10.);   The first code "%get_num_char(test, a1, yymmdd10.);" log reports an error "The format $YYMMDD was not found or could not be loaded.". Strangely, this error seems to be reported when Macro runs "&v1._char=strip(put(&v1.,&f1.));" when a1 is a character variable rather than a number. I think "if &v1._type='N' then do;" has prevented following code block from running so it shouldn't report an error. Can anyone tell me why this happened? ... View more

I just reinstalled windows system and SAS to my PC. However, I mistakenly chooes dektop as my installation path at the first time. Though I stop the installation step when I realise this, I can't change the path later for the window of assigning path doesn't show up again.  Could anyone help me to reassign the path of installation? ... View more

I try to understand the mechanism of SET statement in DATA step by following code: data c1; set sashelp.class; data c2; set c1; keep name; if _n_<=3; data c3; set c1; keep age; if _n_<=3; run; data c_out; put 'initial' @10 _all_; set c2 c3; put 'mid' @10 _all_; set c3 c2; put 'last' @10 _all_; run;   I find it hard to explain why the first and the third obs has missing value(name at obs 1 and age at obs 4).  Maybe it's caused by SAS reset all variables in PDV to missing value every time SET reads a new dataset and finishes reading a dataset? ... View more