sastipsbyhal.com
SAS Tips by Hal: June 2012
http://www.sastipsbyhal.com/2012_06_01_archive.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Wednesday, June 13, 2012. SAS Macro to Import all Worksheets of an XLSX file. SAS Macro to import all worksheets of an XLSX file */. Http:/ sastipsbyhal.blogspot.com/. Extra required software includes SAS/ACCESS, SAS/MACRO */. Assumes first row contains field names */. Assumes worksheets have valid SAS dataset names */. Libinpath = path to XLSX file.
sastipsbyhal.com
SAS Tips by Hal: How to create a SAS date from "YYYY-MM-DD HH:MM:SS"
http://www.sastipsbyhal.com/2011/07/how-to-create-sas-date-from-yyyy-mm-dd.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Wednesday, July 6, 2011. How to create a SAS date from "YYYY-MM-DD HH:MM:SS". How to pull a SAS date from a text field formatted as YYYY-MM-DD HH:MM:SS. DateVar = input(substr(temp dt,1,10), yymmdd10.);. SAS Date Calculator Now Available. Free SAS Date Calculator. Two Methods to Create a CSV: Proc Export and the Data Step. Other Blogs By Hal.
sastipsbyhal.com
SAS Tips by Hal: March 2012
http://www.sastipsbyhal.com/2012_03_01_archive.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Tuesday, March 13, 2012. SAS Macro to Export All Datasets in Library as SPSS Files. Export all datasets in library as SPSS. Looping code from Paper 93-26 by Edward Moore:. Http:/ www2.sas.com/proceedings/sugi26/p093-26.pdf. Many thanks to the author. MACRO exportSPSS(filepath, library);. Create Temporary Table - - -*/. DATA NULL ;. Loop - - -*/. Many ...
sastipsbyhal.com
SAS Tips by Hal: Example Libname Statement to Connect to a local MySQL Database
http://www.sastipsbyhal.com/2012/05/example-libname-statement-to-connect-to.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Thursday, May 17, 2012. Example Libname Statement to Connect to a local MySQL Database. Example SAS libname statement to connect to a local MySQL database:. Libname mys mysql user=. Server='127.0.0.1' port=3306;. The above would also work with. SAS Date Calculator Now Available. Free SAS Date Calculator. Proc SQL: Using Joins in an Update Statement.
sastipsbyhal.com
SAS Tips by Hal: March 2015
http://www.sastipsbyhal.com/2015_03_01_archive.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Tuesday, March 17, 2015. Need help choosing data visualization colors? Are you making a data visualization and interested in adding a custom set of colors to make the information really fly off of the page? If so, I recommend checking out ColorBrewer2.org. Subscribe to: Posts (Atom). SAS Date Calculator Now Available. Free SAS Date Calculator. Example...
rtipsbyhal.blogspot.com
R Tips by Hal: Creating Mathematical Functions
http://rtipsbyhal.blogspot.com/2012/03/creating-mathematical-functions.html
R Tips by Hal. R Code snippets, R tips, and short discussions. Saturday, March 3, 2012. Create a function of one independent variable. Define function y of x. Y - function(x) 2*x 1. Evaluate y for x=2. Create a function of multiple independent variables. Define function z of x and y. Z - function(x, y) 2*x y 2-7. Evaluate z for x=4 and y-7. Subscribe to: Post Comments (Atom). Example vector x - c(1, 24, 5, 3, 56) #Sample variance (assumes vector is sample) var(x) #Sample Standard Deviation (assumes vec.
rtipsbyhal.blogspot.com
R Tips by Hal: Interesting Mathematical Functions
http://rtipsbyhal.blogspot.com/2012/03/interesting-mathematical-functions.html
R Tips by Hal. R Code snippets, R tips, and short discussions. Saturday, March 3, 2012. Function with a pseudo-random component. F - function(x) cos(x) 2 - sample(1:10,1,replace=TRUE). Subscribe to: Post Comments (Atom). Example vector x - c(1, 24, 5, 3, 56) #Sample variance (assumes vector is sample) var(x) #Sample Standard Deviation (assumes vec. Function with a pseudo-random component f - function(x) cos(x) 2 - sample(1:10,1,replace=TRUE) #Factorial function factorial(). Helpful Sites for R.
sastipsbyhal.com
SAS Tips by Hal: July 2012
http://www.sastipsbyhal.com/2012_07_01_archive.html
SAS Tips by Hal. A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (javascript), code snippets, and brief discussions. Friday, July 6, 2012. Sample "Where" Clauses for Finding Dates in Text Fields. The following where clauses use SAS PRXMatch functions and simple Perl regular expressions to help find dates within SAS dataset text fields. Identify records that contain number/number, e.g. 1/2, 12/25, etc.:. Prxmatch('* d / d*', fieldname) = 1;. Prxmatch('* d- d*',.
