About r_behata

r_behata · ‎12-23-2021

data want; update have(obs=0) have; by member_id FY; output; run;

r_behata · ‎12-23-2021

data want; update have(obs=0) have; by id; output; run;

r_behata · ‎12-02-2021

Here is the Proc SQL Solution for it . Hope this helps : data have; input VAR1 $ VAR2 $ VAR3 $ VAR4 $ VAR5 $ DATE1:anydtdte. DATE2:anydtdte.; format date1 date2 mmddyys10.; infile cards truncover; cards; PERSON1 1 3 TYPE1 TYPE11 8/28/2012 2/23/2013 PERSON1 1 3 TYPE1 TYPE11 3/13/2013 3/16/2013 PERSON1 1 3 TYPE1 TYPE11 3/21/2013 4/12/2013 PERSON1 1 3 TYPE1 TYPE11 4/17/2013 10/22/2013 PERSON1 1 3 TYPE1 TYPE11 11/10/2013 11/26/2013 PERSON1 2 1 TYPE1 TYPE11 11/2/2019 11/18/2019 PERSON2 1 1 TYPE1 TYPE11 1/23/2010 7/21/2010 PERSON2 1 1 TYPE1 TYPE11 7/28/2010 8/12/2010 PERSON2 1 1 TYPE1 TYPE11 8/30/2010 9/28/2010 PERSON2 1 1 TYPE1 TYPE11 5/31/2014 11/14/2014 PERSON2 1 1 TYPE2 TYPE21 7/21/2010 10/8/2010 PERSON3 1 1 TYPE1 TYPE11 10/7/2020 10/15/2020 PERSON3 2 1 TYPE1 TYPE11 5/12/2015 5/21/2015 PERSON3 2 1 TYPE1 TYPE11 10/5/2016 11/14/2016 PERSON3 2 1 TYPE1 TYPE11 2/15/2017 3/7/2017 PERSON3 2 1 TYPE1 TYPE11 5/3/2017 10/30/2017 PERSON3 2 1 TYPE1 TYPE11 11/11/2017 12/1/2017 ; run; Proc SQl; Create table want as select VAR1, VAR2, VAR3, VAR4, VAR5, min(date1) as FIRST_DATE format=mmddyys10., max(date2) as LAST_DATE format=mmddyys10., max(date2)-min(date1) as DIFFERENCE from have group by 1,2,3,4,5; Quit;

r_behata · ‎12-02-2021

Not sure if I understood your requirement. But, for what it is worth - data want; array k[10] $ k1-k10; do _n_=1 by 1 until(last.id); set test; by id; k[_n_]=type; end; st=whichc('xin',of k1-k10); do _n_=1 to _n_ ; set test; if visit >= st then do; if type in ('xin','') then output; end; end; drop k: st; run;

r_behata · ‎11-05-2021

@FreelanceReinh @PeterClemmensen You guys are awesome! This has worked brilliantly. Can't thank you enough. Didn't knew that we could nest the %sysfunc in this manner.

r_behata · ‎11-05-2021

I have a list of sas dataset names (absolute paths) stored in a sas dataset. All I am trying to get the number of observations for each of the dataset by passing the name of the dataset as an argument to a custom function created using sas fcmp. While below is not the actual code, it is somewhat similar to this : %macro getobs; %let id=%sysfunc(open(&dsn)); %let no=%sysfunc(attrn(&id.,nobs)); %let rc=%sysfunc(close(&id.)); %mend; proc fcmp outlib = work.functions.func; function no_of_obs(dsn); no=run_macro('getobs',dsn); return (no); endsub; run; options cmplib=work.functions; data _null_; rc=no_of_obs("sashelp.class"); put rc=; run; I suspect there is a timing issue with the macro involved , but cannot wrap my head around it. Any help is appreciated. Here is the log : 29 30 options cmplib=work.functions; 31 32 data _null_; 33 rc=no_of_obs("sashelp.class"); 34 put rc=; 35 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 2 The SAS System 09:36 Friday, November 5, 2021 33:15 NOTE: Invalid numeric data, 'sashelp.class' , at line 33 column 15. 1 The SAS System 10:38 Friday, November 5, 2021 WARNING: Argument 1 to function ATTRN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. rc=0 rc=0 _ERROR_=1 _N_=1

r_behata · ‎07-30-2021

data have; input SUBJID $ OUTCOME :$20.; infile cards truncover; cards; 111 negative 111 111 222 positive 222 ; run; data want; update have(obs=0) have; by subjid; output; run;

r_behata · ‎07-12-2021

data have; input site $ subject visit & $ eval $; datalines; 01 111 Screen Y 01 111 Visit 1 N 01 111 Visit 2 Y 01 222 Screen Y 01 222 Visit 1 Y 01 222 Visit 2 Y 02 333 Screen Y 02 333 Visit 1 Y 02 333 Visit 2 N 02 444 Screen Y 02 444 Visit 1 Y 02 444 Visit 2 Y ; run; data want; merge have(in=a) have(where=(eval_='N') in=b rename=(eval=eval_)); if a; by site subject; eval=coalescec(eval_,eval); drop eval_; run;

r_behata · ‎07-12-2021

data have; input Name $ Sex $ Income :$20.; cards; Amy F 12635 Bob M 13729 Kim F 16438,18973 Zoe F 15307 run; data want; set have; do _n_=1 to countw(Income,','); new_Income=scan(Income,_n_,','); output; end; run;

r_behata · ‎06-22-2021

proc sql feedback; select put(dt,mmyys10.) as dt_, count(*) as cnt from tst group by dt_; quit;

r_behata · ‎06-15-2021

Awesome!! Thanks for pointing out the ODS ESCAPECHAR.

r_behata · ‎06-15-2021

I am trying to re-use an existing format which includes some Unicode Characters in it. However, The report which I intend to use this format (HTML Output) does not resolve the unicode characters in a desired format. The other legacy report that uses the same format is displaying the resolved values. Wondering if there is any option to enforce the unicode characters in the report. Here is the sample code : proc format; value $mtrcspc New_Acct_EOM_Purch_Amt="New Acct (^{unicode 2264}12 MOB) Month-end Purchase Sales (in MM)" New_Acct_EOC_Purch_Pct="% New Acct (^{unicode 2264}12 MOB) Month-end Sales"; run; data have; col1="New_Acct_EOM_Purch_Amt";output; col1="New_Acct_EOC_Purch_Pct";output; run; proc print data=have; var col1; format col1 $mtrcspc.; run; Thank You.

r_behata · ‎06-15-2021

data test ; input section dy ; datalines; 1 . 1 . 1 . 1 33 1 33 1 33 1 33 1 . 1 . 1 . 2 44 2 44 2 44 2 . 2 . 2 . 2 44 2 44 ; run; proc sort data=test; by section descending dy ; run; data want; update test(obs=0) test; by section; output; run;

r_behata · ‎06-13-2021

As far as I am aware PowerPivot is just an extension to the Excel. It mimics some standard features in some traditional BI offerings such as connections to external data sources, data modelling, custom calculated measures , charts etc. Could you be more specific about the "powerpivot files" . Are you trying to import the data model that you have created or the output you have generated using the custom measures ?

r_behata · ‎06-01-2021

One Way : data have; Name='a'; source1=' '; source2='A'; source3='B'; output; Name='b'; source1='A'; source2='B'; source3=''; output; Name='c'; source1='A'; source2=''; source3='B'; output; Name='d'; source1=''; source2='A'; source3='B'; output; run; data want; set have; array src[*] $ source:; do i=1 to dim(src); if ^ missing(src[i]) then do; FirstValue=vname(src[i]); leave; end; end; do j=hbound(src) to 1 by -1; if ^ missing(src[j]) then do; LastValue=vname(src[j]); leave; end; end; run;

Online Status	Offline
Date Last Visited	‎12-29-2025 04:52 PM

Re: Conversion of SAS Code to Python

Re: Count based on ID

Re: How to apply row level security on Page in SAS VA 7.5?

Re: RETAIN and impute

Re: How do I select one row based on max value with more than one grou...

Re: Keep all variables from dataset when using proc summary

Re: Calculating age from birthdate in YYYYMMDD format

Re: Proc report column header indentation

Re: Create a temp table in Postgres DB

Re: Perl regular expression to get number between PT and either M or H

Re: Remove every row for an ID if on every row for that ID all 3 varia...

Re: Extract tables

Re: PROC SQL - Include zeros in totals

Re: Long to wide

Re: SET data sets and retain values

Re: Support WITH clauses in SQL

Re: Saving Start and End Time to Dataset

Re: File locked by another user

Re: Calculating age from birthdate in YYYYMMDD format

Re: Perl regular expression to get number between PT and either M or H

Re: Dynamically replace missing character after last non missing chara...

Re: Calculation between rows

Re: Determine Date Difference Between Dates Over Groups

Re: How can I subset a dataset according to the value of a variable?

Re: Proc fcmp : Issue with run_macro resolution

Proc fcmp : Issue with run_macro resolution

Re: LOCF and retain statement

Re: change the value of a flag within a group

Re: Duplicate row of data when condition met and change the specific v...

Re: Proc Sql - group by formatted date value

Re: Unicode Characters being ignored in report output

Unicode Characters being ignored in report output

Re: Copy values to entire section

Re: SAS XLSX Engine and PowerPivot Questions

Re: Finding the first and last values