topic Re: Datasets in SAS Programming

Datasets

BrahmanandaRao — Sat, 09 Mar 2019 14:10:12 GMT

I want 19 datasets using sashelp.class

I mean each observation as one dataset

And also how to find no of obs in unknown dataset

Thank u

Anand

Re: Datasets

VDD — Sat, 09 Mar 2019 14:27:01 GMT

To get the number of obs in a SAS dataset use Proc Contents.

proc contents data=sashelp.class;
run;

Re: Datasets

BrahmanandaRao — Sat, 09 Mar 2019 14:28:50 GMT

Another way

Usuing

Re: Datasets

PeterClemmensen — Sat, 09 Mar 2019 14:38:54 GMT

1) Why on earth do you want a separate data set for each observation?

2) There are several ways to do this. Here are two..

data _null_;
   if 0 then set sashelp.class nobs=nobs;
   call symputx('nobs', nobs);
run;

%put &nobs.;

data _null_;
   dsid=open('sashelp.class');
   nobs=attrn(dsid, 'nobs');
   rc=close(dsid);
   put nobs;
run;

Re: Datasets

BrahmanandaRao — Sat, 09 Mar 2019 14:38:42 GMT

Usung macro s do loop

Re: Datasets

Kurt_Bremser — Sat, 09 Mar 2019 14:39:16 GMT

Retrieve the number of observations from dictionary.tables (with SQL).

Splitting datasets is not helpful in >90 % of cases, and with a small dataset like sashelp.class it's plain stupidity.

Re: Datasets

PeterClemmensen — Sat, 09 Mar 2019 14:39:29 GMT

What do you mean? You have to be more specific than this.

Re: Datasets

BrahmanandaRao — Sat, 09 Mar 2019 14:46:46 GMT

Ok thank you

Bu i want split 19 datasets

Each obs as one dataset

Using sashelp.class library

Re: Datasets

VDD — Sat, 09 Mar 2019 14:47:36 GMT

splitting a datasets would be more for a process of bills payed and bills not payed from a dataset bills due during "this month".

Why make your life more complicated that it is.

Re: Datasets

Kurt_Bremser — Sat, 09 Mar 2019 15:17:23 GMT

Mind that most people here have an aversion against assisting people in being idiots, so forget that brain-dead splitting idea.

If it is an interview question, the proper answer is "don't do it, as it's a useless waste of time and therefore the employer's money".