SAS programming Questions

1

SAS date macro variable
Hello, i’m new in SAS I’m writing this code below :     data _test_ ; d1 = put(mdy(month(today())-   1,1,year(today())-1),yymmdd10.);     call symput(‘d1′,”‘”||put(d1,9.)||” 23:59:59′”) ; d2 = put(mdy(month(today())-   1,1,year(today())),yymmdd10.);     call symput(‘d2′,”‘”||put(d2,9.)||” 23:59:59′”) ;     run ;     %put d1;   My question is 1. My understanding is %put [...]

Answer Question   |  October 11, 2010  5:12 PM
Macros, Programming Languages, SAS 9.2, SAS programming
asked by:
30 pts.

Macro date a year from today
Does any know how to create a year date from today ? for example today = 9/3/2010 I would like to get the macro variable that give 9/1/2009

Answer Question   |  October 11, 2010  3:36 PM
Date calculation, Macros, Programming Languages, SAS programming
asked by:
30 pts.

How can I run a SAS program in mainframe that calls Oracle in Unix
Hi, I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table. I tried this SAS program in PC SAS without any problem. How do I connect to Oracle in my SAS prgram in z/OS? Need help, please    

Answer Question   |  August 13, 2010  7:12 PM
Mainframe, Oracle, Oracle Table, SAS, SAS programming, Unix, z/OS
asked by:
20 pts.

SAS OR ORACLE.WHICH IS THE BEST?
TO PERSUE MY CARER IS IT BEST TO DO SAS OR ORACLE? WHICH 1 AMONG THE 2 OFFERS BETTER EARNING JOB?

Answer Question   |  September 29, 2009  1:52 PM
Oracle Careers, Oracle certifications, SAS, SAS programming
asked by:
15 pts.

How do I convert time value in integer form to SAS time?
I am working with SAS tables that currently have time values listed in integer form (ex: 65123 is 6:51:23am, 165824 is 4:58:24pm in hours minutes seconds). I desperately need to convert this to SAS time (or any other SAS format).

Answer Question   |  January 18, 2010  3:11 PM
SAS programming
asked by:
10 pts.

1