cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
aj34321
‎06-24-2022
  • 89 Posts
  • 0 Likes Given
  • 2 Solutions
  • 5 Likes Received

Sizekmg format to show TB

by Quartz | Level 8 in SAS Programming
‎08-16-2017 09:46 PM
2 Likes
‎08-16-2017 09:46 PM
2 Likes
Hi All,   Does any one know how to use SizeKMG format to display values in Terabyte.   For now, it only prrints KB, MB & GB.    Need extension for TB.   Any suggestions? ... View more

Re: Graph comparison of current versus previous month for each day.

by Quartz | Level 8 in Graphics Programming
‎08-08-2017 04:44 AM
‎08-08-2017 04:44 AM
Attached zip file has the expected look. ... View more

Graph comparison of current versus previous month for each day.

by Quartz | Level 8 in Graphics Programming
‎08-08-2017 04:24 AM
‎08-08-2017 04:24 AM
Hi All,   I'm facing difficulty in generating a graph thru sas code. Attached is the sample graph output expected.   Request if some can help me on the code that produces this output.    Thanks for your help.   Rgds, Anil   Data step code: data TEMP.DN; infile datalines dsd truncover; input log_date:DATE9. space_used:COMMA4. yy:32. mm:32. dd:32.; datalines4; 01JUL2017,21,2017,7,1 02JUL2017,22,2017,7,2 03JUL2017,22,2017,7,3 04JUL2017,22,2017,7,4 05JUL2017,22,2017,7,5 06JUL2017,22,2017,7,6 07JUL2017,22,2017,7,7 08JUL2017,22,2017,7,8 09JUL2017,22,2017,7,9 10JUL2017,22,2017,7,10 11JUL2017,22,2017,7,11 12JUL2017,22,2017,7,12 13JUL2017,23,2017,7,13 14JUL2017,23,2017,7,14 15JUL2017,23,2017,7,15 16JUL2017,24,2017,7,16 17JUL2017,24,2017,7,17 18JUL2017,24,2017,7,18 19JUL2017,24,2017,7,19 20JUL2017,25,2017,7,20 21JUL2017,25,2017,7,21 22JUL2017,25,2017,7,22 23JUL2017,25,2017,7,23 24JUL2017,25,2017,7,24 25JUL2017,25,2017,7,25 26JUL2017,25,2017,7,26 27JUL2017,26,2017,7,27 28JUL2017,26,2017,7,28 29JUL2017,26,2017,7,29 30JUL2017,26,2017,7,30 31JUL2017,26,2017,7,31 01AUG2017,27,2017,8,1 02AUG2017,28,2017,8,2 03AUG2017,28,2017,8,3 04AUG2017,28,2017,8,4 05AUG2017,28,2017,8,5 06AUG2017,28,2017,8,6 07AUG2017,28,2017,8,7 08AUG2017,28,2017,8,8 ;;;;     ... View more

Re: List all attributes from the scheduled job.

by Quartz | Level 8 in Administration and Deployment
‎03-05-2017 08:33 PM
‎03-05-2017 08:33 PM
Hi.. I'm very new to Metadata querying / reporting hence i'm not sure how this XML can be retreived. If you can guide the steps would be really helpful. Thanks. ... View more

Re: List all attributes from the scheduled job.

by Quartz | Level 8 in Administration and Deployment
‎03-04-2017 05:07 AM
‎03-04-2017 05:07 AM
SAS is installed on Linux and all jobs are deployed on LSF/Platform Manager. ... View more

Re: Looking for a macro that converts unix file permissions string to ...

by Quartz | Level 8 in SAS Programming
‎03-01-2017 11:07 PM
‎03-01-2017 11:07 PM
Hi Shmuel, How to handle Sticky Bits, UID & GID's with this code? Thanks your guidance. ... View more

List all attributes from the scheduled job.

by Quartz | Level 8 in Administration and Deployment
‎03-01-2017 12:56 AM
‎03-01-2017 12:56 AM
Hello Experts,   I have a requirement in which I need to list down all the dependencies from a scheduled job on metadata.   These dependencies are found on the Dependency tab of a job property in Schedule Manager.   Would also love to read all other attributes from tab General, Attributes and Job Properties.   Can anyone guide me on how to retreive this for a given job or all jobs in a tabular format.      Thanks,   Anil   ... View more

FileEvents in LSF not working.

by Quartz | Level 8 in SAS Programming
‎01-31-2017 09:03 PM
‎01-31-2017 09:03 PM
Hello All,   First of apologies for asking this query in a wrong group but I'm not sure which one is the perfrct group to post this query.   I have a LSF Flow in which I'm running a SAS Job. Now this SAS Jobs should trigger on a particular file availibility and for which I have added 3 file events viz, EXISTS, ARRIVAL, and FILEAGE.    What I want is if any of the condifiton satisfies the SAS job should get triggered, but in my case my flow is waiting endlessly for what no idea.   Can anyone give some hints on this as in what and where to check.     All the conditions do satisy but its just that its not getting from the flow.   Thanks in advance,   Rgds, Anil   ... View more

Re: questions about SAS connection to SQL server with ODBC

by Quartz | Level 8 in SAS Data Management
‎01-18-2017 10:48 PM
‎01-18-2017 10:48 PM
You can use both authentications..     But when using Windows NT user account, ensure to make changes to ODBC file and add AuthenticationMethod=9 and Domain=<WIndows domain name> ... View more

Re: Looking for a macro that converts unix file permissions string to ...

by Quartz | Level 8 in SAS Programming
‎01-18-2017 04:09 AM
‎01-18-2017 04:09 AM
Thank you so much. This small code really awesome. ... View more

Looking for a macro that converts unix file permissions string to a nu...

by Quartz | Level 8 in SAS Programming
‎01-17-2017 09:11 PM
‎01-17-2017 09:11 PM
Looking for a macro that converts unix file permissions string to a number   Like - -rwxr-xr-x    should return 755 -rwxrwxr-x   should retrun 775 -rwx------     should return 700   Has anyone something like this readily available?   Rgds, Anil   ... View more

Re: Datetime in a SQL Passthrough

by Quartz | Level 8 in SAS Programming
‎01-08-2017 02:48 AM
‎01-08-2017 02:48 AM
Hi Patrick,   Below is what im assigning into macro variable. %let transfer_start_time = %sysfunc(datetime()); /*sas code here*/ %let transfer_end_time = %sysfunc(datetime());   Thanks,   Anil   ... View more

Datetime in a SQL Passthrough

by Quartz | Level 8 in SAS Programming
‎01-08-2017 01:59 AM
‎01-08-2017 01:59 AM
Hi All,    Request if someone can help me on the below error. I'm simply storing start & end time in a macro variable and passing it into an SQL passthrough to update the start and end times into sql table. What should i change it, so that the table is updated for the start and end times.     ERROR: CLI execute error: [SAS/ACCESS to SQL Server][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Arithmetic overflow error converting expression to data type datetime. : [SAS/ACCESS to SQL Server][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The statement has been terminated.   %let transfer_start_time = %sysfunc(datetime()); /*sas code here*/ %let transfer_end_time = %sysfunc(datetime());     proc sql; connect to sqlsvr (&sqlconn_stg); execute ( update schema.table set StartDate = &transfer_start_time, EndDate = &transfer_end_time, RecordCount = 10000, StatusCode = 'X1' where TransferId = 1010 and StatusCode = 'XP' ) by sqlsvr; disconnect from sqlsvr; quit;   Thanks,   Anil   ... View more

Proc compare (One SAS Dataset against 10 different SQL tables)

by Quartz | Level 8 in SAS Programming
‎12-15-2016 08:06 PM
‎12-15-2016 08:06 PM
Hello All,   I have a requirement of proc compare of one SAS dataset against 10 sql tables. This SAS dataset has a total of 64,323,006 records which is copied in 10 SQL tables. Below is the SAS dataset breakup inserted into SQL physical tables.   Iteration,StartObs,EndObs,TotalObs 1,1,7147000,7147000 2,7147001,14294000,7147000 3,14294001,21441000,7147000 4,21441001,28588000,7147000 5,28588001,35735000,7147000 6,35735001,42882000,7147000 7,42882001,50029000,7147000 8,50029001,57176000,7147000 9,57176001,64323000,7147000 10,64323001,64323006,6 Next I want to run a proc compare of sas dataset against these 10 sql tables (somehow at proc compare these 10 sql tables should appear as a single dataset. I dont want to download these sql tables into sas dataset but directly compare in as is condition)   Request if anyone can help on this.   Thanks,   Anil     ... View more

Re: looping over time

by Quartz | Level 8 in SAS Programming
‎12-01-2016 01:50 AM
‎12-01-2016 01:50 AM
Yes, a wait is required until that process is finished and then kick off the next insert at the nearest 30 mins. You are right, this approach will be same across all day. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-24-2022 10:22 AM
Likes from
Quick links