About vandhan

vandhan · ‎09-03-2019

I am using proc template to produce line plot and showing Y axis values on Log scale. two issues i have. 1. Can I add manual Values to log scale? Scale starting from 0. I want -1 and -2 on it and want to put different label for it. 2. I want to change grouped data (usually Treatment but in my case it is Patient IDs). I want to put for few subject one color and for few subjects other color. I have flag which divides subjects into 2 groups. hence I want only 2 colors. Please help. attached the code in the PDF file.

vandhan · ‎08-15-2019

Thanks for your reply. I have I more condition to be added. If Visit is ‘Unsch’ then that record should be deleted if Days gap is less than 10. Hence here 4rd and 6th record should be deleted Can you add the condition also please. I have added one more below for ‘Unsch’ visit data have; input id Visit & $10. date :date9. response $; format date date9.; cards; 01 Base 02APR2019 N 01 Vis 1 18APR2019 N 01 Vis 2 20APR2019 N 01 Unsch 22APR2019 Y 01 Vis 2 04MAY2019 Y 01 Vis 3 16MAY2019 N ;

vandhan · ‎08-14-2019

id----Visit --------date------- response 01 Base 02APR2019 N 01 Vis 1 18APR2019 N 01 Vis 1 20APR2019 N 01 Vis 2 04MAY2019 Y 01 Vis 3 16MAY2019 N 3rd and 5th records I want to remove. 3rd - since difference with previous visit is just 2 days. I want more than 10 days gap between visits. 5th - Response is N after Y response. I want to remove all records which occured after Y response for particular subject.

vandhan · ‎08-14-2019

id----Visit --------date------- response 01 Base 02APR2019 N 01 Vis 1 18APR2019 N 01 Vis 1 20APR2019 N 01 Vis 2 04MAY2019 Y 01 Vis 3 16MAY2019 N 3rd and 5th records I want to remove. 3rd - since difference with previous visit is just 2 days. I want more than 10 days gap between visits. 5th - Response is N after Y response. I want to remove all records which occured after Y response for particular subject.

vandhan · ‎08-14-2019

I have data like below. id----Visit --------date------- response 01 Base 02APR2019 N 01 Vis 1 18APR2019 N 01 Vis 1 20APR2019 N 01 Vis 2 04MAY2019 Y 01 Vis 3 16MAY2019 N Want : 1. if next record date difference date <=10 days then I want delete the records regardless of visit name. 2. I want per id until Y response. from Y I dont want records. In this I dont want Vis 3 record from above data. Please help.

vandhan · ‎09-03-2018

I have some ABC macro. I have called ABC macro with mprint option. I can see sas code of the complied macro with notes and etc. I want clean code of that complied macro where I can edit code in between any step and run that code for my self. please help.

vandhan · ‎08-28-2018

I have program name ABC. I want to create a macro variable name PGM and it should have a value ABC. Do we have any system option or automatic macro variable for that?

vandhan · ‎08-28-2018

I am using EG only. i wanted to load A value to inds macro variable in this case.

vandhan · ‎08-28-2018

I want current program name in macro variable. How do i get that. For ex: if my program name is DM.sas then in DM.sas program i wanted to create macro varibale named PGM and want to load value DM into PGM macro variable.

vandhan · ‎08-28-2018

Hello, I am working on some comparing datasets and wanted to make sure compare program using the correct datasets. EX: my program name is A. I want to compare A dataset with AA. But issue arised here is programmer compared B with BB and compare report showing all matched in program A. I wanted to make sure in A program they compared only A dataset with AA. so I wanted mitigation plan here and load program (A) name into pgm macro variable in A program. and call pgm macro variable as input dataset in compare setp. Please help.

vandhan · ‎07-16-2018

One value 3.92356 production - format 10.5. value calucated by sum of 4 variables. validation side - value calculated by using converting char value to numeric with best. format then used format 10.5 How can we match values? Normally getting mathematical difference. values not matching.

vandhan · ‎05-04-2018

I have data like below 0.10 -0.10 0.12 0.13 11 -11.00 -0.20 479 I want like below as correctly aligned. 0.10 -0.10 0.12 0.13 11 -11 -0.20 479 Please help

vandhan · ‎02-09-2018

Hi, I don't see any option for rotating axis labels in sgplot wherein gplot I have rotate and angle option but here I don't see any option. yaxis label="Value" min=0 max=30 ; I want to rotate label "Value" vertical. currently, it is horizontally Please help.

vandhan · ‎02-01-2018

Hi I have a dataset having numerous varibles and want to compare what are the variables having missing values for a subject. id name number results rank 1 Nan . 3 A 2 Ben 10 . want results like with new variable "Comment" id name number results rank Comment 1 Nan . 3 A Number variable is missing 2 Ben 10 . Results and rank variable is missing I have loaded all variables in macro and compared then realized that char and numeric comparison is different Please help.

vandhan · ‎12-10-2017

WARNING: There is insufficient variation in the data to create a density plot. I am new to Statistical Procedures. I am getting above. what option should be used to avoid this warning. Please help.

Online Status	Offline
Date Last Visited	‎09-03-2019 04:05 AM

Proc template change group attributes

Re: Data check

Re: Data check

Re: Data check

Data check

Output SAS Code from Complied Macro from Log window to external file w...

Re: Load Current SAS Program Name to macro variable

Re: Load Current SAS Program Name to macro variable

Re: Find current directory path

Load Current SAS Program Name to macro variable

Re: re: Number of Days between two date with Leap Year

Re: intck day365

Proc template change group attributes

Re: Data check

Re: Data check

Re: Data check

Data check

Output SAS Code from Complied Macro from Log window to external file w...

Re: Load Current SAS Program Name to macro variable

Re: Load Current SAS Program Name to macro variable

Re: Find current directory path

Load Current SAS Program Name to macro variable

Proc compare - identical numeric values

Align Values in RTF having decimal and minus values

Rotate axis label SGPLOT Procedure

Report missing variable in a dataset for a each record and create new ...

Proc Ttest warning