topic Need to fetch a single value from the existing dataset in SAS Programming

Need to fetch a single value from the existing dataset

shru — Wed, 21 Mar 2012 09:31:44 GMT

Hi,

My datset is as follows

obs f1 f2 f3 f4

1 1 2 3 4

2 3 4 5 6

3 7 6 6 8

Now,

with respect to condition like if obs =3 and f4=8 i need to fetch the value 8.

how can i achieve this?

Need to fetch a single value from the existing dataset

sambasiva_ravuri_tcs_com — Wed, 21 Mar 2012 10:23:36 GMT

Can you please elabrate the question.

Regards,

S Ravuri.

Need to fetch a single value from the existing dataset

shru — Wed, 21 Mar 2012 10:58:16 GMT

I need to fetch one value from the dataset with respect to column name obs and f4.

So that when i run the code i only get the value 8 as i mentioned.

Thanks

Need to fetch a single value from the existing dataset

Ksharp — Wed, 21 Mar 2012 11:00:13 GMT

data x;
 input obs   f1  f2  f3  f4 ;
cards;
1      1    2    3  4
2      3    4   5   6
3     7    6    6   8
;
run;
data want(keep=f4);
 i=3;
 set x point=i; 
 output;
 stop;
run;

Ksharp

Need to fetch a single value from the existing dataset

Haikuo — Wed, 21 Mar 2012 11:07:17 GMT

Or:

data want;

set x(firstobs=3 obs=3 keep=f4);

run;

Haikuo

Need to fetch a single value from the existing dataset

sambasiva_ravuri_tcs_com — Wed, 21 Mar 2012 11:18:34 GMT

Hi Ksharp, Hai.Kuo

Both worked well.

Regards,

S Ravuri.

Need to fetch a single value from the existing dataset

shru — Wed, 21 Mar 2012 11:52:17 GMT

Hi Hai.kuo and Ksharp

It worked fine

Thankss

Need to fetch a single value from the existing dataset

Ksharp — Thu, 22 Mar 2012 08:23:09 GMT

Your code is not as efficient as mine.

My code used Directly Access Method. However yours is Sequential Access Method.

If the dataset were very large. My code is better.

Ksharp

Need to fetch a single value from the existing dataset

Haikuo — Thu, 22 Mar 2012 11:03:21 GMT

Of course! :smileysilly:

Re: Need to fetch a single value from the existing dataset

Eleenrose — Tue, 13 Aug 2013 15:49:55 GMT

Hi,

I am totally new in SAS programming. I need to calculate last 6 months of current month. and it should be in yyyymm format. (eg: 201308) I was able to get the current date. but cannot find a solution to update the table with last 6 months.

this is how I appraoched. Please help.

Data Month;
Cur_month=date();
Format Cur_month YYMMN.
;
/*may be something like this is what I need*/
/*Mon1 = Cur_month-1;*/
/*Mon2 = Cur_month-2;*/
/*Mon3=Cur_month-3;*/
/*I did not get the right value in these fields. I got something like  19582, 19582, 19580*/

I tried to format it after calculating which again gave the value 201308. but it should be 201307, 201306, 201305

Please help..

Re: Need to fetch a single value from the existing dataset

ballardw — Tue, 13 Aug 2013 17:05:07 GMT

Eleenrose;

It would have been better to create a new thread as your question has no apparent bearing on the this thread.

The function you are looking for to create shifts of a data is INTNX.

I think you want Mon1 = INTNX("month",Cur_month, -1) ; The is an alignment parametere that can follow the -1 but you don't say whether the Mon1 should have a date represeting the begining, end, middle of the month or align with the same day of the month as Cur_month.

Your problem stems from subracting one day from the date value. If you used an MMDDYY format you would have seen your MonX variables decreasing by one day.

Re: Need to fetch a single value from the existing dataset

Vince28_Statcan — Tue, 13 Aug 2013 17:11:40 GMT

Ksharp,

If we are into code optimization, then you may want to review the position of the keep statement so that you don't "waste" memory allocation for a data vector of 5 variables when you only need one

Eleenrose, the issue is that all dates formats are held by sas as the number of days since 1960jan01. As such, when you substrat a day to your variable, even though its format is yymmn, it actually substracts 1 day from the date numeric value and then converts it back as a yymmn format so if a given date value was on the 16th of the month, you would need to substract 16 to eventually see the formatted substraction result change month after formating.

Intnx is the primary sas function to allow you to go around this issue.

mon1 = intnx('month', cur_month, -1);

Depending on your desired result, you may want to check the documentation for the 4rth parameter. By default from the above, the result will be the equivalent of the first day of the previous month and not the "same day" of the previous month.

Vincent

Re: Need to fetch a single value from the existing dataset

Eleenrose — Thu, 15 Aug 2013 09:00:20 GMT

Thanks for the help.

I got what I wanted to do. I used Intnx and got it working

data test;

mon1 = intnx('month', date(), -1);

mon2 = intnx('month', date(), -1);

format mon1, mon2,mon3.. yymmn6. ;

put (_all_)(=);

run;

Thanks everybody for the help. I am totally new to this field and trying to learn as far as I can..:)

Thanks again..

Eleen