topic Re: How to create table by calling another table data in SAS Programming

How to create table by calling another table data

sathwik — Tue, 11 Sep 2018 08:36:22 GMT

data Examplex;
	input Name $ 9-19 Designee $ 20-32  Department $;
	datalines;
		Madhu      Jr_Associate  QA
		Sathwik    Jr_Associate  PB
		Mohan      Manager       PB
		Raja       Manager       QA
		Kiran      Manager       BR
		Sainath    Manager       CL
		;
run;

proc print data = Examplex;
run;

I had table which is given in Photo and Program. By using this table i want create new table by taking two observations in that given table.

Re: How to create table by calling another table data

RW9 — Tue, 11 Sep 2018 08:39:43 GMT

Do stop putting datalines indented. SAS reads data from position 1.

For this "By using this table i want create new table by taking two observations in that given table. " - you will need to clarify, do you want the first two observations, some random two?

Re: How to create table by calling another table data

sathwik — Tue, 11 Sep 2018 08:43:10 GMT

some random two observations

Re: How to create table by calling another table data

PeterClemmensen — Tue, 11 Sep 2018 09:14:43 GMT

proc surveyselect data=Examplex out=want noprint
     seed=1234 method=srs
     sampsize=2;
run;

Re: How to create table by calling another table data

sathwik — Tue, 11 Sep 2018 09:04:43 GMT

When i need particular 2 and 5 observations at that time which code we need

Re: How to create table by calling another table data

RW9 — Tue, 11 Sep 2018 09:11:35 GMT

Which is it?

"some random two observations"

"When i need particular 2 and 5 observations"?

If you know the two observations then you where clause it for that:

data want;
  set have;
  if _n_ in (2,5);
run;
proc print data=want;
run;

For positional, or you could change the where to be the values from those rows.

Re: How to create table by calling another table data

sathwik — Tue, 11 Sep 2018 09:32:49 GMT

Thank you
sathwik