About Pankp

Pankp · ‎03-04-2020

Unfortunately, I could not replicate here but attachment should work to understand the exact need. Thanks

Pankp · ‎03-04-2020

Col1 Col2 Result1 Result2 Total A C xx xx xx B A xx xx xx C B xx xx xx Total xx xx xx

Pankp · ‎03-04-2020

Dear All, I am looking for solution to display Value across column inside the report (like Merge&center functionality in excel) using proc report . Please find attached file. I would like to display "Total" text across the columns. Any inputs will be appreciated. Thanks

Pankp · ‎01-11-2020

I tried implementing with Compute block but it didnt work as expected.Thanks a lot Reinhard, this worked for me.

Pankp · ‎01-10-2020

Dear All, I am looking for the solution to display "++" "--" in the column header as mentioned in the define statement. E.g. Define xyz/ "++"; Define abc/ "--"; But the output displayed are "++++++" "-------" respectively which is not my expectation. Please let me know if you have any solution Thanks

Pankp · ‎11-08-2019

This was bit misleading and incorrect. I should have simply done using proc format instead of call execute. Sorry for delayed in response but the issue got resolved last year itself. Thanks for your valuable response.

Pankp · ‎09-10-2018

data _null_; call execute ("proc format;"); call execute ("value $parm"); call execute ("'SPQTCFS' = 'Supine QTcF - Fridericia's#Correction Formula (msec)'"); call execute ("'SPHRMS' = 'Supine Summary (mean) Heart Rate#(beats/min)';") ; run; Dear All, How to define a format with single quote? E.g. In following case - call execute ("value $parm"); call execute ("'SPQTCFS' = 'Supine QTcF - Fridericia's Correction Formula (msec)'"); call execute ("'SPHRMS' = 'Supine Summary (mean) Heart Rate#(beats/min)';") I have to create a format for the given test code. But due to single quote I am not able to do it. I have tried using quoting functions but couldn't helped. In other case, I replaced Single quote with * in order to create the format but at the end I am expecting my label values to be displayed with Quote. Any solution on this! (SAS 9.4) If it is not clear enough let me know will provide some more details. Cheers! PankP

Pankp · ‎09-10-2018

Thanks s_lassen for the alternate solution. Cheers!

Pankp · ‎09-10-2018

Thanks Ballardw! it helps . Cheers!

Pankp · ‎07-05-2018

First of all, I see the problem is you are trying to execute Proc Sql within from %test macro within proc sql in following steps. You need to only consider select statement.Please check first.

Pankp · ‎11-28-2017

Hello All, I have data like - PT Visit1 Visit2 Visit3 Visit4 Visit5 1001 2 . 5 7 11 1002 5 7 . . 9 1003 . 5 6 11 8 1004 7 7 11 . . 1005 . 11 8 9 . I want to use Array to impute the missing value with the average of adjacent non-missing value. E.g. = for Pt. 1001 - for missing Visit2 I would expect the average of (Visit1+Visit3)/2 Same for Pt 1002 - for missing Visit3 and Visit 4, I would expect the average of (Visit2+Visit5)/2 . In later cases, I dont want imputation as I dont have adjacent values present completely. Does anyone know how to handle this case in array? Thanks, PankP

Online Status	Offline
Date Last Visited	‎03-04-2020 02:18 PM

Re: To display Text Value across columns using proc report

Re: To display Text Value across columns using proc report

To display Text Value across columns using proc report

Re: Displaying ++ , -- header of the output

Displaying ++ , -- header of the output

Re: How to handle and display Single quote in format?

How to handle and display Single quote in format?

Re: Imputing missing value with Average value in Array

Re: Imputing missing value with Average value in Array

Re: Validate if a variable exists and then select or implement a case ...

Re: Displaying ++ , -- header of the output

Re: How to handle and display Single quote in format?

Re: To display Text Value across columns using proc report

Re: To display Text Value across columns using proc report

To display Text Value across columns using proc report

Re: Displaying ++ , -- header of the output

Displaying ++ , -- header of the output

Re: How to handle and display Single quote in format?

How to handle and display Single quote in format?

Re: Imputing missing value with Average value in Array

Re: Imputing missing value with Average value in Array

Re: Validate if a variable exists and then select or implement a case ...

Imputing missing value with Average value in Array