BookmarkSubscribeRSS Feed
ren2010
Obsidian | Level 7
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
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
ren2010
Obsidian | Level 7
Thanks
data_null__
Jade | Level 19
Why not just use a format statement with PROC APPEND.
[pre]
format _all_;
[/pre]
to cover all bases so to speak.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 931 views
  • 0 likes
  • 3 in conversation