cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JosvanderVelden
yesterday
  • 679 Posts
  • 199 Likes Given
  • 82 Solutions
  • 206 Likes Received
About
I grew up and completed my studies in the Netherlands. I am a horticultural engineer and changed direction into the information technology area after working 6 years and a bit in South-America. I joined SAS in the Netherlands in 1996 and moved to the office in Portugal in 1999. At the moment I am responsible for the academic program in Portugal.

Re: NYC Mapping

by SAS Super FREQ in SAS Visual Analytics
‎08-28-2019 01:55 PM
1 Like
‎08-28-2019 01:55 PM
1 Like
The mapssas.counties dataset has the following information: You can find the county fips codes here: https://simple.wikipedia.org/wiki/List_of_counties_in_New_York   It may be useful to read this paper: http://support.sas.com/resources/papers/proceedings16/SAS3421-2016.pdf ... View more

Re: How do I import Excel data from a webpage?

by SAS Super FREQ in New SAS User
‎08-28-2019 01:30 PM
3 Likes
‎08-28-2019 01:30 PM
3 Likes
/* -------------------------------------------------------------------- PROC IMPORT reads the data directly from the Excel source file. The range is defined to start at row 9 because the data starts there -------------------------------------------------------------------- */ %let path=provide_your_path_here; PROC IMPORT    DATAFILE="&path.\us_total_hrs_emp.xlsx"    OUT=WORK.us_total_hrs_emp    REPLACE    DBMS=EXCEL;    RANGE="Employment$A9:P298";    GETNAMES=NO; RUN; /* -------------------------------------------------------------------- PROC DATASETS modifies the attributes of the columns within the output data set. The label statement uses the information from rows 6, 7 and 8 from the excel file. -------------------------------------------------------------------- */ PROC DATASETS LIBRARY=WORK NOLIST;    MODIFY us_total_hrs_emp;    FORMAT       F1 $CHAR6.       F2 F12.3       F3 F12.3       F4 F12.3       F5 F12.3       F6 F12.3       F7 F12.3       F8 F12.3       F9 F12.3       F10 F12.3       F11 F12.3       F12 F12.3       F13 F12.3       F14 F12.3       F15 F12.3       F16 F12.3 ;    INFORMAT       F1 $CHAR6.       F2 BEST12.       F3 BEST12.       F4 BEST12.       F5 BEST12.       F6 BEST12.       F7 BEST12.       F8 BEST12.       F9 BEST12.       F10 BEST12.       F11 BEST12.       F12 BEST12.       F13 BEST12.       F14 BEST12.       F15 BEST12.       F16 BEST12. ;    LABEL       F1 = "Sector - Worker coverage (millions of jobs)"       F2 = "Total U.S. Economy - all workers (millions of jobs)"       F3 = "General Government - [Total Govt. - Govt. Enterprises] - total employees (millions of jobs)"       F4 = "General Government - [Total Govt. - Govt. Enterprises] - federal employees (millions of jobs)"       F5 = 'General Government - [Total Govt. - Govt. Enterprises] - state & local employees (millions of jobs)'       F6 = "Armed Forces - personnel (millions of jobs)"       F7 = "Private Households - employees (millions of jobs)"       F8 = "Nonprofit Institutions - employees (millions of jobs)"       F9 = "Farm - all workers (millions of jobs)"       F10 = "Nonfarm Business sector - Total - all workers (millions of jobs)"       F11 = "Nonfarm Business sector - Private Nonfarm sector (excluding nonprofit institutions) - employees (millions of jobs)"       F12 = "Nonfarm Business sector - Government Enterprises - total employees (millions of jobs)"       F13 = "Nonfarm Business sector - Government Enterprises - federal employees (millions of jobs)"       F14 = 'Nonfarm Business sector - Government Enterprises - state & local employees (millions of jobs)'       F15 = "Nonfarm Business sector - Nonfarm non-employees - unpaid family workers (millions of jobs)"       F16 = "Nonfarm Business sector - Nonfarm non-employees - proprietors (millions of jobs)" ; QUIT;   Have a look at the following paper if you have time: https://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/Sukloff-ImportingExcel-Fall2015.pdf  ... View more

Re: Reading/Writing XML files from web to SAS

by SAS Super FREQ in New SAS User
‎08-28-2019 11:24 AM
‎08-28-2019 11:24 AM
You could read some documentation about sas and xml. Ex.: http://support.sas.com/rnd/base/xmlengine/, https://blogs.sas.com/content/sasdummy/2019/04/11/read-rss-feeds/, https://www.lexjansen.com/nesug/nesug10/ff/ff14.pdf, https://support.sas.com/resources/papers/proceedings15/SAS1871-2015.pdf & https://www.lexjansen.com/mwsug/2011/sas101/MWSUG-2011-S107.pdf You can download the latest version of the SAS XML Mapper here: https://support.sas.com/downloads/package.htm?pid=2288 ... View more

Re: how to keep evvery 3 rd observation of sex variable keep in small ...

by SAS Super FREQ in SAS Programming
‎08-27-2019 01:07 PM
3 Likes
‎08-27-2019 01:07 PM
3 Likes
This should also work: if mod(ceil( _N_ / 3 ), 2) = 0 then sex = lowcase(sex); ... View more

Re: Retrieve Information from Authorization tab of Groups and Roles in...

by SAS Super FREQ in SAS Programming
‎08-27-2019 12:43 PM
‎08-27-2019 12:43 PM
Have you seen the documentation on batch tools for metadata authorization: https://go.documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bisecag&docsetTarget=n09eorx5a5283xn11w12pncp0m0s.htm&locale=en?   Or the security report macros (in this case %mdsecds): https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=n0l1mpdt430djgn1bl1c3euei85w.htm&docsetVersion=9.4&locale=en ... View more

Re: Starting a new Sas University Edition session after installing the...

by SAS Super FREQ in New SAS User
‎08-26-2019 12:14 PM
1 Like
‎08-26-2019 12:14 PM
1 Like
Does the info from the following page help: https://communities.sas.com/t5/SAS-Analytics-U/SAS-University-Edition-Oracle-VirtualBox-Error-for-Mac-Users/m-p/421680 ... View more

Re: Latent Growth Curve Models with Proc Traj

by SAS Super FREQ in SAS Procedures
‎08-23-2019 12:05 PM
‎08-23-2019 12:05 PM
You can find the documentation for proc traj and contact information here: https://www.andrew.cmu.edu/user/bjones/index.htm ... View more

Re: Failed to save project

by SAS Super FREQ in SAS Enterprise Guide
‎08-22-2019 10:08 AM
1 Like
‎08-22-2019 10:08 AM
1 Like
A nice feature in EG 6.1 and SAS 9.4 is the ability to set an object server parameter on the workspace server to ensure firewalls do not disconnect inactive connected clients. The KEEPALIVE parameter sends an event packet to inactive clients on a regular interval to prevent disconnection by network firewalls. For more details on this setting see the following link. http://support.sas.com/documentation/cdl/en/biasag/63854/HTML/default/viewer.htm#n16001intelplatform00srvradm.htm You can set the keepalive=interval in metadata within SAS Management Console > Server Manager > SASApp (or whatever your server context is named) > SASApp - Logical Workspace Server > right-click on SASApp - Workspace Server > Properties > Options > 'Object server parameters:" field. Once completed you will need to restart the object spawner on the machine. If that does not solve the issue you should open a track with Technical Support (https://support.sas.com/en/technical-support/contact-sas.html) so they can provide the support you need. ... View more

Re: Failed to save project

by SAS Super FREQ in SAS Enterprise Guide
‎08-21-2019 12:34 PM
‎08-21-2019 12:34 PM
Do you use a server to run the SAS code or do you have SAS installed on the same machine as EG? If on the server you could have a connection issue when you leave the projects open for a long time. ... View more

Re: SAS Viya Kerberos Delegation

by SAS Super FREQ in SAS Viya
‎08-14-2019 12:00 PM
‎08-14-2019 12:00 PM
Have you seen the information here: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-3-4-Authentication-Overview/ta-p/523244 ... View more

Re: SAS VTA Text Parsing

by SAS Super FREQ in SAS Visual Analytics
‎08-14-2019 11:47 AM
‎08-14-2019 11:47 AM
The error message does not give much information. I guess the best way to proceed is to open a track with SAS technical support. https://support.sas.com/en/technical-support/contact-sas.html ... View more

Re: Configuring SASPY

by SAS Super FREQ in SAS Data Management
‎08-14-2019 11:30 AM
2 Likes
‎08-14-2019 11:30 AM
2 Likes
All of the documentation (installation, configuration, troubleshooting, et cetera) for SASpy is located at: https://github.com/sassoftware/saspy If you have questions, you can open an issue at https://github.com/sassoftware/saspy/issues ... View more

Re: Business Data Network: Is there a way to change a term's type

by SAS Super FREQ in SAS Data Management
‎08-09-2019 06:20 AM
‎08-09-2019 06:20 AM
Have you seen the administration documentation on managing terms? https://documentation.sas.com/?cdcId=dmbdncdc&cdcVersion=3.3&docsetId=dmbdnug&docsetTarget=n0wsm00olc4iv5n1dn8husran63n.htm&locale=en ... View more

Re: what kind of method is is using the Fastknn procedure?

by SAS Super FREQ in SAS Procedures
‎08-09-2019 06:04 AM
‎08-09-2019 06:04 AM
The fastknn procedure uses euclidean distance. It is mentioned in the documentation here: https://documentation.sas.com/?docsetId=casml&docsetTarget=casml_fastknn_overview.htm&docsetVersion=8.4&locale=en ... View more

Re: Unable to save! "TypeError: this.domNode is null"

by SAS Super FREQ in SAS Studio
‎08-09-2019 05:48 AM
‎08-09-2019 05:48 AM
Where are you trying to save your work? A shared folder or a personal folder? ... View more
Contact Me
Online Status
Offline
Date Last Visited
yesterday
Group Hubs for JosvanderVelden
View All
Likes given to
Likes from
Quick links