data split_names; input name $25; datalines; JohnDoe SrinivasPavan KishoreKumar ChandrasekaRao ; run; fHi Experts, In the above code i want split names every second capital letter  without regex solution please   output ________ John    Doe Srinivas Pavan Kishore Kumar Chandrasekar Rao   ... View more

Hi  Good morning sas community How to get numeric & character missing's variable names and respective datasets names in a Library  ... View more

data sorted_string; length Str $50 ; Str = "ASDFKBSDEFWKSR"; run; Sorting last N letters in str  variable ... View more

What are disadvantages of Proc sort precedure give some points which is best method for sorting data and delete duplicates data even if huge data and small data ... View more

%macro create_empty_datasets; %do i = 1 %to 100; data lib1.ds_&i; run; %end; %mend; %create_empty_datasets; proc sql; create table s as select libname, memname,memtype from dictionary.tables where libname = 'LIB1' /* Change to your library name if different */ and nobs = 0 /* Filters datasets with zero observations */; quit; Here I created 100 datasets  so how to identify empty datasets ,datasetnames ,observartions count ,variable names info in a Library ... View more

data _null_; set sashelp.class end=last ; /* Check if the observation is the 1st, 15th, 6th, or the last observation */ if _n_ in (1, 15, 6) or last then do; /* Use PUT with column positioning correctly */ put @15 name $10. @30 sex $1. @40 age 3. @50 height 5.1 @60 weight 5.1 @70 ; end; run; Hi Experts, In the above code i want get variable names also  in log window with data when using _NULL_ dataset  ... View more