topic how to create data sets in SAS Programming

how to create data sets

bismilla — Tue, 05 Mar 2019 09:37:16 GMT

Hi Guys

i have sas help library like sas help.class in this data sets 19 observation is there how to create 19 observation in 19 data sets

Advance Thanks

Re: how to create data sets

Kurt_Bremser — Tue, 05 Mar 2019 10:06:35 GMT

What for? You can always use the original dataset.

Re: how to create data sets

RW9 — Tue, 05 Mar 2019 10:15:19 GMT

Sorry, its not clear what you mean. Do you want 19 copies of the same dataset, or 19 datasets with one record in each? Either way it really does not sound like th ebest way to go about doing whatever it is you want to do. SAS has inbuilt by group processing, so printing data by a variable and doing sums by a variable is far simpler using that.

Re: how to create data sets

bismilla — Tue, 05 Mar 2019 10:27:55 GMT

for exp;

data ds1;

set sas help.class;

run;

in this data set we have 19 observation and 5 variable

i need 19 observation in 19 data set name ds1 ds19 like that

Thanks advance

Re: how to create data sets

Kurt_Bremser — Tue, 05 Mar 2019 10:34:25 GMT

Since these are just copies of the original, this is a useless waste of time. Use your mind for something that makes sense.

Re: how to create data sets

bismilla — Tue, 05 Mar 2019 10:52:04 GMT

that the reason iam asking this the interview questions

Re: how to create data sets

RW9 — Tue, 05 Mar 2019 11:20:40 GMT

Its possible, you could just put all the dsX on the data line, or you could be more complicated with:

data _null_;
  set sashelp.vtable (where=(libname="SASHELP" and memname="CLASS"));
  do i=1 to nobs;
    call execute(cats('data ds',put(i,best.),'; set sashelp.class; run;'));
  end;
run;

At the end of the day its pointless and a question like that would put me off the role.

** Updated to be dynamic with number of observations.

Re: how to create data sets

VRKiwi — Tue, 05 Mar 2019 11:13:52 GMT

This works:

proc sql noprint; 
  select count(*) 
  into :NUMBEROBS
  from sashelp.cars;
quit; 

data %MACRO TABLES; /* create the tables */
    %do i = 1 %to &NUMBEROBS; 
    work.OBS&i
    %end; 
    %mend;
    %tables; 
  set sashelp.cars;
  %MACRO TESTS; /* assign the obs to each table */
    %do i = 1 %to &NUMBEROBS; 
    if _N_ = &i then
      output work.obs&i; 
    %end; 
    %mend;  
    %Tests;
run;

Re: how to create data sets

VRKiwi — Tue, 05 Mar 2019 11:19:44 GMT

Or depending on what OP wants:

data _null_;
  set sashelp.class;
  call execute(catt('data ds',_N_,'; set sashelp.class(firstobs=',_N_,' obs= ',_N_,'); run;'));
run;

Re: how to create data sets

Kurt_Bremser — Tue, 05 Mar 2019 11:28:08 GMT

@bismilla wrote:

that the reason iam asking this the interview questions

If I put such a question into a interview questionnaire, I would only accept candidates that answer "I don't do it, it's useless".

Re: how to create data sets

ballardw — Tue, 05 Mar 2019 17:14:47 GMT

@bismilla wrote:

for exp;

data ds1;

set sas help.class;

run;

in this data set we have 19 observation and 5 variable

i need 19 observation in 19 data set name ds1 ds19 like that

Thanks advance

Actually that code will generate errors as the LIBRARY name is one word: SASHELP not "SAS HELP". Your code would be asking to combine a data set name SAS in the default library, most likely WORK with a set named CLASS in a likely undefined library named HELP. Spelling really does count when it comes to programming.

See this log:

1    data ds1;
2       set  sas help.class;
ERROR: File WORK.SAS.DATA does not exist.
ERROR: Libref HELP is not assigned.
3    run;

Which also demonstrates the use of the code box opened using the forum's {I} icon. It is better to post code and log entries into the code box as the forum main windows will reformat code and place additional characters that will sometimes prevent code from running when copied from the window.

Re: how to create data sets

bismilla — Wed, 06 Mar 2019 06:54:15 GMT

Thank you so much thanks for your supporting