topic Re: How to read date value from Unix and use into sas in SAS Programming

How to read date value from Unix and use into sas

SRINIVAS_N — Fri, 07 Sep 2018 17:36:48 GMT

I want to read date value from Unix and the value I want to use in SAS programming.

Re: How to read date value from Unix and use into sas

AMSAS — Fri, 07 Sep 2018 17:51:34 GMT

Hi Srinivas_N

To fully answer this you need to supply more information:

Where is your data stored, what is the format of that data, etc.

For example if you were reading a text file "\some\file.txt"

data mySASDS ; /* This creates a SAS dataset in the WORK library */

infile "\some\file.txt" ; /* This defines your source file */

input num_var str_var $ date_var ddmmyy. ; /* This tells SAS how to read the data in the source file */

run ;

There's more to it than that, but that's the basics. I suggest you go loop up those statements in the documentation and look at the examples

Re: How to read date value from Unix and use into sas

Reeza — Fri, 07 Sep 2018 17:53:49 GMT

What is the current reason you cannot do this?

What is the source data?

What have you tried that doesn't work?

@SRINIVAS_N wrote:
I want to read date value from Unix and the value I want to use in SAS programming.

Re: How to read date value from Unix and use into sas

Kurt_Bremser — Fri, 07 Sep 2018 17:59:17 GMT

If you want to import a typical UNIX timestamp into SAS, you need to do the following:

read into a numeric variable
add '01jan1970:00:00:00'dt to it
format as a datetime value or
use the datepart() function to extract the date, and use a date format

UNIX timestamps are counts of seconds like they are in SAS, but the zero point is different.

Re: How to read date value from Unix and use into sas

SRINIVAS_N — Fri, 07 Sep 2018 18:02:31 GMT

Today() returns today's date
I want to pass a date value to control m scheduler ,so I want to get date
value from Unix to SAS

Re: How to read date value from Unix and use into sas

AMSAS — Fri, 07 Sep 2018 18:28:54 GMT

Hi,
Really need more details of what you are attempting to do, as it is still unclear.
From this post it looks like you might be attempting to pass a parameter/argument from Unix into a SAS program

You can do this by using the SYSPARM invocation option, which the SAS program can then read via the SYSPARM macro variable, further details can be found here