/* these IN and OUT filerefs can point to anything */
filename in "anyfilehere.xlsx";
filename out "anyfilehere.xlsx";
/* copy the file byte-for-byte */
data _null_;
length filein 8 fileid 8;
filein = fopen('in','I',1,'B');
fileid = fopen('out','O',1,'B');
...
First, I will place my date into a Macro Variable.
NOTE: I find that
date9. works great with IBM® Netezza® SQL and Transact-SQL. Use whichever format that works for the type of SQL you're executing.
data _null_;
call symput('testDate',COMPRESS(put(today(),date9.)));
;RUN;
%PUT ...
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'Text/Plain';
Data _null_; File myEmail;
PUT "Email content";
PUT &q...
Take note of the email type: Type = 'text/html';
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'text/html';
Data _null_; File my...
This example shows how to manipulate button ideal size by specifying a fixed size.
class ButtonSubclass {
public:
ButtonSubclass(HWND hWndButton) {
SetWindowSubclass(hWndButton, MyButtonSubclassProc, 1, (DWORD_PTR) this);
}
~ButtonSuclass() {
RemoveWindowSubclass...
Install JSON Model Genrator plugin of Intellij by searching in Intellij setting.
Start the plugin from 'Tools'
Input the field of UI as following shows ('Path'、'Source'、'Package' is required):
Click 'Generate' button and your are done.
There will be times where you only want to import a specific sheet from an excel file with multiple sheets. To do that, we'll use "SHEET=".
PROC IMPORT
OUT= YourNewTable
DATAFILE= "myfolder/excelfilename.xlsx"
DBMS=xlsx
REPLACE;
SHEET="Sheet1&quo...
pip install scons
If you are not to run scons from command line, check that Python scripts directory is added to PATH for your installation.
If you want to play with API, import SCons from Python won't work, because SCons 2.5.x and below allows to install multiple versions side-by-side. This was...
I would describe %LET as being the most simple way to creating a Macro Variable in SAS.
%LET variableName = variableValue;
Now, anywhere you use &variableName, it will resolve to variableValue.
NOTE:you may want to consider that variableValue all on its own might bring you syntax errors, ...
Using PROC SQL is a good way to get quick results from a table and throw them into variables. I usually find that when I want to get a count of records I just loaded to a table, I can get that count into a variable with a quick PROC SQL call.
PROC SQL;
SELECT
COUNT(*) INTO:aVariable
FROM
...
DATA _null_;
CALL SYMPUT('testVariable','testValueText');
;RUN;
In the example above, %PUT &testVariable; will resolve to testvalueText.
You may find the need to format your variable within the SYMPUT() call.
DATA _null_;
CALL SYMPUT('testDate',COMPRESS(PUT(today(...
Here follows a example of what can be done with nested StackViews, giving the user the impression of a continuous scrolling experience using complex user interface elements or alignments.
A frequent question about StackViews inside Scrollviews comes from ambiguous with/heigh alerts on interface builder. As this answer explained, it is necessary to:
Add in the UIScrollView a UIView (the contentScrollView);
In this contentScrollView, set top, bottom, left and right margins to 0
Se...
The big gotcha about scrolling is to determine the offset necessary to present (for instance) a Textfield inside a StackView with is inside the ScrollView.
If you try to get the position of Textfield.frame.minY can be 0, because the minY frame is only considering the distance between the element an...
