topic Copy and paste the similar data in SAS Programming

Copy and paste the similar data

abdulla — Mon, 11 Feb 2019 22:27:34 GMT

permno	rtrn	HML	SMB
123	0.01	0.02	1.2
123	0.014	1.4	3.5
123	0.008	2.1	0.08
354	0.023	3.4	1.69
354	-0.25	0.006	2.14
354	0.14	1.21	3.54

Hi,

I want to copy the exact similar data to the cells below. I have 1773 observations. So I have to copy the above data to 1173 obs below. It is now 6 obs. So I need to copy down the same for 1771 obs. Please help.

Re: Copy and paste the similar data

Reeza — Mon, 11 Feb 2019 23:02:09 GMT

FYI - I've moved both your recent posts to the programming forum, rather than 'community matters'.

Re: Copy and paste the similar data

abdulla — Mon, 11 Feb 2019 23:07:02 GMT

Ok. Thank you. So, I have to post this in the programming forum, right?

Re: Copy and paste the similar data

Reeza — Mon, 11 Feb 2019 23:20:34 GMT

Yes, the community matters forum is for issues relating to the community/forum itself, rather than programming issues. This appears to be a programming question.

Re: Copy and paste the similar data

andreas_lds — Tue, 12 Feb 2019 07:18:26 GMT

Can you post what you expect as result using the data you posted?

If you want to duplicate the whole dataset you can try:

/* create a backup, so that the original dataset is not overwritten by proc append */
data work.class;
   set sashelp.class;
run;

proc append base=work.class new=work.class;
run;