BookmarkSubscribeRSS Feed
Jens_v
Calcite | Level 5

Hallo SAS community.

I am stuck with a problem i hope you can help me with.

I have created the code:

proc surveyselect data= xxx.X201202  method=srs n=200 seed=200

      out=test1;

    Where department ne "AgroTech A/S";

Run;

However, i want to create a macro which loop through the data set

  • Samlple1 .... Sample6

If the variable "Initials" from the sample1-6 is the same as initials in xxx.X201202 then these observationses should not be a part of the random sample of 200.

I hope you can help me.

/Jens

7 REPLIES 7
art297
Opal | Level 21

I don't understand your question. If you simply want to randomly assign people to six different groups, without replication, then take a look at: 36383 - Randomly assign the observations in a data set to two or more groups

Jens_v
Calcite | Level 5

I have tried to make following code:

Udklip.PNG

However, I have no idea if this is the right way to go. I hope you understand what my problem is...

art297
Opal | Level 21

You have to indicate what you are trying to do. You're macro creates a local macro variable six times, each time discarding the previous version. I don't understand its purpose.

Your 2nd where statement doesn't make sense (to me). While you have shown any example data, a statement like:

where initialer ne 1, 3, 5;

won't work

I suggest you post some sample data, explain what you want to accomplish and, based on the sample data, what resulting file you want to obtain.

Jens_v
Calcite | Level 5

Hallo again and thank you for your patience.

Data set 1

ObsInitialsCompanyCost

1

KLOAgroTech A/S50000
2AVGLEGO12000
3SLOB&O53000
4

NRL

AgroTech A/S98000
5PLAINFINION15244
n

Data set 2

ObsInitials
1AVG
2

KLP

3QGY
4DGY
5MNJ
n

Data set 3

ObsInitials
1PLA
2GTX
3MLO
4BBN
nDYU

What I am trying to do is to make an random sample of "data set 1".

However, I do not want to include observations with the same initials from data set 2 and 3. Therefore the random sample must not include obs 2 and 5, because their initials occur in data set 2 and 3.

art297
Opal | Level 21

Sounds like you are trying to do something like the following:

data initials;

  set sample1 sample2 sample3 sample4 sample5 sample6;

run;

proc sql noprint;

  select distinct quote(strip(initials))

    into :initials separated by ','

      from initials

  ;

quit;

proc surveyselect data=x201202 method=srs n=200 seed=200

  out=test005;

  where afdeling ne "AgroTech A/S" and

        initialer not in (&initials.);

run;

Rick_SAS
SAS Super FREQ

You might want to read the article "Sample with replacement in SAS" which discusses some of the issues and techniques for sampling with replacement.

PGStats
Opal | Level 21

So, what I understand is that you already have samples and you want the new sample to exclude cases already selected. Try this (not tested) :

/* Create a  set of existing samples */

data sampSet / view=sampSet;

set xxx.sample:;

keep initials;

run;

/* Create a subset of x201202 excluding existing samples */

proc sql;

create view newSet as

select *

from xxx.X201202

where

  initials not in (select initials from sampSet);

quit;

/* Create a new sample from X201202, excluding previous samples */

call surveyselect data=newSet method=srs n=200 seed=200 out=test005;

run;

PG

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1073 views
  • 0 likes
  • 4 in conversation