topic Re: Format Variable in SAS Procedures

Format Variable

ren2010 — Mon, 11 Jan 2010 20:14:34 GMT

Hi,

I am trying to APPEND two datasets,say A(this is Base) and B
In dataset A i have a variable empid length 5 and format 12
In dataset B i have a variable empid length 5 and format 20

When i tried to append the B to A,i got a warning that the Format of ID in base and DATA dataset is different,how can i change th format of empid in datset B,so that i can append without any warnings.

You help will be appreciated.

Thanks,
Ren

Re: Format Variable

sbb — Mon, 11 Jan 2010 22:24:12 GMT

You can use a FORMAT statement in a DATA step, for one approach.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument:

change output format sas variable site:sas.com

Re: Format Variable

ren2010 — Mon, 11 Jan 2010 23:06:50 GMT

Thanks

Re: Format Variable

data_null__ — Tue, 12 Jan 2010 12:25:45 GMT

Why not just use a format statement with PROC APPEND.
[pre]
format _all_;
[/pre]
to cover all bases so to speak.