creating dummy dataset to create a structure

yashraj89 — Sun, 28 Apr 2019 21:33:46 GMT

I am trying to create a dummy dataset based on the number of cycles I have in the dataset. Right now I am writing sas code to create each observation individually. I want the repetition to automate rather than writing the whole code. In the below piece of code i am creating the same 8 records for all the cycles. I want to create these records for 50 cycles but i dont want to write 400 lines of sas code.

data pcn;
length pktpt_std $30 visit $30 ;
do cyc =2; pktpt_std='PRE-DOSE'; visit='C2 D1'; output; end;
do cyc =2; pktpt_std='5 MIN POST'; visit='C2 D1'; output; end;
do cyc =2; pktpt_std='PRE-DOSE'; visit='C2 D8'; output; end;
do cyc =2; pktpt_std='5 MIN POST'; visit='C2 D8'; output; end;
do cyc =2; pktpt_std='PRE-DOSE'; visit='C2 D15'; output; end;
do cyc =2; pktpt_std='5 MIN POST'; visit='C2 D15'; output; end;
do cyc =2; pktpt_std='PRE-DOSE'; visit='C2 D22'; output; end;
do cyc =2; pktpt_std='5 MIN POST'; visit='C2 D22'; output; end;
do cyc =3; pktpt_std='PRE-DOSE'; visit='C3 D1'; output; end;
do cyc =3; pktpt_std='5 MIN POST'; visit='C3 D1'; output; end;
do cyc =3; pktpt_std='PRE-DOSE'; visit='C3 D8'; output; end;
do cyc =3; pktpt_std='5 MIN POST'; visit='C3 D8'; output; end;
do cyc =3; pktpt_std='PRE-DOSE'; visit='C3 D15'; output; end;
do cyc =3; pktpt_std='5 MIN POST'; visit='C3 D15'; output; end;
do cyc =3; pktpt_std='PRE-DOSE'; visit='C3 D22'; output; end;
do cyc =3; pktpt_std='5 MIN POST'; visit='C3 D22'; output; end;

run;

thanks

Re: creating dummy dataset to create a structure

PaigeMiller — Sun, 28 Apr 2019 21:51:41 GMT

data want;
	length pktpt_std $ 10 vist $ 10;
	do cyc=1 to 50;
		do num=1, 1, 8, 8, 15, 15, 22, 22;
			do pktpt_std='PRE-DOSE', '5 MIN POST';
				visit=cats('C', cyc)||' '||cats('D', num);
				output;
			end;
		end;
	end;
run;

Re: creating dummy dataset to create a structure

yashraj89 — Sun, 28 Apr 2019 22:32:32 GMT

Thanks Paige Miller. It worked like gem.

Re: creating dummy dataset to create a structure

novinosrin — Sun, 28 Apr 2019 23:33:38 GMT

Hi @yashraj89 Requesting you to please mark the solution as answered and close the thread

topic Re: creating dummy dataset to create a structure in SAS Programming

creating dummy dataset to create a structure

Re: creating dummy dataset to create a structure

Re: creating dummy dataset to create a structure

Re: creating dummy dataset to create a structure