topic Re: "YYQ5." informat to read year-quarter date in New SAS User

"YYQ5." informat to read year-quarter date

changxuosu — Fri, 12 Apr 2019 14:50:38 GMT

Hi Sas Community!

I tried to use the "YYQ5." informat to read year-quarter date, but cant get this quite right. Can any one catch what's going wrong with the following code?

Thank you!!! Have a nice weekend.

data temp;

input date YYQ5. prime 4.2;

datalines;

18Q01 3.45

18Q02 3.44

18Q03 3.23

18Q04 1.23

19Q01 2.12

19Q02 3.23

19Q03 1.42

;

run;

Re: "YYQ5." informat to read year-quarter date

ballardw — Fri, 12 Apr 2019 14:55:47 GMT

What makes you think there is a problem. You did not assign any format to DATE so the value displayed is the number of days since 1JAn1960.

The informat will assign a date value of the first day of the calendar quarter if you use a date format that will display day and month such as:

data temp;
input date YYQ5. prime 4.2;
format date date9.;
datalines;
18Q01 3.45
18Q02 3.44
18Q03 3.23
18Q04 1.23
19Q01 2.12
19Q02 3.23
19Q03 1.42
;
run;

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.

Re: "YYQ5." informat to read year-quarter date

VDD — Fri, 12 Apr 2019 14:56:00 GMT

data temp;

input date yyq5. prime 4.2;
datalines;
18Q01 3.45
18Q02 3.44
18Q03 3.23
18Q04 1.23
19Q01 2.12
19Q02 3.23
19Q03 1.42
;
data got;
	set temp;
	new = date;
	format new yyq5.;
run;

Re: "YYQ5." informat to read year-quarter date

changxuosu — Fri, 12 Apr 2019 15:49:10 GMT

thank you so much, now I understand the difference btw formats and informats.... You're always very helpful.

Re: "YYQ5." informat to read year-quarter date

changxuosu — Fri, 12 Apr 2019 15:49:27 GMT

thank you so much, it's really helpful.