About DeepakSwain

DeepakSwain · ‎10-19-2018

Hi pink_poodle, Is there a way to put desired format with P50 and P95 in proc means statement.

DeepakSwain · ‎10-19-2018

Hi there, I am trying to get mean, median and P95 using Proc means in a desired format such as mean_pulse as integer and P50 and P95 with one decimal. Can some body help me to modify my code to get the desired output. data test; input id pulse; cards; 1 2 4 5 7 8 1 3 4 5 7 8 1 2 4 5 7 9 1 2 4 7 7 8 1 5 4 7 7 8 ; run; proc sort data =test; by id; run; proc means data =test noprint; var pulse; by id ; output out=want (drop= _type_ _freq_) mean=mean_pulse p50=median_pulse p95=pctile_95; run; At present, I am getting median and P95 as whole number but I want with a decimal. Regards,

DeepakSwain · ‎10-15-2018

Hi Ballardw, The suggested advice is great. Only limitation with this to provide a list of special characters of interest to flag. I am trying to use ANYPUNCT function but unable to apply my exclusion list i.e. dot, aposytrophe, hypen and comma. Can you kindly help me if feasible to use anypunct function so the code may be generalized. Once again thank you for your kind reply. Regards,

DeepakSwain · ‎10-15-2018

Hi there, I need your kind help to detect one column having any special characters with or without dot, apostrophe, hyphen and comma. If it contains only dot, apostrophe, hyphen or comma, I don't want to flag. data have; input name $; datalines; abc def_ def-ghi def's def. def@ghi.ijk def-ghi&ijk def% ; run; I want to flag the following: def_ def@ghi.ijk def-ghi&ijk def% Thank you in advance for your kind reply. Regards,

DeepakSwain · ‎07-09-2018

Hi there, I am trying to select some records from my master table (e.g. table_all) having all records excluding all records available in table_Y and table_P. I am getting the error message: Subquery evaluated to more than one row. data table_all; input id status $ ; datalines; 101 F 102 C 103 F 104 F 104 C 105 F 106 F 106 C 108 F 109 C ; run; data table_Y; input id Consult $ ; datalines; 101 Y 104 Y ; run; data table_P; input id type $; datalines; 104 P 106 P 109 P ; run; data table_F_Not_Y_Not_P; input id status $ ; datalines; 103 F 105 F 108 F ; run; proc sql; create table want as select * from table_all where id ne (select id from table_Y) and id ne (select id from table_P); quit; /*WANT=table_F_Not_Y_Not_P*/ Thanks in advance for your kind reply to overcome the error message.

DeepakSwain · ‎06-21-2018

Hi Paige Miller, Just like kappa statistics with 95% CI can be obtained using proc freq with AGREE. I was looking for F1 score. Can you suggest something. With regards,

DeepakSwain · ‎06-21-2018

Hi PaigeMiller, Thank you for the reply. I mean to say F1 score which is the harmonic mean of precision and sensitivity (i.e. 2TP/(2TP+FP+FN). TP=true positive, FP=false positive, TN=true negative, FN=false negative With regards,

DeepakSwain · ‎06-21-2018

Hi there, I am having a 2X2 table. I want to calculate f score with 95% confidence interval. Can anybody suggest me how to proceed. /*CREATING TABLE 2 BY 2 TABLE */ data study; input obs1 obs2 count; datalines; 1 1 331 1 0 13 0 1 2 0 0 654 ; run; Thank you in advance for your kind reply. Regards,

DeepakSwain · ‎06-06-2018

Hi there, I am working a dataset having more than 3 million records. Following use of break tab couple of times, I noticed that log doesn't update. I believe following restart of session, I will overcome the problem easily. As I am having number of temporary tables in WORK, I don't want to restart the session. Is there any way to overcome the issue without restarting SAS session. Thanks in advance for your kind reply. Regards,

DeepakSwain · ‎03-21-2018

Thanks a lot.

DeepakSwain · ‎03-21-2018

Hi there, I have a data element having values between multiples pipes. I want to extract the value contained between 7th and 8th pipe of each record. data have; id=101; report="|1||S17-13284|11529-5|||20170602|||54295|"; output; id=102; report="|1||S17-13285|11529-5|ABC||20170603|||54296|"; output; id=103; report="CDE|1||S17-13286|11529-5|||20170604|||54297|"; output; run; data want; id=101; report_date="20170602"; output; id=102; report_date="20170603"; output; id=103; report_date="20170604"; output; run; /*sascode tried*/ data got ; set have; length report report_date $50; report_date=scan(report,7,"|"); run; Thank you in advance for your kind reply. With regards,

DeepakSwain · ‎03-09-2018

I am trying to extract part of a string available between 3rd and 4th pipe following a key word "ABC". Can anybody please assist me to move forward. data HAVE; length id $3 comment $50 ; input id comment $ ; datalines; 101 ABC|X01|X02|2001|DEF|X01|X02 102 X02|ABC|X001|X002|2002|DEF 103 X04|X02|ABC|X0001|X0002|2003|DEF|X01|X02 104 X05|X02|X02|ABC|X00001|X00002|2004|DEF 105 X02|ABC|X01|X02|2005|DEF ; RUN; data WANT; length id $3 comment $50 ; input id comment $ ; datalines; 101 2001 102 2002 103 2003 104 2004 105 2005 ; RUN; Thank you in advance for your kind guidance.

DeepakSwain · ‎03-09-2018

Hi Ksharp, can you kindly help me to extend this code to count the position of PIPE from ABC. As ABC segment may be preceded by other string. My target is to extract content available between 3rd and 4th pipe from the term ABC. data HAVE; length id $3 comment $50 ; input id comment $ ; datalines; 101 X01|X02|ABC|X01|X02|2001|DEF 102 X01|X02|X02|ABC|X001|X002|2002|DEF 103 X01|X02|ABC|X0001|X0002|2003|DEF 104 X01|X02|X02|ABC|X00001|X00002|2004|DEF 105 X01|X02|ABC|X01|X02|2005|DEF ; RUN; data WANT; length id $3 comment $50 ; input id comment $ ; datalines; 101 2001 102 2002 103 2003 104 2004 105 2005 ; RUN; Once again thanks for your kind response.

DeepakSwain · ‎03-09-2018

Hi there, I am trying to extract part of a string available between 3rd and 4th pipe. Can anybody please assist me to move forward. data HAVE; length id $3 comment $50 ; input id comment $ ; datalines; 101 ABC|X01|X02|2001|DEF 102 ABC|X001|X002|2002|DEF 103 ABC|X0001|X0002|2003|DEF 104 ABC|X00001|X00002|2004|DEF 105 ABC|X01|X02|2005|DEF ; RUN; data WANT; length id $3 comment $50 ; input id comment $ ; datalines; 101 2001 102 2002 103 2003 104 2004 105 2005 ; RUN; Thank you in advance for your kind guidance. Regards,

DeepakSwain · ‎02-27-2018

proc options group=memory; run; LOG shows: SAS (r) Proprietary Software Release 9.4 TS1M3 Group=MEMORY SORTSIZE=1073741824 Specifies the amount of memory that is available to the SORT procedure. SUMSIZE=0 Specifies a limit on the amount of memory that is available for data summarization procedures when class variables are active. MAXMEMQUERY=0 Specifies the maximum amount of memory that is allocated for procedures. MEMBLKSZ=16777216 Specifies the memory block size for Windows memory-based libraries. MEMMAXSZ=2147483648 Specifies the maximum amount of memory to allocate for using memory-based libraries. LOADMEMSIZE=0 Specifies a suggested amount of memory that is needed for executable programs loaded by SAS. MEMSIZE=107213322240 Specifies the limit on the amount of virtual memory that can be used during a SAS session. REALMEMSIZE=0 Specifies the amount of real memory SAS can expect to allocate. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

Calculate number of days between 2 date variables

How to export a sas data having double quote in csv format

Re: SAS Date in YYYYMMDDHHMMSS format

Re: SAS Date in YYYYMMDDHHMMSS format

SAS Date in YYYYMMDDHHMMSS format

Subset of data with desired number of records having specific categori...

Re: Creating wide table to narrow table having two groups of data elem...

Creating wide table to narrow table having two groups of data elements

Re: Unable to resolve a macro variable within a quote

Unable to resolve a macro variable within a quote

Re: Calculate number of days between 2 date variables

Re: Creating wide table to narrow table having two groups of data elem...

Re: Splitting one row to multiple rows and assigning separate identifi...

Re: Splitting one row to multiple rows and assigning separate identifi...

Re: Splitting one row to multiple rows and assigning separate identifi...

Control number of Output following Proc sort

Re: Conditional replacement of missing value with adjacent similar tra...

Re: SAS Date Function

Re: Using Proc means to get values in desired format

Using Proc means to get values in desired format

Re: Flag column having special character except dot, apostrophe, hyphe...

Flag column having special character except dot, apostrophe, hyphen an...

Subquery evaluated to more than one row

Re: How to calculate f score with 95% confidence interval using Base S...

Re: How to calculate f score with 95% confidence interval using Base S...

How to calculate f score with 95% confidence interval using Base SAS

SAS Log doesn't update after repeated use of break function in Base SA...

Re: Extract content between pipes

Extract content between pipes

Extract part of a string in reference to a Key word and positional de...

Re: Extract part of a string having positional delimiter

Extract part of a string having positional delimiter

Re: Hash object with Insufficient memory to execute data step program