cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ChrisWard
‎08-10-2018
  • 12 Posts
  • 3 Likes Given
  • 2 Solutions
  • 6 Likes Received

Re: Exit a SAS script based on a condition

by SAS Employee in SAS Programming
‎10-21-2015 09:16 AM
‎10-21-2015 09:16 AM
There are various ways to check the obs, the previous comment contains one.  To exit a sas script the abort statement is probably an option for you.   https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000230210.htm ... View more

Re: Macro Loop for unknown Colums Count

by SAS Employee in SAS Programming
‎09-16-2015 12:52 PM
‎09-16-2015 12:52 PM
I'm assuming the vars to be analyzed are Data1-Datax (you had Data Data2.)   With that assumption the following code will do what you need, I beieve.   data results; length ColumnName $32 PowerStat 8 ; stop; run; %macro iterate(dataCols=1); %do dataCol = 1 %to &dataCols.; proc sort data=work.defaultCok(rename=(data&DataCol.=data)) out=work.defaultCok2; by descending Data; run; data work.cumulative; set work.defaultCok2; NonDefault=1-Default; by data notsorted; if first.default then defaultRate=0; defaultRate+default; if first.default then NondefaultRate=0; NondefaultRate+Nondefault; run; proc sql; create table work.cumulative2 as select default,data,NonDefault,defaultRate,NondefaultRate,sum(default) as TotalDefault,sum(NonDefault) as TotalNonDefault from work.cumulative; quit; data PowerStat; set work.cumulative2 END=lastN; ResultD=defaultRate/TotalDefault; ResultND=NondefaultRate/TotalNonDefault; Retain Sonuc 0 MaxSonuc 0; Area=(ResultND+Lag(ResultND))/2*(ResultD-Lag(ResultD)); IF missing(Area)=1 then Area2=0; Else Area2=Area; Sonuc=Sonuc+Area2; if Sonuc>maxSOnuc then maxsonuc=sonuc; if lastN then do; PowerStat=(MaxSonuc-0.5)*2; ABSResult=ABS(PowerStat); varName="data&datacol."; output; keep absresult varName; end; run; data results; set results Powerstat(rename=(absresult=Powerstat varName=ColumnName)); run; %end; %mend; %iterate(dataCols=3) * number of DataX columns ; ... View more

Re: sas enumeration variable for time group

by SAS Employee in SAS Programming
‎09-15-2015 09:09 AM
‎09-15-2015 09:09 AM
If the IDs aren't sorted, but are grouped together this would also work.   data new2; set new; if id^=lag(id) then time=0; if v1^=lag(v1) then time+1; run; ... View more

Re: sas enumeration variable for time group

by SAS Employee in SAS Programming
‎09-15-2015 08:56 AM
‎09-15-2015 08:56 AM
Assuming the data is sorted by id the following code works.   data new; * read test data ; input id $14. v1 v2 v3 old_time; cards; 20130610111823 195 0.827831 13.1 1 20130610111823 195 0.765397 13.1 1 20130610111823 195 0.755809 13.1 1 20130610111823 195 0.572855 13.1 1 20130610111823 195 0.734431 13.1 1 20130610111823 217 0.845952 12.7 2 20130610111823 217 0.79176 12.7 2 20130610111823 217 0.767398 12.7 2 20130610111823 217 0.745255 12.7 2 20130610111823 217 0.92218 12.7 2 20130610111823 223 0.747259 13.2 3 20130610111823 223 0.722813 13.2 3 20130610111823 223 0.733111 13.2 3 20130610111823 223 0.795692 13.2 3 20130610111823 223 0.863481 13.2 3 20130610111823 260 0.759839 12.6 4 20130610111823 260 0.72373 12.6 4 20130610111823 260 0.74912 12.6 4 20130610111823 260 0.71509 12.6 4 20130610111823 260 0.816424 12.6 4 20130612092329 254 0.593263 11.1 5 20130612092329 254 0.592495 11.1 5 20130612092329 257 0.578249 7.9 6 20130612092329 257 0.980644 7.9 6 20130612092329 258 0.818048 11 7 20130612092329 258 0.885162 11 7 20130612092329 258 0.793767 11 7 20130612092329 258 0.362111 11.7 7 20130612092329 258 0.539453 11.7 7 20130612092329 258 0.659541 11.9 7 ;;; run ;;; data new2; * create new data ; set new; by id; if first.id then time=0; if id^=lag(id) or v1^=lag(v1) then time+1; run; ... View more

Re: Macro Loop for 2000 Columns

by SAS Employee in SAS Programming
‎09-15-2015 08:20 AM
‎09-15-2015 08:20 AM
This code will create a table with one row for each column and the %age of records with a >0 value;  any splitting of records with >70% etc can then easily be accomplished.     %let colCnt=2000; data out_data(keep=var pcntage); format pcntage percent7.2; array t t1-t&colCnt.; retain t1-t&colCnt. 0; * retain some total counts; set x end = eof; array q q1-q&colCnt.; do i=1 to &colcnt; t(i)=t(i)+(q(i)>0); * add each non-missing to the total count ; end; if eof then do i=1 to &colcnt.; var='q'||strip(put(i,best.)); * create column name ; pcntage=t(i)/_n_; * calculate %age ; output; * output one row for each of the analyzed columns; end; run;     ... View more

Re: Missing data

by SAS Employee in SAS Data Management
‎09-09-2015 02:49 PM
‎09-09-2015 02:49 PM
How many missing from cohort2? proc means data = cohort2 nmiss; var netcst1a; run; ... View more

Re: Missing data

by SAS Employee in SAS Data Management
‎09-09-2015 01:44 PM
‎09-09-2015 01:44 PM
Is netcst1 on cohort2? if not how is netcst1 calculated for observations coming from cohort2? ... View more

Re: numeric to char

by SAS Employee in SAS Programming
‎09-09-2015 01:06 PM
‎09-09-2015 01:06 PM
All macro variables are stored as strings.  What behavour (error message etc) are you seeing that makes it numeric. http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a002293823.htm   You can see from this log that if we try to store a numeric in a macro var it is converted to char by SAS.   1 data null; 2 call symput('currmonS',put(date(),yymmn6.)); 3 call symput('currmonN',date()); 4 run; NOTE: Numeric values have been converted to character values at the places given by: (Line) : (Column). 3:28 NOTE: The data set WORK.NULL has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds . ... View more

Re: SAS Dates

by SAS Employee in SAS Programming
‎03-14-2013 10:12 AM
6 Likes
‎03-14-2013 10:12 AM
6 Likes
There will be many ways to do this, but here is one suggestion. %let date = 2012-11; /* we could use in informat or break out the separate date components, as below */ %let y=%substr(%left(&date),1,4); %let m=%substr(%left(&date),6,2); %put y=&y m=&m; /* create a numerical version of the date */ %let mydateN = %sysfunc(mdy(&m.,1,&y.)); /* create a Character (formated) version of the date */ %let mydateF= %sysfunc(putn(&mydateN.,yymmd7.)); /* decrease date and create a new Character (formated) version of the date */ %let me = %sysfunc(intnx(month,&mydateN.,-1),yymmd7.); %put  &date; %put MyDate (Numerical) &mydateN; %put MyDate (Formated) &mydateF; %put &me; ... View more

Re: Hardcode Expiration Date

by SAS Employee in ODS and Base Reporting
‎03-14-2013 09:22 AM
‎03-14-2013 09:22 AM
You would also need to change the put statement to non macro. data lesions;   .....             else do;                   put 'WARNING: There is hardcoding in this step that has expired!  Make sure the data has been updated.';             end; run; Also, on the first example you would need to make SAS treat the %SYSDATE as a date also so you would need the 'd'       if subjid = "101-1002" and "&sysdate"d <= "01MAY2005"d then do; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-10-2018 09:13 AM
Likes given to
View All
Quick links