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)
|