topic Input Function - Error in SAS Programming

Input Function - Error

cody — Sat, 17 Oct 2015 12:51:31 GMT

data TEST;
	set DATASET;
	monthIn = scan(Date,1);
	month = input(monthIn,4.);
	day = input(scan(Date,2),4.);
	year = input(scan(Date,3),4.);
run;

I have dates like Date=9/1/2012

and my code returns monthIn=9 month=. day=1 year=2012.

Why does month not return month=9?

Re: Input Function - Error

stat_sas — Sat, 17 Oct 2015 14:39:39 GMT

Try this.

data TEST;
input date $;
monthIn = scan(Date,1);
month = input(monthIn,4.);
day = input(scan(Date,2),4.);
year = input(scan(Date,3),4.);
datalines;
9/1/2012
;
run;

proc print data=test;
run;

Re: Input Function - Error

Patrick — Sat, 17 Oct 2015 22:06:21 GMT

It's normally better to convert a string representing a date into an actual SAS date value. Once you've got a SAS date value you can format however you want to with either OOTB formats or your own picture format.

proc format;
  picture mdy_nums
    low-high ='month=%m Day=%d Year=%Y' (datatype=date)
    ;
quit;
 

data TEST;
  input date $;
  sas_date=input(date,mmddyy10.);
  format sas_date mdy_nums.;

  month=month(sas_date);
  day=day(sas_date);
  year=year(sas_date);

  datalines;
9/1/2012
;
run;