What is the issue/error you are getting? ... View more

May be those variable's datatype is different across all the datasets. Convert those variable's datatypes as same as variables in a1_final dataset in set statement. ... View more

obs dob date agey agem agew aged 1 12/22/1994 03/11/2016 22 255 1107 7750 2 12/05/1990 03/11/2016 26 303 1318 9228 3 12/21/1978 03/11/2016 38 447 1942 13595 4 12/27/1977 03/11/2016 39 459 1993 13954 ... View more

dob date agey agem agew aged 1 12/22/1994 03/11/2016 22 255 1107 7750 2 12/05/1990 03/11/2016 26 303 1318 9228 3 12/21/1978 03/11/2016 38 447 1942 13595 4 12/27/1977 03/11/2016 39 459 1993 13954 I just checked in SAS the above result you will get. ... View more

please share your program ... View more

If you have any decimal values use round(age) or rounde(age) to get integer values. ... View more

No need to use format in your program just use the given function statements.       ... View more

Use set statement for your created dataset.   data test1; set test; format date mmddyy10.; date=today(); /*Get today's date*/ agey=intck('year',dob,date); /*Get age in years*/ agem=intck('month',dob,date); /*Get age in months*/ agew=intck('week',dob,date); /*Get age in weeks*/ aged=intck('days',dob,date); /*Get age in days*/ run; ... View more

Hi,   Please use below code for your requirement. INTCK() function will not give values in decimals.   data test; input dob mmddyy10.; format dob mmddyy10.; cards; 12/22/1994 12/05/1990 12/21/1978 12/27/1977 ; run;   data test1; set test; format date mmddyy10.; date=today(); /*Get today's date*/ agey=intck('year',dob,date); /*Get age in years*/ agem=intck('month',dob,date); /*Get age in months*/ agew=intck('week',dob,date); /*Get age in weeks*/ aged=intck('days',dob,date); /*Get age in days*/ run; ... View more

True, Thats also might be an option. ... View more

Use below Contents procedure to get Column Names, Datatype, Size etc from SAS file by giving library name. Repeat this or write a macro to get all the librarie's SAS files info and collate to one single SAS file.   proc contents data=&inlib..&indata out=contdata; run;   Export sas dataset contdata to an excel file using proc export. ... View more