proc format could be the way to get the expected result to create the format val as the requirement proc format fmtlib;        value val .='Missing'               low--9='<=-9'               -9<--8= '> -9 to <=-8'               -8<--1='> -8 to <=-1'               -1<-<0='> -1 to < 0'                 0='0'                 0<-41='<=41'                 41<-392='1-392'                 392<-high='> 392'; run; used the dataset have without creating the new dataset want as created earlier. and used the format val proc freq data=have; tables income/list missing; format     Income  val.; run; Thanks, Jagadish ... View more

hope the below code meets your criteria data t; input group pt $; datalines; 1 a 1 b 2 u 2 r 3 t 4 q 6 c ; quit; /*create a dummy dataset with groups and give the values as 0*/ data dummy;     do group=1 to 6;     count=0;     output;     end; run; proc sql; /*    get the distinct count of the pt in each group*/     create table test as select count(distinct pt) as count ,group from t group by group; /*merge the counts of the pt in each group with the dummy dataset which has all the groups*/     create table test2 as select coalesce(a.count,b.count) as count,b.group from test as a right join dummy as b on a.group=b.group; /*generate the macro for each group by the below code*/     select count into: n1-:n&sysmaxlong from test2; quit; %put _user_; Thanks, Jagadish ... View more

I think the problem is with the macro variables not resolving at all. I tried to give some values to the macro variables and it worked well. Please check the code below 333  %let row1=1; 334  %let row2=2; 335  %let row3=3; 336  %let row4=4; 337  %let row5=5; 338 339  proc sql; 340 341     create table Table1 342 343         (Account char(50) label="Transaction File", 344 345          Count num label="Number of Records"); NOTE: Table WORK.TABLE1 created, with 0 rows and 2 columns. 346 NOTE: PROCEDURE SQL used (Total process time):       real time           0.02 seconds       cpu time            0.03 seconds 347  proc sql; 348 349      insert into Table1 350 351      set Account='Total Number of Records submitted', count=&row1. 352 353      set Account='Number of facility', count=&row2. 354 355      set Account='Number of Primary Account', count=&row3. 356 357      set Account='Number of Secondary Financial Account', count=&row4. 358 359      set Account='Number of Secondary Statistical Account', count=&row5.; NOTE: 5 rows were inserted into WORK.TABLE1. 360 361  quit; NOTE: PROCEDURE SQL used (Total process time):       real time           0.01 seconds       cpu time            0.00 seconds Thanks, Jagadish ... View more

I used the function datejul() which converts julian date to a sas date value and then used the format yymmdd10.  Need to check if there is format for yyddmm. Else we need to separate the month and day from the date and then concatenate them into yyddmm. if there is any other way , would like to know it data t; t=2013231; t2=2013224; t_=DATEJUL(t); t2_=DATEJUL(t2); format t_ t2_  yymmdd10.;   run; Thanks, Jagadish ... View more