topic Re: Proc append and first dataset in SAS Programming

Proc append and first dataset

GN0001 — Wed, 11 May 2022 18:26:33 GMT

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

Re: Proc append and first dataset

PaigeMiller — Wed, 11 May 2022 18:34:46 GMT

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

Re: Proc append and first dataset

ballardw — Mon, 16 May 2022 17:21:24 GMT

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.

Re: Proc append and first dataset

GN0001 — Mon, 16 May 2022 17:04:16 GMT

Hello,

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

blue&blue

Re: Proc append and first dataset

ballardw — Mon, 16 May 2022 17:23:12 GMT

@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.