Most likely this is an example of computers having limited numeric precision. See Machine Precision. Or perhaps two different programmers chose to handle the extreme case of SD=0 slightly differently.   It's nothing to worry about. I'm sure that in other cases, PROC UNIVARIATE and PROC TTEST will give matching results. ... View more

The macro in this thread will allow you add a prefix to each name and much more.   https://communities.sas.com/t5/SAS-Programming/Rename-all-variables-in-a-dataset-at-once/m-p/722622#M224093       ... View more

In most (all?) SAS interfaces that I know of you can create an abbreviation, so if you type the abbreviation and press ENTER, whatever text you designated to go with that abbreviation will be inserted. So for example, I have the abbreviation ohc (just those three letters) and when I type ohc and press ENTER the text ods html close; appears in my code.   So you could create the abbreviation %sf, for example.   You can create abbreviation/alias for any code you want. ... View more

Here is my SQL solution.   /* Create sample data for demonstration */ data have; call streaminit(27182818); array a[5] Q17_test Q17_new Q17_tmp Q17_abc Q17_314; do i=1 to 51; do _n_=1 to dim(a); a[_n_]=rand('integer',9); end; output; end; run; data _null_; set sashelp.vcolumn(where=(libname='WORK' and memname='HAVE' and upcase(name)=:'Q17_')) end=last; if _n_=1 then call execute('proc sql;'); call execute(cat('create table stats_',strip(name),' as select ',name,',count(*) as count from have group by ',name,';')); if last then call execute('quit;'); run; ... View more

Thank you. So in this case, does it mean that the group effect on death is reduced by approximately 24% due to the mediation of labvalue? ... View more

Use the headerout= option to save the servers response headers, and then you can log the information for examination and understanding on what to check for in terms of error handling. filename hdrout temp ; proc http ... headerout=hdrout ... run ; data _null_ ; infile hdrout ; input ; put _infile_ ; run ; filename hdrout ; ... View more

DUPLICATE THREAD  Reply at https://communities.sas.com/t5/SAS-Programming/need-to-calculate-ne-PY-and-ne-100py/m-p/970966#M377208   Update: the two threads have been merged into this thread you are reading right now. ... View more

DUPLICATE THREAD  Reply at https://communities.sas.com/t5/SAS-Programming/need-to-calculate-ne-PY-and-ne-100py/m-p/970966#M377208   Update: the two threads have been merged into this thread you are reading right now. ... View more

FYI, SAS Data Quality has name parsing algorithms that cater for national differences to do the splitting you want. Of course this is more geared to enterprise-wide solutions as opposed to individual requirements. ... View more

Yeah. You are right. I must forgot to check the LOG . Code has been updated . Thx! ... View more

@Edulearnx wrote: Hi Everyone, I’m importing an Excel file using PROC IMPORT in SAS 9.4, but the numeric columns with decimal values are being read as character or getting truncated. I’ve tried using DBSASLABEL=NONE and even increased the GUESSINGROWS, but the issue still happens. Some columns mix numbers and text, but others are just decimals and they still don’t import cleanly.   Is there a better way to control the column types during import, or is it better to switch to libname with XLSX?   Thanks! Thank you for all 👍 my issue got solved.. Regards, Rovmen  ... View more

The solution provided worked 100% for me. My task was to find the best candidate using the code and then look with my eyes too verify it found logical candidate  and if not then i do it manually using my eyes . ... View more

Thank you all! It was the "#byval1" feature that I was fishing for. I knew it existed, but I've never used it and I simply couldn't put together a search string that found it. All the other great code that you guys have provided is a bonus!   Tom ... View more

Check your option, if there are the following two options within Y axis:   proc sgplot data=class; vbar sex/response=w; yaxis type=linear integer ; run; ... View more

Interesting question. I like it.   data have; input TRAN_ID :$20. NET_PREMIUM :comma. NWP :comma. RSD :date. RED :date.; format RSD RED date9. NET_PREMIUM NWP comma.; cards; ICM_NOV_22_807600 22,937 8,257 19-Nov-22 18-Nov-25 ; data want; set have; new_rsd=RSD; do date=RSD to RED; if (month(date)=4 and day(date)=1) or date=RED then do; new_red=ifn(date=RED,date,date-1);output;new_rsd=date; end; end; drop date RSD RED; format new_rsd new_red date9.; run;     ... View more