topic Re: Extracting Data from a Table in SAS Programming

Extracting Data from a Table

SasStatistics — Wed, 22 Sep 2021 12:42:30 GMT

I have a SAS data set, let's call it MyDataTable, of the following schematic form (it has like 10 millions rows so all months for the last 20 years are covered):

Observation	Period
1	201101
2	201102
3	201103
4	201104
5	201105
6	201106
7	201107
8	201108
9	201109
10	201110
11	201111
12	201112

The Period column has the format: $6.

Now, I would dynamically like to extract some observations each month in a table called MyDesiredData. So for example:

Assuming now we stand in year 2011:
In january I would like to extract observation 1 with period 201101

In februari I would like to extract observation 2 with period 201102

My try was something like:

data MyDesiredData; 
	set MyDataTable(where=(period=put(today(),yymn6.))); 
run;

Any suggestions?

Re: Extracting Data from a Table

Reeza — Wed, 22 Sep 2021 14:32:55 GMT

I would have expected that to work, what error did you get?

@SasStatistics wrote:

I have a SAS data set, let's call it MyDataTable, of the following schematic form (it has like 10 millions rows so all months for the last 20 years are covered):

Observation Period

1 201101

2 201102

3 201103

4 201104

5 201105

6 201106

7 201107

8 201108

9 201109

10 201110

11 201111

12 201112

The Period column has the format: $6.

Now, I would dynamically like to extract some observations each month in a table called MyDesiredData. So for example:

Assuming now we stand in year 2011:
In january I would like to extract observation 1 with period 201101

In februari I would like to extract observation 2 with period 201102

.

.

.

My try was something like:
data MyDesiredData; 
	set MyDataTable(where=(period=put(today(),yymn6.))); 
run; 
Any suggestions?

Re: Extracting Data from a Table

PaigeMiller — Wed, 22 Sep 2021 14:53:44 GMT

data MyDesiredData; 
	set MyDataTable(where=(period=put(today(),yymn6.))); 
run;

Maxim 2: Read the Log

Given the code you have posted, the log should indicate the exact problem.

Re: Extracting Data from a Table

SasStatistics — Wed, 22 Sep 2021 14:55:07 GMT

I used the reply you posted before, why did you remove it? Wanted to accept the answer.

Re: Extracting Data from a Table

PaigeMiller — Wed, 22 Sep 2021 15:07:37 GMT

@SasStatistics wrote:
I used the reply you posted before, why did you remove it? Wanted to accept the answer.

There are better answers ... as I said, read the log, then figure out what the problem is ... the log is very clear.

Re: Extracting Data from a Table

Reeza — Wed, 22 Sep 2021 15:03:12 GMT

Your original code should have worked, the other answer is actually not the preferred method, your code is the preferred method.
So what error did you get with the original code?