Dynamic Data Set

  • Follow


Hello everyone,

I need to create a Data Set Dynamically , data file can be run on a daily
basis or weekly basis
I need to concat filename like ..like CURRCLM with the current date
yyyymmdd
For e-g --- Data set – CURRCLM20091119
Can someone please help from the coding perspective ,

Thanks ,
- Swamy
0
Reply sasswamy (42) 11/19/2009 5:15:10 PM

What specifically are you doing?

Creating a dataset from a file that changes name every day; or is the
dataset's name changing?

Are you running this interactively or in batch mode?

-Joe

On Thu, Nov 19, 2009 at 11:15 AM, SAS Swamy <sasswamy@gmail.com> wrote:

> Hello everyone,
>
> I need to create a Data Set Dynamically , data file can be run on a daily
> basis or weekly basis
> I need to concat filename like ..like CURRCLM with the current date
> yyyymmdd
> For e-g --- Data set =96 CURRCLM20091119
> Can someone please help from the coding perspective ,
>
> Thanks ,
> - Swamy
>
0
Reply snoopy369 (1752) 11/19/2009 5:16:58 PM


Joe,

I should have been more specfic , sorry was in a hurry.
Yes , I will have to create Data set from a file which would be changing
every day
    I will never have access for the data file , so I dynamically need to
create the data set with the specific prefix , followed by the YYYYMMDD
value , since the data file name will match the same , the process would
start from that point onwards
I Hope I made my point , please let me know otherwise.

- Swamy


On Thu, Nov 19, 2009 at 12:16 PM, Joe Matise <snoopy369@gmail.com> wrote:

> What specifically are you doing?
>
> Creating a dataset from a file that changes name every day; or is the
> dataset's name changing?
>
> Are you running this interactively or in batch mode?
>
> -Joe
>
>  On Thu, Nov 19, 2009 at 11:15 AM, SAS Swamy <sasswamy@gmail.com> wrote:
>
>> Hello everyone,
>>
>> I need to create a Data Set Dynamically , data file can be run on a dail=
y
>> basis or weekly basis
>> I need to concat filename like ..like CURRCLM with the current date
>> yyyymmdd
>> For e-g --- Data set =96 CURRCLM20091119
>>
>> Can someone please help from the coding perspective ,
>>
>> Thanks ,
>> - Swamy
>>
>
>
0
Reply sasswamy 11/19/2009 5:27:12 PM

Sounds like you want to generate the name of the dataset you are
creating based on today's date.

You can use the TODAY() function to get today's date and the YYMMDDN8.
function to generate the date in the YYYYMMDD format.
Note: This format is useful for files as it will sort properly when
treated as a text string.

So you would replace the reference
 data CURRCLM ;
 in your code with
 data CURRCLM%sysfunc(today(),yymmddn8.) ;

- Tom Abernathy

On Nov 19, 12:15=A0pm, sassw...@GMAIL.COM (SAS Swamy) wrote:
> Hello everyone,
>
> I need to create a Data Set Dynamically , data file can be run on a daily
> basis or weekly basis
> I need to concat filename like ..like CURRCLM with the current date
> yyyymmdd
> For e-g --- Data set =96 CURRCLM20091119
> Can someone please help from the coding perspective ,
>
> Thanks ,
> - Swamy

0
Reply Tom 11/19/2009 7:00:12 PM

3 Replies
134 Views

(page loaded in 0.188 seconds)


Reply: