About ChrisBrooks

ChrisBrooks · ‎12-02-2018

You're missing an INPUT statement listing the variables - add that and you should be fine. You can find the full syntax here -> https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0oaql83drile0n141pdacojq97s.htm&docsetVersion=9.4&locale=en

ChrisBrooks · ‎12-01-2018

To reference multiple variables with the same prefix and a numeric suffix you can use a hyphen as in the example below. You can also use the find function to search a string for a substring. Here's an example using the SASHELP.CARS data set data out; length sf1-sf3 $5; set sashelp.cars; if find(model,"convertible") then sf1=1; else sf1=0; if find(model,"manual") then sf2=1; else sf2=0; if find(model,"auto") then sf3=1; else sf3=0; run;

ChrisBrooks · ‎10-31-2018

No, you only use %sysfunc with functions, not procedures. Without seeing the log it's difficult to know exactly where your problem lies. If you still want to try this method could you post a copy of your log.

ChrisBrooks · ‎10-30-2018

Your best bet is probably to put the Proc call inside a macro with a %do %until construct. You can see an example of %do %until here http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a000543770.htm

ChrisBrooks · ‎10-08-2018

The htmlencode function is a data step function. If you want this to work in open (or macro) code you need to wrap it inside a %sysfunc call e.g. %Global x1 x2; %let x1 = 'not a <tag>'; %Put &x1; %let x2 = %sysfunc(htmldecode(&x1)); %put &x2; You can find more details on how to use %sysfunc here -> http://support.sas.com/documentation/cdl/en/mcrolref/62978/HTML/default/viewer.htm#p1o13d7wb2zfcnn19s5ssl2zdxvi.htm

ChrisBrooks · ‎09-04-2018

This error usually occurs when the data set is damaged. Your best bet is to restore it from a known good backup or recreate it.

ChrisBrooks · ‎08-30-2018

You might want to try contacting the authors of the paper (their email addresses are at the end of the paper). It's a five year old paper so they may have changed or no longer be around but if they are then I would expect they would be happy to provide any further details they can. I know from personal experience that paper authors are usually delighted to find their work is useful to other people.

ChrisBrooks · ‎08-29-2018

You can do this without a loop - just assign a library to the folder and run something like this proc contents data=sashelp._all_ out=alltables; run;

ChrisBrooks · ‎08-27-2018

They do - the first allows duplicate index values and the second doesn't e.g. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 data class; 74 set sashelp.class; 75 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.CLASS has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 76 77 78 proc sql; 79 create index sex on class(sex); NOTE: Simple index sex has been defined. 80 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 81 82 83 data class; 84 set sashelp.class; 85 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.CLASS has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 86 87 proc sql; 88 create unique index sex on class(sex); ERROR: Duplicate values not allowed on index Sex for file CLASS. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 89 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 90 91 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 104

ChrisBrooks · ‎08-27-2018

If you're using WPS you should really ask them rather than use a SAS forum given the history between the two companies https://en.wikipedia.org/wiki/SAS_Institute_Inc_v_World_Programming_Ltd

ChrisBrooks · ‎08-27-2018

You are including a file name (cars.dta) in your libname statement when it should only contain a folder name. If you change your libname statement to: libname libsas '/folders/myfolders'; Your code will work

ChrisBrooks · ‎07-26-2018

Try -memsize=max in the SAS invocation from the command line (this gives SAS as much memory as it needs subject to what is available on your machine).

ChrisBrooks · ‎07-19-2018

@ballardw I suspect the problem lies with the port attribute of the serverdef object which is supplied by SAS and not the variable @Andy_D is using to hold the port number.

ChrisBrooks · ‎07-19-2018

I don't have access to a machine with SAS IOM installed at the moment so I can't check any of this but I think, with a little educated guesswork, I know what is happening here. It may be a little bit esoteric but bear with me...... Firstly some definitions: A 16 bit unsigned integer can contain values 0 through 65,535; A 16 bit signed integer can contain values -32,768 through 32,767; A 32 bit unsigned integer can contain values 0 through 4,294,967,295; and A 32 bit signed integer can contain values -2,147,483,648 through 2,147,483,647 Port numbers range from 0 to 65535 with numbers 1 to 1024 reserved. I suspect that the port attribute of the serverdef object supplied by SAS is actually a 16 bit signed integer which is why you cannot use port numbers greater than 32767 (in my experience there are usually plenty of ports available within this limit). There are two ways to overcome this: Persuade SAS to change the port attribute to an unsigned 16 bit integer (you can't have negative port numbers) - however I suspect you will have little luck with that; or Change the port you are using so that it is within the 32767 limit for a signed 16 bit integer Is there any reason you can't use a port within that limit as I would be amazed to find there were none free?

ChrisBrooks · ‎07-17-2018

That's a very good question. I've tried to create an FCMP function and then a DS2 FCMP package using that function and while the original function works fine in Base SAS it fails when called through the DS2 FCMP function with an error : ERROR: Cannot find a library containing subroutine SOUNDEX. This leads me to believe that functions not supported in DS2 can't be called even when wrapped inside an FCMP function. For the record here's my code complete with tests proc fcmp outlib=work.funcs; function mysoundex(name $) $; length retval $4; put name=; retval=soundex(name); put retval=; return(retval); endsub; run; options cmplib=work.funcs; data _null_; length rc $4; set sashelp.class; rc=mysoundex(name); put rc=; run; proc ds2; package sndx / overwrite=yes language='fcmp' table='work.funcs'; run; quit; data class; set sashelp.class; run; proc ds2; data _null_; dcl package sndx myval(); dcl char(4) retval; method run(); set class; retval=myval.mysoundex(name); put retval=; end; run; quit; I would encourage you to log a support track with SAS which you can do here -> https://support.sas.com/ctx/supportform/createForm in case they have any suggestions...

Online Status	Offline
Date Last Visited	‎10-08-2024 11:59 PM