03-22-2017 08:17 AM
i counted the week using the week function but when using week formats to display the week no and year then its giving me 1960w00.
can any one suggest me how to derive the count of week of the year and display it with its year using the Enterprise guide.
03-22-2017 09:00 AM - edited 03-22-2017 09:00 AM
The week formats expect SAS date values as input (days from 1960-01-01). Therefore a simple week number will give you a result in the beginning of 1960.
Use the week format directly on your SAS date value.