topic Re: How to add data in randomly in SAS Programming

How to add data in randomly

sathwik — Tue, 18 Sep 2018 07:02:05 GMT

I had some random data in that data i want to add some data in between that already existed data by using under EmpID.

data Examplex;
	input EmpID $ Name $ Designee $ 27-39 Department $;
	datalines;
		101		Madhu     Jr Associate    QA
		103		Sathwik   Jr Associate    PB
		104		Mohan     Manager         PB
		106		Raja      Manager         QA
		107		Kiran     Manager         BR
		108		Sainath   Manager         CL
		;
run;

proc print data = Examplex;
run;

We want to add data which is given below

102		Satya	Sr Associate	PB
105		Sai		Trinee			BR
109		Surya	Manager			CL

I'm expecting this out put.

thank you

Sathwik

Re: How to add data in randomly

gamotte — Tue, 18 Sep 2018 08:32:25 GMT

Hello,

data Examplex;
	input EmpID $ Name $ Designee $ 27-39 Department $;
	datalines;
		101		Madhu     Jr Associate    QA
		103		Sathwik   Jr Associate    PB
		104		Mohan     Manager         PB
		106		Raja      Manager         QA
		107		Kiran     Manager         BR
		108		Sainath   Manager         CL
		;
run;

data new;
	input EmpID $ Name $ Designee $ 27-39 Department $;
	datalines;
        102     Satya     Sr Associate    PB
        105     Sai       Trinee          BR
        109     Surya     Manager         CL
        ;
run;

data want;
    merge Examplex new;
    by EmpID;
run;

Re: How to add data in randomly

sathwik — Tue, 18 Sep 2018 09:20:38 GMT

Suppose without any "Emp ID" how to put data at particular possession

Re: How to add data in randomly

gamotte — Tue, 18 Sep 2018 09:27:20 GMT

If by position, you mean row number, you can use _N_ to get the currently processed row index

and, when the condition is met, read data from your alternate dataset :

data want;
    set Examplex;
    output;

    if _N_=5 then do until(eof);
        set new end=eof;
        output;
    end;
run;

Re: How to add data in randomly

sathwik — Tue, 18 Sep 2018 09:36:08 GMT

Thank you
Sathwik