topic Re: Getting _character after transposing in SAS Procedures

Getting _character after transposing

excelsas — Thu, 09 Jun 2011 12:18:15 GMT

Hi,

I am using proc transpose to transpose data by month.
Month is in date9. format.
After transposing I am getting _before date.
Ex _01jun2009.
How can I remove that?

Thanks ,

Re: Getting _character after transposing

data_null__ — Thu, 09 Jun 2011 12:43:54 GMT

V7 SAS Names cannot begin with digits so PROC TRANSPOSE adds the underscore.

If you use the IDLABEL statement you can create variable labels which are not bound by the rules of SAS names.

Then when you display the columns use the Labels instead of the Names.

There are other options but I would stick with V7 SAS names.

Re: Getting _character after transposing

SPR — Thu, 09 Jun 2011 18:17:51 GMT

Hello ExcelSAS,

You could also use format month MONYY7.; in your proc TRANSPOSE, then you should get Jun2009 instead of 01Jun2009 like in following example:
[pre]
data i;
d="01Jun2009"d; v=1; output;
d="01Jul2009"d; v=2; output;
format d date9.;
run;
proc transpose data=i out=t;
var v;
id d;
format d MONYY7.;
run;
[/pre]
Sincerely,
SPR

Re: Getting _character after transposing

Ksharp — Fri, 10 Jun 2011 01:56:19 GMT

Add a system option before your code.

[pre]

options validvarname=any;
[/pre]

Ksharp