03-07-2025
SylvainTremblay
SAS Employee
Member since
02-12-2013
- 13 Posts
- 2 Likes Given
- 1 Solutions
- 7 Likes Received
About
I was born in Outaouais but grew up in Gaspésie, Lac St-Jean and the South Shore of Montréal, Québec. After earning a degree in statistics from the University of Montréal, I worked in the market research field in the advertising world. I joined SAS Canada more than 14 years ago in a pre-sales role where I specialized in data mining and analytical solutions. For the past 8 years, I have been an instructor in the Education group at SAS, teaching programming, statistics, data mining and business intelligence courses to diverse organizations from coast to coast.
-
Latest posts by SylvainTremblay
Subject Views Posted 217 03-07-2025 09:45 AM 2856 12-05-2022 10:38 AM 696 12-01-2022 02:05 PM 862 01-04-2022 03:50 PM 1416 10-08-2020 10:28 AM 1424 10-08-2020 10:09 AM 3653 10-01-2020 10:33 AM 3678 10-01-2020 09:44 AM 1118 09-29-2020 03:32 PM 1163 09-29-2020 12:52 PM -
Activity Feed for SylvainTremblay
- Got a Like for Re: In Analytics Pro, enhance the Open command in Studio. 03-07-2025 02:03 PM
- Posted Re: In Analytics Pro, enhance the Open command in Studio on SAS Product Suggestions. 03-07-2025 09:45 AM
- Liked In Analytics Pro, enhance the Open command in Studio for Bill_in_Toronto. 03-07-2025 09:26 AM
- Liked 2nd Place Winner - 2023 Customer Awards: Canada Revenue Agency (CRA) - Professional Growth Award for jaoliver1. 06-23-2023 11:47 AM
- Got a Like for Re: Can SAS 9.4 TS1M2 perform bootstrap resampling for validation of prediction models?. 12-06-2022 07:07 AM
- Got a Like for Re: Can SAS 9.4 TS1M2 perform bootstrap resampling for validation of prediction models?. 12-05-2022 11:00 AM
- Posted Re: Can SAS 9.4 TS1M2 perform bootstrap resampling for validation of prediction models? on Statistical Procedures. 12-05-2022 10:38 AM
- Posted Re: PROC DMDB procedure on Statistical Procedures. 12-01-2022 02:05 PM
- Got a Like for Re: Programming 1 Extended Learning Reading Text files p108d01.sas not executing as documented in le. 02-01-2022 08:17 AM
- Posted Re: Programming 1 Extended Learning Reading Text files p108d01.sas not executing as documented in le on Programming 1 and 2. 01-04-2022 03:50 PM
- Got a Like for Re: Errors with Proc GENMOD and GEE. 10-13-2020 08:14 AM
- Posted Re: How to direct plots to be saved in an rtf file in the output folder and not go in the user area on Statistical Procedures. 10-08-2020 10:28 AM
- Posted Re: How to direct plots to be saved in an rtf file in the output folder and not go in the user area on Statistical Procedures. 10-08-2020 10:09 AM
- Got a Like for Re: Errors with Proc GENMOD and GEE. 10-01-2020 10:37 AM
- Posted Re: Errors with Proc GENMOD and GEE on Statistical Procedures. 10-01-2020 10:33 AM
- Posted Re: Errors with Proc GENMOD and GEE on Statistical Procedures. 10-01-2020 09:44 AM
- Posted Re: Visualization--Requesting help in getting SGPANEL to work like SGPLOT? on Graphics Programming. 09-29-2020 03:32 PM
- Posted Re: Visualization--Requesting help in getting SGPANEL to work like SGPLOT? on Graphics Programming. 09-29-2020 12:52 PM
- Posted Re: creating ranges and then percentages on Statistical Procedures. 09-28-2020 03:57 PM
- Posted Choose Your Own Adventure - Data visualization in SAS Viya on Ask the Expert. 06-02-2020 05:11 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 33 -
My Liked Posts
Subject Likes Posted 1 03-07-2025 09:45 AM 3 12-05-2022 10:38 AM 1 01-04-2022 03:50 PM 1 10-01-2020 09:44 AM 1 10-01-2020 10:33 AM -
My Library Contributions
Subject Likes Author Latest Post 2
03-07-2025
09:45 AM
1 Like
Thank you Bill for making this enhancement suggestion for SAS Studio (version 5.2) on Analytics Pro (APro). This is a small request that will make a big difference. Viewing the properties of multiples files at the same time in a folder has been easy do to in SAS 9 Display Manager and Enterprise Guide. It should be the same in SAS Studio under APro. Many customers are moving from a SAS PC bundle on a desktop to APro on Viya and they could all benefit from this.
... View more
12-05-2022
10:38 AM
3 Likes
Yes, SAS can perform Bootstrap resampling and there are many ways to do so.
This blog entry describes best practices and techniques: The essential guide to bootstrapping in SAS
Regards,
Sylvain
... View more
12-01-2022
02:05 PM
Hello,
A SAS Enterprise Miner license is required to run the NEURAL procedure.
See this post: Solved: PROC NEURAL - SAS Support Communities
But you can directly call High-Performance Data Mining procedures such as HPNEURAL.
Also, in Proc IML you typically manipulate matrices in memory but when you are done,
you can save this matrix to a good old SAS data set. After you can use this SAS data set in Procedures, like HPNEURAL.
In Proc IML, you can use the CREATE and APPEND statements to write to SAS data set from a matrix that is in memory.
See this post: Writing data from a matrix to a SAS data set - The DO Loop
I hope this helps!
Sylvain
... View more
01-04-2022
03:50 PM
1 Like
Hello,
Can you please elaborate on "however, the program issues a program correction automatically to switching the DLM optoin to the DSD option".
Do you mean that in the code you submit you have the DLM option but in the Log you see that the option DSD was executed instead?
Also, would it be possible to share page no2 of your PDF, I would like to see the course code and prepared date for the course notes.
Thanks!
Sylvain
... View more
10-08-2020
10:28 AM
In ODS, you can control the image location (path) for ODS Graphics output and you can also specify the format of the image. Here's an example:
ods graphics
/ reset
width=5in /* width of the image = 5 inches */
imagename="fitplot"
imagefmt=png /* Format of the image */;
ods listing
gpath="path" /*path of the destination folder of the image */
image_dpi=200 /* Dot per inch resolution */
style=analysis /* ODS Style */;
... View more
10-08-2020
10:09 AM
Related to your question, in SAS 9.4M6 the ODS destination for Word has been added as a preproduction destination. This destination creates Microsoft Word documents (.docx).
"The ODS destination for Word standard format is richer than the intermediate text formats of ODS RTF reports. Although Microsoft Word reads the intermediate text format reports, some SAS reporting elements might get lost in translation because the intermediate formats of the RTF-generated report are not as rich as the standard formats required by the ODS destination for Word."
ods word file="pagexofy.docx"
ODS WORD Statement
... View more
10-01-2020
10:33 AM
1 Like
Very good point! Here is a reference:
"Collapsing Levels of Predictor Variables for Logistic Regression and Weight of Evidence Coding"
https://www.mwsug.org/proceedings/2012/SA/MWSUG-2012-SA03.pdf
... View more
10-01-2020
09:44 AM
1 Like
I had a quick look at your code and Substance Abuse is specified as a nominal explanatory variables because it is in your CLASS statement:
class subst_abuse (ref="0")
Then, in your MODEL statement, Substance Abuse is specified as a response variable:
model subst_abuse=
Your model is not correctly specified. You should remove Substance Abuse from the CLASS Statement and use it this way in the MODEL Statement:
model subst_abuse(event='0')=
Cheers!
Sylvain
... View more
09-29-2020
03:32 PM
With the sample source data you provided, it would look like this:
data table;
infile datalines missover;
input cohort date MONYY7. actual model;
format date MONYY7.;
datalines;
1 Mar2020 0.4 0.5
1 Apr2020 0.5 0.8
1 May2020 0.3 0.6
2 Mar2020 0.8 0.7
2 Apr2020 0.8 0.9
2 May2020 0.5 0.6
;
run;
proc sort data=table out=table_s;
by cohort date;
run;
proc transpose
data=table_s
out=table_s_t(rename=(col1=Measurement _NAME_=Source));
var actual model;
by cohort date;
run;
proc datasets library=work nolist;
modify table_s_t;
label Source='Source' Measurement="Measurement";
quit;
title "Panel of LineChart Actual vs Model by Cohort";
proc sgpanel data=table_s_t;
panelby cohort / spacing=5 novarname;
vline date / response=Measurement group=Source;
run;
... View more
09-29-2020
12:52 PM
Indeed, without seeing your data, it is hard to propose the right solution.
Having said that, before graphing, you need to have the data in the right form to support the type of graph you need. If you have a wide table, you can use Proc Transpose to create a narrow version of your data. This example for the documentation of Proc Transpose illustrates this:
Example 4: Transposing BY Groups
https://go.documentation.sas.com/?docsetId=proc&docsetTarget=p03avwj37ggkpkn1mzqzkmwvk1sl.htm&docsetVersion=9.4&locale=en
Once the data is in the right form (narrow table), you can use Proc SGPANEL.
Cheers!
Sylvain
options nodate pageno=1 linesize=80 pagesize=40; data fishdata; infile datalines missover; input Location & $10. Date date7. Length1 Weight1 Length2 Weight2 Length3 Weight3 Length4 Weight4; format date date7.; datalines; Cole Pond 2JUN95 31 .25 32 .3 32 .25 33 .3 Cole Pond 3JUL95 33 .32 34 .41 37 .48 32 .28 Cole Pond 4AUG95 29 .23 30 .25 34 .47 32 .3 Eagle Lake 2JUN95 32 .35 32 .25 33 .30 Eagle Lake 3JUL95 30 .20 36 .45 Eagle Lake 4AUG95 33 .30 33 .28 34 .42 ; run;
proc transpose data=fishdata out=fishlength(rename=(col1=Measurement)); var length1-length4; by location date; run;
proc sgpanel data=fishlength; panelby location / spacing=5 novarname; vline date / response=Measurement group=_NAME_; run;
... View more
09-28-2020
03:57 PM
Hello,
A simple strategy here would be to create and use User Defined Formats in SAS, to create your ranges.
Here is a reference:
Building and Using User Defined Formats
https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/236-29.pdf
Sylvain
... View more
06-02-2020
05:11 PM
2 Likes
Did you miss the Choose Your Own Adventure session on data visualization in SAS Viya? Not to worry, you can catch it on-demand at your leisure.
Watch the webinar
Your data has a lot to say and people in your organization are hungry for meaningful information. Satisfy them by taking advantage of SAS Visual Analytics to build interactive reports that engage the audience. In this session you will learn to:
- Access your data and load it in memory thru the SAS Cloud Analytic Services (CAS). - Prepare your data by correcting data inconsistencies, fixing data quality issues and identifying new data item that needs to be calculated. - Analyze your data to identify patterns, relationships and trends. - Develop interactive reports that help your audience to dig deeper into the data to gain insights.
Here are some highlighted questions from the Q&A segment held at the end for ease of reference.
Can the geo map object have data points displayed by a category (different color markers for different categories)?
Yes. The Color Role for a Geo Map can be a Measure or a Category. You can also use a Display Rule.
Hi, once a report is created and stored. Can it be executed via a scheduler on a repeated basis?
Yes, in VA, you can schedule the distribution of reports. Distributing reports automates the process of delivering updated content to report users.
Is there a sort of student version (like SAS Studio) anyone (sic) can actually access/logon and "practice"?
Yes, for educators and their students, we have a program called SAS Viya for Learners and Visual Analytics is part of the cloud-based software you can access.
How could we access a SAS cube?
You can't load a SAS Cube in memory in the CAS Server in SAS Viya.
What's your infrastructure that allows you to handle millions of records?
SAS Visual Analytics is designed to handle big data, with in-memory processing. Flexible deployment options let you easily scale your system as your data and analytic needs grow.
Can we modify (add, edit, delete) data directly in data table displayed in SAS VA, SAS Studio, etc.?
In SAS VA, the data you modify is modified in memory. The source data is untouched.
Why did you have to prepare the data in SAS EG before importing in SAS Viya? Couldn't this be done by some package in Viya?
Indeed, the data preparation can be done in SAS Data Studio on Viya. I used EG because I was more familiar with that tool.
Is there a video or instructions about using national aggregated census data when building reports?
Plot Your Custom Regions on SAS® Visual Analytics Geo Maps
The default geo provider, open street map doesn't recognize Canadian postal code, right? If so, how can I handle it?
You can use SAS Proc GEOCODE to assign the lat/long to your Canadian postal codes and then move the data to VA. Finding Locations Outside the U.S
Can we utilize this visual analytics software to create flow map and isochrone for transportation?
We have Esri Integration in SAS Visual Analytics. You can leverage that to analyze your data using routing and drive-time calculations
Is it possible to have a VA page where the outputs are from Proc SG Plot?
Yes. You can create a SAS Viya job that contains your SGPLOT code and place the execution URL of that job in a Web Content Object in your report. Also, you could use the SAS Graph Builder to create custom graph templates, which can then be used in SAS Visual Analytics reports. In your graph template, you can change the layout, add new graph elements, modify data roles, change options, and so on.
Do people who do not need to edit a report need a copy SAS Viya in order to access a report?
To view a report, all you need is a Web Browser (and authorized access) to access the SAS Visual Analytics reports.
Could you please say something about maintaining aspect ratio between the objects? The height width of objects changes when looking on a bigger screen vs a laptop and it is resizing every time.
The foundation of placing objects in your report is choosing a layout type. The layout type controls how objects are arranged. SAS Visual Analytics supports three layout types: Standard, Stacking and Precision. The precision container layout type gives you complete control over where your objects are located.
Can the report be printed or shared as PDF?
Yes, the report can be printed. When you print the report, a PDF is generated.
How do you work with data that is only aggregate data in SAS VA?
You can create report on the source data and you can also aggregate it further by creating an aggregated data source. In the report can be based on the original data and the aggregated data you created from it.
I know that there are many options for filters, but specifically, when you select a field to filter, it automatically uses the data to populate the options, can those be overwritten? I would like to see Michigan instead of MI when I choose the value in a filter.
SAS User-Defined Formats can be used with SAS Visual Analytics on Viya.
Can SAS Visual Analytics create a report in a different language? As an example, I created a report in English, but I need to have the same report, but in French.
SAS Visual Analytics enables you to localize (or translate) the labels, tooltips, and other descriptive text that is part of your report. You can export localizable text from your report so that you can apply one or more translations. You can translate your report into a new language without removing the text from SAS Visual Analytics.
How long is the ramp up time until someone is proficient enough to create reports in SAS VA like the one in the session?
A two days course and you are good to go! SAS Visual Analytics 1 for SAS Viya: Basics
... View more
Labels:
02-12-2013
01:39 PM
Hello, SAS/IML comes with an interface: SAS/IML Studio. It implements IMLPlus, an enhanced version of the SAS/IML programming language. In IMLPlus, you could use the DataObject.CreateFromExcelFile method in a program to read your MS Excel worksheet into SAS/IML Studio. Otherwise, if you have the SAS/Access to PC Files module, you can use Proc IMPORT to import your MS Excel worksheet into a SAS dataset. After, in SAS/IML, you can leverage the USE statement to open the dataset and make it current for input, then the READ statement to transfer the data from the dataset to a matrix. Once in a matrix, you can manipulate the elements as you see fit. Cheers! Sylvain
... View more