Proc append and first dataset

[GN0001]

Hello team,
I have proc append;
Proc append base=import_data data=import_ data_in force;
Run;
Do we need to have first dataset in sas or in our directories to be able to append second dataset to the first dataset?

Thanks for your response!
🙏🙏🙏 blue & blue

[PaigeMiller · Accepted solution]

If IMPORT_DATA does not exist, then PROC APPEND goes ahead and appends IMPORT_DATA_IN to an empty data set; essentially the result in IMPORT_DATA_IN

[ballardw]

Using the Force option and data set names like Import_data_in (note that your "import_ data_in" has a space in the name and will throw an error) makes me think you may be relying on Proc Import for the data read step. If so, be prepared for lots of warning about mismatched variable lengths and truncated data, warning of variables not in the base data so variables will be lost on append and possible even failure if same named variables are of different types than in an existing base data set.

[GN0001]

Hello,

Here, when I came to type in, I inserted a space, there is no space in the original code.

blue&blue

[ballardw]

---

@GN0001 wrote:

Hello,

Here, when I came to type in, I inserted a space, there is no space in the original code.

blue&blue

---

Easy solution: Copy text from editor or Log. Open text box with the </> icon. Paste text.

No fuss, no muss and quicker than retyping.