sastipsbyhal.com
SAS Tips by Hal: December 2014
http://www.sastipsbyhal.com/2014_12_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. Thursday, December 4, 2014. My favorite SAS proc: proc freq. No doubt, my favorite proc step is proc freq. PROC freq data=NAME;. Subscribe to: Posts (Atom). SAS Date Calculator Now Available. Free SAS Date Calculator. Two Methods to Create a CSV: Proc Export and the Data Step. Proc SQL: Using Joins in an Update Statement. Other Blogs By Hal.
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: 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...
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.
accesstips.net
AccessTips.net: Modernize your forms' look with colors and more in Access 2013
http://www.accesstips.net/2015/03/modernize-your-forms-look-with-colors.html
AccessTips.net (formerly Microsoft Office Access Tips by Hal) brings the best in Microsoft Office Access tips to you. AccessTips.net includes a Microsoft Office Access tutorial, tips and tricks, an FAQ, and VBA code snippets. Tuesday, March 17, 2015. Modernize your forms' look with colors and more in Access 2013. Figure 1: A basic form created in Access 2013. What can be done to spruce up and modernize an basic, simple Access form? Here are three quick tips:. On the right hand side of the design tab, Acc...
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*',.
sastipsbyhal.com
SAS Tips by Hal: Need help choosing data visualization colors? Try ColorBrewer2.org
http://www.sastipsbyhal.com/2015/03/need-help-choosing-data-visualization.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. SAS Date Calculator Now Available. Free SAS Date Calculator. My favorite SAS proc: proc freq.