topic Report in SAS Procedures

Report

robertrao — Wed, 29 May 2013 18:55:47 GMT

I have year variable under which there are many different years

I want to do a report on this dataset and for each year seperately

since year is numeric i cannot use it in the where statement inside the PROC REPORT

when i convert to charecter in the datastep and then use it in the where statement inside the report it says :there were 0 observations where year is 2011

Could you tell me where i went wrong??

YEAR

2011

2010

2012

Thanks

Re: Report

robertrao — Wed, 29 May 2013 19:00:55 GMT

OK I found my mistake...

There were some leading spaces

Could someone help me do all the three things together while extracting year from the date variable????

year=year(date);

year1=put(year,best.);

year2=strip(year1);

Thanks

Re: Report

Haikuo — Wed, 29 May 2013 19:09:18 GMT

year=put(year(date),4.);

Re: Report

robertrao — Wed, 29 May 2013 19:26:42 GMT

Hi,

Instead of the 4. if i used best. I am getting leading spaces. Why is that? and could you also show me how to strip in the same line

Is the below one right ??

year=strip(put(year(date),4.));

Thanks

Re: Report

Astounding — Wed, 29 May 2013 19:41:01 GMT

You're making your life way too complicated. Of course you can use a WHERE statement on a numeric variable:

where numvar=2011;

Just don't use quotes when referring to a numeric value.