About ChrisBrooks

ChrisBrooks · ‎05-08-2018

There's some code at this link showing how to do a moving average in data step http://support.sas.com/kb/25/027.html

ChrisBrooks · ‎05-07-2018

To merge data sets so that only common id values in both data sets are included in the output you can use the in= data set option which has the value of 1 if the data set contributes to the current observation or 0 if it doesn't. Here is an example data dataa; length id $1 x $5 y $6; infile datalines dlm=","; input id x y; datalines; A,CAT,BLUE B,DOG,GREEN C,BIRD,RED D,FISH,YELLOW ; run; data datab; length id $1 z $7; infile datalines dlm=","; input id z; datalines; A,USA B,UK C,GERMANY D,CANADA E,SPAIN F,ITALY ; run; data datac; merge dataa(in=a) datab(in=b); by id; if a and b; run;

ChrisBrooks · ‎05-01-2018

You could be slightly more succinct by simply using if 0; as in data cars; set sashelp.cars; run; proc ds2; data cars_out / overwrite=yes; method run(); set cars; if origin = 'USA' then if 0; end; enddata; run; quit; Since 0 is always false

ChrisBrooks · ‎04-25-2018

It looks like you're missing the appropriate tags in your data set variable - this works for me, for example data test; link = "<a href='https://www.sas.com/en_us/home.html'>SAS</a>"; run; ods html body="/folders/myshortcuts/Dropbox/test.html"; proc print data=test; run; ods html close;

ChrisBrooks · ‎04-24-2018

I'd recommend Proc Cport to create a transport file on the windows box and Proc Cimport to import that file into a SAS data set on the Unix box http://documentation.sas.com/?docsetId=proc&docsetTarget=n1c1z2uzw5ejpfn1cp87c1h4yfcf.htm&docsetVersion=9.4&locale=en

ChrisBrooks · ‎04-05-2018

It depends on how your date is stored - for example if it's a SAS datetime you can use the date part function http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0rttbu7w62xgzn1damccyuwpld8.htm&docsetVersion=9.4&locale=ja or if it's a character then the substr function http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0n08xougp40i5n1xw7njpcy0a2b.htm&docsetVersion=9.4&locale=ja If you tell us how it's stored we can give you a concrete example.

ChrisBrooks · ‎04-04-2018

No because in the first code block you only have one SET statement - the first time it executes it opens the data set and reads the first observation, the second time it reads the second observation etc. In the second code block you have three SET statements, each of which opens the data set and reads the first statement and so on. I'll try the link again http://support.sas.com/resources/papers/proceedings12/052-2012.pdf

ChrisBrooks · ‎04-04-2018

Just use a normal input statement without the @1 but add the firstobs=2 option to your infile statement http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1rill4udj0tfun1fvce3j401plo.htm&docsetVersion=9.4&locale=en

ChrisBrooks · ‎04-04-2018

What's happening in the second code block is that you effectively have three versions of the bank data set open so it will write the first observation three times, once for each version of the data set and so on. You sometimes see the same data set open more than once in a data step but it is a usually in the context of a DOW loop http://support.sas.com/resources/papers/proceedings12/052-2012.pdf (editor's note: removed trailing blank from link)

ChrisBrooks · ‎04-02-2018

There are two possibilities here: 1. You're running in SAS University Edition in which case you can't mount a folder like that; or 2. The noxcmd option is set on your system (possibly by an administrator http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#p0xtd57b40ehdfn1jyk8yxemfrtv.htm If it's 2 above you may need to get your system administrator to fix it.

ChrisBrooks · ‎03-31-2018

There's an error in the log - the proc Means outputs a data set called avg so replace data=sorted with data=avg in your Proc Sgplot code

ChrisBrooks · ‎03-31-2018

Surely the PROC SGPLOT outputs a plot?

ChrisBrooks · ‎03-31-2018

I would think you want an average of all the CEO salaries for each particular year. You need to first sort your data and then use Proc Means to get your averages - you haven't supplied sample data so here is some untested code to get you started. proc sort data=paper.Compustat_ExecuComp4 out=sorted; by year; run; proc means data=sorted; by year; var salary; output out=avg mean=avg_salary; run; proc sgplot data = avg; series x=year y=avg_salary; title ''; run;

ChrisBrooks · ‎03-29-2018

Have you tried Proc Transpose? I would have thought that would be more efficient than an SQL solution here.

ChrisBrooks · ‎03-29-2018

I must admit I've not used earliest before and I can't get it to work either. There are a couple of errors in your code though which won't help: 1. The variable height is misspelt in your varlist declaration; and 2. DS2 can't access the SASHELP library so you'll have to copy CLASS to another library before running the code It might be worth raising a track with SAS for this as I can't see why it won't work as described in the documentation

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