Search Results

Search found 3 results on 1 pages for 'bazil'.

Page 1/1 | 1 

• Using SAS Macro to pipe a list of filenames from a Windows directory

  - by Bazil

  I am trying to amend the macro below to accept a macro parameter as the 'location' argument for a dir command. However I cannot get it to resolve correctly due to the nested quotes issue. Using %str(%') does not work, neither do quoting functions for some reason. The macro will work fine when the filepath has no spaces (eg C:\temp\withnospace)…

  Read the article

• Using Base SAS to validate Windows Password

  - by Bazil

  We have a signon script that requires a Windows password in order to access and validate against the SAS metadata server. The problem is that if the windows password is changed, and the script is run a few without being updated, then the user gets locked out and has to call IT support for a password reset. What is the simplest way of using Base…

  Read the article

• Netezza SQL syntax to convert numeric YYYYMMDD format into date

  - by Bazil

  We have a Netezza table that contains dates stored in a numeric YYYYMMDD format (eg 20090731). What is the best Netezza syntax to use to convert this into date format? eg SELECT somefunction(20090731) as NZDATE ?

  Read the article

1