DATA Step, Macro, Functions and more

Input Function - Error

Reply
User
Posts: 1

Input Function - Error

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?

 

Trusted Advisor
Posts: 1,228

Re: Input Function - Error

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;

Respected Advisor
Posts: 4,173

Re: Input Function - Error

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;

Capture.PNG

Ask a Question
Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 3 in conversation