About brophymj

ballardw · ‎08-19-2015

And this paper http://support.sas.com/resources/papers/proceedings12/161-2012.pdf

data_null__ · ‎08-12-2015

Looks like a common LOCF problem to me. data section; infile cards expandtabs; input section period :$2. count; cards; 1 Q1 1 1 Q2 . 1 Q3 . 1 Q4 2 1 Q5 . 2 Q1 . 2 Q2 1 2 Q3 . 3 Q1 1 ;;;; run; proc print; run; data section; update section(obs=0 keep=section) section; by section; if first.section then count=coalesce(count,0); output; run; proc print; run;

data_null__ · ‎08-05-2015

The problem is the default W(idth) of the user defined informat. Notice that the value for dev_cuml100 is the same as dev_cuml10. Add w value to devfactors that is ge to the length of longest flag1, 11 I think.

brophymj · ‎08-05-2015

I ended up using this but it's a bit messy... data average; input key $4.; datalines; mean run; %macro average; %do j = 0 %to 36; data test&j; set test; if qtr&j = . then delete; key = "mean"; keep key qtr&j; run; data test&j; set test&j(obs=10); run; proc summary data = test&j nway missing; class key; var qtr&j; output out = test&j(drop = _freq_ _type_) mean=; run; data average; merge average test&j; by key; run; %end; %mend; %average;

data_null__ · ‎08-05-2015

You have several things wrong starting the conversion of YYYYMM to date. I formatted STARTQTR but you may want to leave it integer(sas date). Consider the follow /* %let cutoff = 201506; %let averageperiod = 8; %let startqtr = %SYSFUNC(intnx('qtr', %input(%put(&cutoff*100+ 01,8.),yymmdd8.), -&averageperiod, 'same')); %put &startqtr; */ %let cutoff = 201506; /*To convert CUTOFF to SAS date you can use YYMMN informat*/ %let cutoffdate = %sysfunc(inputn(&cutoff,yymmn,6)); %put &=cutoffdate; %let averageperiod = 8; /*dont use quotes 'qtr' and 'same' are wrong*/ %let startqtr = %SYSFUNC(intnx(qtr, &cutoffdate, -&averageperiod, same),date9); %put &=startqtr; 32 /*To convert CUTOFF to SAS date you can use YYMMN informat*/ 33 %let cutoffdate = %sysfunc(inputn(&cutoff,yymmn,6)); 34 %put &=cutoffdate; CUTOFFDATE=20240 35 36 %let averageperiod = 8; 37 /*dont use quotes 'qtr' and 'same' are wrong*/ 38 %let startqtr = %SYSFUNC(intnx(qtr, &cutoffdate, -&averageperiod, same),date9); 39 %put &=startqtr; STARTQTR=01JUN2013

TomKari · ‎07-23-2015

1. As previously mentioned, use double quotes not single. 2. Is your SAS session possibly running on a server that can't see your K: drive? 3. Could the macro variables be local when they're created, not global? In the program that's failing, put in the line %put &month &year; to see if the variables have values.

Ksharp · ‎07-22-2015

Try this one : Code: Program.sas data have; infile cards truncover expandtabs; input VehNo Prem (start end) (: ddmmyy10.); format start end ddmmyy10.; cards; 1 500 1/1/10 1/3/10 1 0 2/3/10 1/6/10 1 0 2/6/10 30/9/10 1 0 1/10/10 31/12/10 2 600 1/1/09 1/3/09 2 700 1/1/09 1/3/09 2 0 2/3/09 20/9/09 2 0 21/9/09 30/9/09 ; data have; set have; by VehNo ; if first.VehNo or Prem ne 0 then n+1; run; data temp; set have; by n; if last.n; keep n end; run; data want; merge have temp(rename=(end=_end)); by n; retain _Prem _start; if first.n then do;_Prem =Prem ;_start=start;end; format _start _end ddmmyy10.; drop Prem n start end; run; Message was edited by: xia keshan Message was edited by: xia keshan

brophymj · ‎07-22-2015

The field start in the format table quart ranges from 01 to 12 (representing months of the year), the label in the table is the quarter. When I read values from this table in my dataset with "funny" months like 13 and 21, it still returns values. I would use merges only this is a very simplified example of what I'm doing so merge would appear to be the easier option. Thanks

Ksharp · ‎07-20-2015

Check notdigit() function .

Tom · ‎07-14-2015

You need to test if it is a number. Also what about values that look like numbers such as: 1.5 12E5

Astounding · ‎07-06-2015

In addition to KurtBremser's suggestion, also note that the 17.2 informat might be incorrect. You might be better off with an informat of 17. The difference occurs when the incoming data does not contain a decimal point. If the incoming data contains "12345", for example: "12345" with 17. informat ==> 12345 "12345" with 17.2 informat ==> 123.45 As an informat, 17.2 looks for decimal points and inserts them when the incoming string does not contain a decimal point. Finally, note that you may not be able to store exactly a numeric that contains 16 significant digits. You might lose a little precision from the end of the value. Good luck.

TomKari · ‎07-06-2015

Whenever I need to do this, I do it in Excel. Assuming that my variable name is in cell A1, and my length in B1, the formula =MID(A1&REPT(" ",20),1,20)&B1 should give you attractive output. Substitute whichever number looks good for the two instances of 20. Tom

BruceBrad · ‎07-06-2015

See the Contrast statement (or the Estimate statement if you only want to test one difference).

lvm · ‎07-02-2015

Looks like you will want to use PROC GENMOD. You probably should read a few documents about the procedure, working through the examples in the documentation, before you are ready for your particular problem. We can help better after you try something (with your example code). Here are some good resources: http://www2.sas.com/proceedings/sugi26/p264-26.pdf SAS/STAT(R) 13.1 User's Guide https://support.sas.com/rnd/app/stat/papers/logistic.pdf Generalized Linear Model in SAS: PROC GENMOD There are many more. You can try the introductory example in the GENMOD User's Guide.

ballardw · ‎05-26-2015

Be very careful with comments as the macro processor doesn't like the *line of code; comments. If you are using those change them to %* code; So the macro processor knows they are comments. Also, as much as practical, start small and add pieces. If your think your data is too large for this to run due to length of processing then make a smaller data set with the key elements and just a few records or use the system option OBS to set a number of records to process. Spelling counts.

Online Status	Offline
Date Last Visited	‎01-22-2020 12:34 PM

Re: Generating numbers randomly from a table

Re: Generating numbers randomly from a table

Re: Generating numbers randomly from a table

Generating numbers randomly from a table

Installing SAS on HP laptop

Re: Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Re: Simulating claims data using Poisson and Lognormal distributions

Re: converting matrix to two columns

Re: converting matrix to two columns

Nothing happening when running code

Name dataset as today's date

GLIM (Generalised Linear Iterative Model) in SAS

Re: Macros with conditions

Re: Similating coordinates and calculating various functions

Re: Retain statement questions

Re: format table confusion

Re: Average of last x entries in each column of a triangle

Re: intnx macro variable

Re: macro variables in location

Re: Retaining fields for unusual scenario

Re: Problem with format table

Re: anyalpha function

Re: Format

Re: Reading in fields from a txt file

Re: Pasting code from excel to sas

Re: Standard error of paramter differences

Re: GLM (GENMOD) in SAS

Re: Nothing happening when running code