topic Re: Dynamically create datasets in SAS Programming

Dynamically create datasets

ANLYNG — Mon, 14 Nov 2016 17:01:25 GMT

I need to dynamically to create location datasets with 100 observations for each location.The idea is that they should be updated locally by editing.

I first create a list (macro called name1.) with the names of the files. Then create the design of the table.

I can not get it to work in the last part where I need to filter the observations onlovation i.e. I need the right and only 100 observations in each dataset.

Hope you can help.

Here is some code:

proc sql noprint;

select namestrip

into :name1 separated by ' '

from location;

quit;

run;

data test;

set Location(keep=XXX YYY);

length Description $250.;

do i=1 to 100;

Label XXX="XXX" ;

Label YYY="YYY";

Description=" ";

run;

data GGG.&name1.;

set test2;

if &name1.=namestrip then output;

run;

Re: Dynamically create datasets

Kurt_Bremser — Mon, 14 Nov 2016 17:14:19 GMT

You need to put &name1. into double quotes, so it will be recognized by the data step compiler as a string literal and not a variable name.

Re: Dynamically create datasets

ANLYNG — Mon, 14 Nov 2016 17:27:43 GMT

when I so I get zero observations in the output. the macro contains a list loc1 loc2 loc2. Some how I need to test each value toward namestrip. Any ideas? Thanks in advance.

My data is:
namestrip XXX YYY
loc1 1 1
loc1 1 1
....
loc2 3 4
loc2 7 7
.......
loc3 3 4
loc3 7 7

The data is

locatio

Re: Dynamically create datasets

Kurt_Bremser — Mon, 14 Nov 2016 17:33:02 GMT

Please stay with your original problem. Once that is solved, you will either find a solution for similar problems yourself, or we can then deal with the new question.

Have you already tried my suggestion?

Re: Dynamically create datasets

ANLYNG — Mon, 14 Nov 2016 17:36:05 GMT

I have tried your suggestion. It comes near a solution but I get no observations out.

Re: Dynamically create datasets

Astounding — Mon, 14 Nov 2016 18:05:00 GMT

Aren't you getting an error message from this:

set test2;

There is no data set named test2.

Re: Dynamically create datasets

ANLYNG — Mon, 14 Nov 2016 18:07:13 GMT

I tried to make it simple-Imean to set test.....

I read 300 observation in but no out.

Re: Dynamically create datasets

mkeintz — Mon, 14 Nov 2016 18:28:19 GMT

You want a program that looks like:

data loc1 (where=(namestrip='LOC1') loc2 (where=(namestrip='LOC2')) ....

set have;

run;

This program does that:

Notes:

Instead of select distinct namestrip, you can "select distinct" expression-using-namestrip to generate the arguments of the DATA statement above. Look at the value of the DSLIST macrovar created in the program.
This does require two passes of the data - once to determine DSLIST, and once to wrtie the data sets.

Regards,

Mark


data have;
  input namestrip $4. XXX YYY;
datalines;
loc1 1 1
loc1 1 1
loc2 3 4
loc2 7 7
loc3 3 4
loc3 7 7
run;

proc sql noprint;
  select distinct 
     cats(namestrip
         , '(where=(namestrip='
         ,quote(trim(namestrip))
         ,'))'
         )
   into :dslist separated by ' ' 
   from have;
quit;

%put &=dslist;

data &dslist ;
  set have;
run;

Re: Dynamically create datasets

ANLYNG — Mon, 14 Nov 2016 18:38:20 GMT

This is a really nice solution and it works perfectlly.Thanks a lot.