About KBou

TomKari · ‎09-17-2020

If you ever need to convert an Excel number to a character field, the "text" function does this. For example, if A1 is a number, use: =TEXT(A1,"00") Tom

KBou · ‎02-14-2020

Oh wow, i feel dumb. Didn't even saw that. Ty sir

KBou · ‎01-13-2020

Ty sir, very appreciated. Didn't knew about the quote function. Wasn't used in any of our codes yet, but certainly will be since i generate every macro variable by SQL.

PGStats · ‎04-03-2019

A technique from the previous century: with a program editor that can search many files at once for regular expressions, such as Notepad++, you could search all your SAS programs for the pattern ^\s*\w+\s*= and get a listing of all simple assignments such as:

Online Status	Offline
Date Last Visited	‎06-28-2022 12:53 PM

Re: Assign prompts value in a vbs for SAS Automation

Re: Assign prompts value in a vbs for SAS Automation

Assign prompts value in a vbs for SAS Automation

Re: Problem with arrays format

Problem with arrays format

Re: SQL, Macro variable and WHERE clause

SQL, Macro variable and WHERE clause

Re: Finding the link between dependent and independent variables ?

Re: Finding the link between dependent and independent variables ?

Finding the link between dependent and independent variables ?

Re: Assign prompts value in a vbs for SAS Automation

Re: Assign prompts value in a vbs for SAS Automation

Re: Problem with arrays format

Re: SQL, Macro variable and WHERE clause

Re: Finding the link between dependent and independent variables ?