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

using below dataset and get below output data sc; input group $ id ; datalines; A 1 A 1 A 0 A 1 A 1 B 2 B 0 B 2 B 2 C 3 C 0 C 3 C 3 ; run; /*output*/ Name id A 1 A 1 A 0 A 0 A 0 B 2 B 0 B 0 B 0 C 3 C 0 C 0 C 0 ... View more

Input values ; Cards 12 33 56 77 99; run Q.) swap 33 and 77 values remaining keep same Output 12 77 56 33 99 ... View more