About Keith

Keith · ‎05-29-2012

I would use an array to do this in SAS, something along the following lines. %let val=0.5; data want; input o7 p7 q7 r7 s7 t7; array vars{*} o7--t7; sumvars=0; do i=1 to dim(vars); sumvars+ifn(vars{i}>&val.,&val.+&val.*(vars{i}-&val.),vars{i}); end; drop i; cards; 0.5 0.3 0.2 0.6 0.1 2 ; run;

Keith · ‎05-28-2012

Looking at the data, you're right in thinking that you just need to output the last observation per gvkey and enddate group. data want; set analyst.main; by gvkey enddate; if last.enddate; run;

Keith · ‎05-24-2012

Use the standard format WORDS (or WORDF), the online documentation gives further details on these http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201455.htm

Keith · ‎05-23-2012

Thanks Hai.kuo, I guessed it may be something like that. I suppose it's similar to the old days of using ODS HTML to create an .xls file. With that method you had to click 'Save As' in Excel and choose Excel Workbook as the file type.

Keith · ‎05-23-2012

Thanks for your reply Spacetime. I am using Excel 2003, so the files are xls, not xlsx.

Keith · ‎05-23-2012

I'm transferring a SAS dataset to Excel using the ODS ExcelXP tagset. The spreadsheet created is 41MB, however if I open it, save it without making any changes, then close it, the file size reduces to 34MB. I assume this is due to some form of compression, but does anyone know if this can be done automatically as part of the ODS process?

Keith · ‎05-23-2012

The DIF function is what you need here. You put it in a data step, such as : data want; set have; by timestamp; time_dif=dif(timestamp); run; This assumes that the dataset is sorted in timestamp order and that you don't have any other BY variables (e.g. Task). I put the BY statement in so that the step would fail if the data wasn't sorted by timestamp. You have to be careful if you are using IF or WHERE statements with DIF and LAG, it's worth reading the following article which describes the pitfalls you may encounter and how to resolve them. www.nesug.org/proceedings/nesug07/cc/cc33.pdf

Keith · ‎05-17-2012

As far as I can see, the only way you can achieve this is with a picture format. The SAS online documentation gives an example of how to do this, it's near the bottom of the page (the NOZEROS format) http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473467.htm

Keith · ‎05-17-2012

Hi PaigeMiller, The OBS= dataset option can only be used against the input dataset, it has no effect when applied against an output dataset. I stated that I don't think it is possible to achieve the desired result, what @tmcrouse didn't say was why there is a requirement to have only 10 output observations. I merely stated that if data checking was the purpose then this could be achieved by limiting the number of input observations.

Keith · ‎05-17-2012

With SAS procedures, I believe you can only control the number of observations being read in (using OBS= with the option statement or as a dataset option), not the number being output. The only exception I know of is PROC SQL where you can use the OUTOBS= option. If you want to restrict the number to test the code, then set OBS= as below. PROC FREQ DATA = ReAdm.CHI (OBS=100)

Keith · ‎05-14-2012

One way is simply to add the CAT function to the SQL statement select cat(min(primzahl))

Keith · ‎04-18-2012

You can specify WEIGHT as an option in the VAR statement, so all you need to do is specify multiple VAR statements with a different WEIGHT variable for each. e.g. Proc Means data=HAVE NOPRINT; output out=WANT (drop=_TYPE_ _FREQ_) MEAN=; var Sep11_A Sep11_B Sep11_C Sep11_D Sep11_E / weight=Sep11_cnts; var Oct11_A Oct11_B Oct11_C Oct11_D Oct11_E / weight=Oct11_cnts; var Nov11_A Nov11_B Nov11_C Nov11_D Nov11_E / weight=Nov11_cnts; var Dec11_A Dec11_B Dec11_C Dec11_D Dec11_E / weight=Dec11_cnts; Run; Hopefully I have understood your question correctly. With regards to your 2nd question on copying and pasting SAS code, my method is to paste it into Word first and then copy and paste from there.

Keith · ‎03-30-2012

There are 2 ways I can think of to have text showing in a numeric field. Formatted value, you can create a format to display the number as text Special missing values (.A - .Z and ._).

Keith · ‎03-28-2012

Essentially it's a method that allows overlapping formats that can then be used in certain SAS procedures (SUMMARY, MEANS, TABULATE, REPORT). If you google 'SAS multilabel format' then there are plenty of papers that describe this in more detail and provide some good examples. The main things to note are : add the option 'multilabel' inside PROC FORMAT. add the option 'mlf' against the specific class variable inside the summary procedure. include the format statement inside the summary procedure.

Keith · ‎03-28-2012

I'm obviously under pressure from @Ksharp here.... However, @manojinpec is right in that how the criteria is defined will determine how best to proceed. If it is based on values of a single variable then multilabel format is a possibility. If it is based on multiple conditions then I would suggest a datastep that creates variables Type1 - Type10 and stores a running total of paid_amt in each, thereby requiring only 1 pass of the data.

Online Status	Offline
Date Last Visited	‎09-11-2015 12:18 PM

Re: Regarding If and then statement

Re: Merging 3 datasets

Re: Regading if and then

Re: Retaining Values in a Do Loop

Re: Using column wildcard (:) with retain statement in a datastep

Re: Select observations that meet a criteria

Re: Select observations that meet a criteria

Re: How to read Input data

Re: Output next,or next and next,or next and next and next,hahaha

Re: Re-Arrange Variables

Re: Find the missing values in the year

Re: Increment row based on change in record

Re: Dealing with 32 character restrictions

Re: calculating averages on floating period

Need help in matching the obs from dataset to excel

Re: How to change the name and format of PROC IMPORT variables

Re: can any one give a sas code for this 'xl formula'

Re: analyst following

Re: How to display amount in words ?

Re: Excel file size when using ODS

Re: Excel file size when using ODS

Excel file size when using ODS

Re: Simple Calculation Help

Re: Quick Format Question

Re: out obs help

Re: out obs help

Re: SELECT INTO numeric macro variable

Re: do weighted-average across multiple columns

Character data in Numaric variable.

proc sql summary alternative

proc sql summary alternative