About s_manoj

s_manoj · ‎05-09-2021

Hi Ballardw, Thank you for your response, I have code in GTL so the reason i am asking for it, I wish I could share my GTL code but I I am not supposed to share hope you understand. I am using Layout Overlay type to draw hbar type plot, y axis tick (discrete type) are directly defined from a variable, not used specifically any tickvaluelist in GTL Hope above information would be suffice, if need anything more please let me know i will try to provide the same Many thanks Manoj

s_manoj · ‎10-10-2020

Hi @ballardw, Thanks for the solution and its really worked @Jim: Thank you very much for all the information you have provided and the way you have explained is very much clear and appreciated, also to be genuine I am not aware of proc options which heard here, Thanks a lot 🙂

Kurt_Bremser · ‎07-29-2020

I merged these identical questions.

ballardw · ‎07-11-2019

You might want to experiment with the option PAPERSIZE. You can use an options statement to change the default logical paper size such as: OPTIONS PAPERSIZE=(10in, 15in); which would set the output width to 10 inches and height to 15 inches. You can use other measurement units such as CM if you prefer. Likely you main issue is the height but without your data and exact code it is hard to tell. You would likely want to set the size back to Letter or A4 after the file is created to avoid issues with actual printed output options papersize=letter;

Astounding · ‎11-26-2018

As long as you haven't actually done the work yet, here is a preliminary step you can take to make sure we are pursuing the right path here. data temp; set have; len = length(var2); run; proc freq data=temp; tables var2 * len / missing list; run; This step will confirm whether the problem lies in the data or was introduced by many failed experiments in trying to get the program to work.

s_manoj · ‎11-12-2018

HI, data want; infile "path.txt"; input id v1 v2 v3 v4 @@; run;

s_manoj · ‎09-08-2018

Thank you @novinosrin its informative

ChrisHemedinger · ‎08-14-2018

I knew there had to be an OR angle to this! Thanks @RobPratt!

s_manoj · ‎08-14-2018

hi @Ksharp Thank you very much, you are very helpful.

s_lassen · ‎08-14-2018

Something like this may do: data want; set have; by number; if first.number then days_inactive=0; if upcase(status)='ACTIVE' then days_inactive=0; else days_inactive+1; run;

Kurt_Bremser · ‎08-11-2018

Try d1 = scan(drug1,-1);

hashman · ‎08-09-2018

@s_manoj: Your code runs a de facto Cartesian product reading every obs from one copy of NEW for every obs in another, and it doesn't even take advantage of the sorted order. Hence, it will scale extremely poorly as the input size grows. At nobs=100000, an efficient solution would run in under a second, yet your program would take good 30 minutes. And at nobs=1000000 (which is a very small data set by today's standards) it would take upward of 50 hours. The point= approach could be viable (though still slower than anything else) if you take advantage of the sorted order BY VISIT BMI and (a) use point= to read only the observations between the endpoints of the current BY group and (b) leave the point= loop as soon as the 10% condition is false. Paul D.

RW9 · ‎07-26-2018

You have warnings in that code though about converting text to numeric, actually I fell into the same trap as I forgot that ifn() will do the conversion regardless of the if part. I updated my code to avoid this.

thanikondharish · ‎07-26-2018

data s ; input id $ month sale ; cards ; 111 1 450 111 2 870 111 3 485 112 1 485 112 2 478 112 3 784 112 4 784 113 1 789 113 2 789 ; i want 4th month sale in every group but in some groups haven't 4th month sale.So first of all we need to get the average of 1th,2nd,3rd months and that value assign to 4th month and one more question first off all how to find which months are missed

s_manoj · ‎07-26-2018

Hi @Astounding, Yes I completely agree with you and that's true, it's better not to complicate code when a simple function can do. In recent days some of them were coming across these type logical questions by there superiors, so that might be the reason they were posting these type of questions, but up to they won't implement these type of complicated code in real scenarios. Thankyou

Re: Customizing Hbar Y ticks in Proc Template (GTL)

Customizing Hbar Y ticks in Proc Template (GTL)

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

ODS RTF coumns jumped to second page while re running proc report

Assign variable with missing valuesd

WARNING: The current page size is too small

Re: Creating new numeric variable based on values of character variabl...

Re: Sampling month

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

SAS Bowl I, Enterprise Guide Tips and Tricks

Re: ODS RTF coumns jumped to second page while re running proc report

Re: ODS RTF coumns jumped to second page while re running proc report

Re: Find out history status of particular column using BASE SAS Progra...

Re: how derive average and insert into a dataset

Re: SAS programming "golf": highest digit in a string of digits

Re: Customizing Hbar Y ticks in Proc Template (GTL)

Re: ODS RTF coumns jumped to second page while re running proc report

Re: Assign variable with missing valuesd??

Re: WARNING: The current page size is too small

Re: Creating new numeric variable based on values of character variabl...

Re: read in text file into sas

Re: informat to read year month date values

Re: SAS programming "golf": highest digit in a string of digits

Re: Extract concurrence dates

Re: Find out history status of particular column using BASE SAS Progra...

Re: Extract the word form the string

Re: how to selecet some ID out?

Re: extract numeric values and character values

Re: how derive average and insert into a dataset

Re: how to derive third word from a string without using scan function