date format

[fatemeh]

Hello all.I want to use qtr function but the date d that is shown in result is 01/01/1960 which is different from the date that i want as i put in my sas code.Any help is appreciated to correct my mistake.

data nn;
d = '05/19/2016' ;
p     = qtr   (d);
format  d  ddmmyy10. ;

run;

[PeterClemmensen]

data nn;
   d='19may2016'd;
   p=qtr(d);
   format d ddmmyy10.;
run;

 QTR function requires a numeric variable, and in your code d is a character variable. Specify it as a date constant using the date9 format as "19may2016"d with the trailing d specifying that it is a date constant.

[Kurt_Bremser]

You tried a wrong method for spelling out a SAS date literal. The correct method is this:

d = '19may2016'd;

[Reeza · Accepted solution]

SAS date values need to be specified in DATE9 format which is ddMONYY such as 16May2016

And when specifying a date, you need to include a d after the quotation marks to indicate the difference between a date and just a plain string. 

Note that you can also just format your date as a quarter variable, I created a variable Z, which is identical to d but formatted as a quarter.

data nn;
d = "19May2016"d;
p     = qtr   (d);

z = d;
format  d  ddmmyy10.  z qtr.;
run;