About DavidDemeyer

DavidDemeyer · ‎05-13-2013

Tis fixed the problem: data test; F5='Friday, 10th January 1986'; worddate=left(scan(F5,2,',')); day=substr(worddate,1,2); monthname=scan(worddate,2, ' '); month=substr(monthname,1,3); year=scan(worddate,3,' '); date9=input(catt(day,month,year),date9.); run; proc print ; run;

DavidDemeyer · ‎05-07-2013

Hi everyone, Can I use a library in a PROC EXPORT? I want to create something like this: libname data pcfiles server="localhost" port=9621 path="\\ShareData\Education\SAS\files website\test.xlsx" SERVERUSER="david" SERVERPASS="david"; proc export data=WORK.REGISTRATIONS_CASECLEAN dbms=xlsx outfile=data label replace; run; Thanks, David

DavidDemeyer · ‎05-06-2013

Hi everyone, How can I read this type of dates in eGuide? Tuesday, 11th June 1985 Monday, 4th June 1990 Thx! David

DavidDemeyer · ‎04-29-2013

Hi everyone, I have 3 .csv-files on a FTP-server. How can I copy them to my local pc? Thanks, David

DavidDemeyer · ‎02-23-2013

Hi everyone, On all my reports in PDF (created in Enterprise Guide) there is a date and timestamp on the left top of the page. How can I remove the date and time from the reports? Thank you, David

DavidDemeyer · ‎02-19-2013

This was exactly what I was looking for! Thank you!

DavidDemeyer · ‎02-19-2013

Yes, 4 groups of variables. Maybe it's more clear with a little example: var1 var2 var3 var4 var5 var6 A 4 8 6 9 1 B 9 5 3 0 2 C 2 3 2 3 5 D 1 2 5 9 1 E 9 7 3 4 3 And the result should be a new dataset: var1 group1 group2 A 12 16 B 14 5 C 5 10 ... group1: sum(var1, var2) group2: sum(var3, var4, var5)

DavidDemeyer · ‎02-19-2013

Well for this step the proc summary is perfect. But in a later step I need the group them in 4 big groups... (and I don't know if that's possible with the proc summary)

DavidDemeyer · ‎02-19-2013

Hi everyone, I have a dataset with 90 variables, when I want to create a sum-function with the Query Builder I have to dubble-click on each variable. Is there a way to select all the variables faster? Ideal would be something like: sum(var2 [until] var90). Thanks, David

DavidDemeyer · ‎02-19-2013

Thanks a lot! I checked the log and it had reached the _ERROR_-limit!

DavidDemeyer · ‎02-15-2013

Hi everyone, We have an Excel file that contains 90.000 rows when we import the file in SAS EG 5.1 we only have 2.175. How can we solve this problem? Thank you, David

DavidDemeyer · ‎02-13-2013

Hi everyone, I'm quite new to SAS Enterprise Guide and I would like to clean up my data before analysis. I have a variable OnlineCustomer that uses 3 possible ways to be TRUE and 2 ways to be FALSE. null, -1 and 0 should be FALSE 1 or [the customerID] should be TRUE How can I convert al the values to the correct TRUE/FALSE-value so I can easily work with expressions? Thanks, David

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Excel-date format

Library in PROC EXPORT

Excel-date format

Copying files from an FTP server

Date and time on PDF Report

Re: Multiple variables in sum-function

Re: Multiple variables in sum-function

Re: Multiple variables in sum-function

Multiple variables in sum-function

Re: Excel Import in SAS EG

Re: Excel-date format

Library in PROC EXPORT

Excel-date format

Copying files from an FTP server

Date and time on PDF Report

Re: Multiple variables in sum-function

Re: Multiple variables in sum-function

Re: Multiple variables in sum-function

Multiple variables in sum-function

Re: Excel Import in SAS EG

Excel Import in SAS EG

Cleaning data