Thanks Guys should of double checked the fields properly. thanks again. ... View more

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22 23 GOPTIONS ACCESSIBLE; 24 data want; 25 set atwd.atwd_despatches;; 26 date=input(date_of_despatch_of_good, yymmdd10.); 27 format date date9.; 28 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 26:13 NOTE: Variable date_of_despatch_of_good is uninitialized. NOTE: There were 558694 observations read from the data set ATWD.ATWD_DESPATCHES. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-09-06T11:31:26,527+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 558694| _DISARM| 28483584| _DISARM| 12| _DISARM| 21| _DISARM| 178712| _DISARM| 23761272| _DISARM| 1.510000| _DISARM| 1.501806| _DISARM| 1978079485.025541| _DISARM| 1978079486.527347| _DISARM| 0.890000| _DISARM| | _ENDDISARM NOTE: The data set WORK.WANT has 558694 observations and 17 variables. NOTE: Compressing data set WORK.WANT decreased size by 80.98 percent. Compressed is 1398 pages; un-compressed would require 7352 pages. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2022-09-06T11:31:26,567+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 558694| _DISARM| 28483584| _DISARM| 12| _DISARM| 21| _DISARM| 178968| _DISARM| 23761536| _DISARM| 1.520000| _DISARM| 1.537450| _DISARM| 1978079485.030051| _DISARM| 1978079486.567501| _DISARM| 0.880000| _DISARM| | _ENDDISARM NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2022-09-06T11:31:26,567+01:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 1104273408| _DISARM| 28483584| _DISARM| 12| _DISARM| 21| _DISARM| 178976| _DISARM| 23761536| _DISARM| 1.530000| _DISARM| 1.551203| _DISARM| 1978079485.016803| _DISARM| 1978079486.568006| _DISARM| 0.890000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 1.55 seconds cpu time 1.53 seconds 29 30 GOPTIONS NOACCESSIBLE; 31 %LET _CLIENTTASKLABEL=; 32 %LET _CLIENTPROCESSFLOWNAME=; 33 %LET _CLIENTPROJECTPATH=; 34 %LET _CLIENTPROJECTNAME=; 2 The SAS System 09:28 Tuesday, September 6, 2022 35 %LET _SASPROGRAMFILE=; 36 37 ;*';*";*/;quit;run; 38 ODS _ALL_ CLOSE; 39 40 41 QUIT; RUN; 42 the example you posted Paige worked fine.  but when I try and use it on the dataset it just returns blanks. I have attached the log. thanks   ... View more

so the original field is character field. i need to convert it to numeric date field.  so looking at the columns Name Date_of_despatch Type Character length 8 data in the field - 20060614   i hope that make sense.   so i have done the below, data want; set have; date=input(date_of_despatch, yymmdd10.); format date date9.; run;   when I run it I'm getting back blank fields -    ... View more

so the original field is character field. i need to convert it to numeric date field.    i hope that make sense   ... View more

Thanks I will have a go in the morning and let you know how I get on. Cheers ... View more

Thanks Tom, I will have a go in the morning and let you know how I get my on. Cheers ... View more