About vandhan

vandhan · ‎09-21-2016

Hi, Thanks for you reply. It is not going through. What should be in the "Action"?? Action : (what should i enter here) Action Command : colheading=name ##- Please type your reply above this line. Simple formatting, no attachments. -##

vandhan · ‎09-20-2016

Hi Fusima, Thanks for your time for replying my question. This nolabel option removes all labels of the dataset. But, I need to have labels for dataset and I wanted to see variable names by default when I open dataset. Please help. ##- Please type your reply above this line. Simple formatting, no attachments. -##

vandhan · ‎09-20-2016

Hi, When I open any SAS dataset I see column/variable label by default. I would like to see by default variable/column names instead of lables of these variables. Is there any way/option for this? Please help.

vandhan · ‎07-01-2016

Awesome thanks

vandhan · ‎06-27-2016

Hi, I have Raxis values ranging from -80 to 0 in proc gchart. i specified as axis2 order = (-70 to 0 by -10) offset=(0,0) minor = none value = (h=1); but i log i see "WARNING: Order= clause on the axis statement is not valid. The default axis values will be used." i'm getting -60 to 0 range values in output. not from -80 to 0. please help.

vandhan · ‎05-04-2016

Thanks a lot bro ##- Please type your reply above this line. Simple formatting, no attachments. -##

vandhan · ‎05-04-2016

data _null_; days365=intck('day365','31dec2009'd,'19dec2010'd); put days365 = ; run; results : day365 = 1 Why 1 is coming. since intervel is not 365. it should be come as 0. Can someone explain pls.

vandhan · ‎03-02-2016

dataset look like: name abc cba xyz excel file (blanck column name) abc cba xyz but currently I'm getting as it is in dataset. name abc cba xyz when i apply black label for this 'name' variable .. im getting variable name in column of excel. ##- Please type your reply above this line. Simple formatting, no attachments. -##

vandhan · ‎03-02-2016

Hi, i have a varible in dataset named "name" I'm listing name variable in excel file. name abc bca cbd NOw I want to supress variable in excel file. like (name) name should be supressd and values should be printed as same in dataset. please help.. I have given black label in proc print. but im getting variable name in colum of excel file.

vandhan · ‎03-02-2016

Hi, I have one variable in dataset is having indentation for few rows. but when i craeating excel file using ODS EXCELXP tagset... the identation is coming in excel file.. please help ex: variable in dataset: name James david excel file James david where david having left identation in dataset.. but i can't see in excel file.

vandhan · ‎01-28-2016

How can I solve the problem? I do not need times, just month, day and year to compare. Carmen Goss Integrated Data Systems Winston-Salem/Forsyth County Schools Ph: (336) 748-4000 ext 34595 cdgoss@wsfcs.k12.nc.us All e-mail correspondence to and from this address is subject to the North Carolina Public Records Law, which may result in monitoring and disclosure to third parties, including law enforcement. AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EMPLOYER

vandhan · ‎01-28-2016

One or many.

vandhan · ‎01-28-2016

data have; input id Salary; cards; 101 1000 102 2000 103 1000 104 3000 105 3000 106 4000 ; proc sql; create table want as select id, max( salary ) as wantvar from have where salary < ( select max( salary ) from have where salary < ( select max ( salary ) from have)); quit; above code is giving 3 records... it should get only one that is 102 2000. Please help.

vandhan · ‎01-28-2016

data have; input id Salary; cards; 101 1000 102 2000 103 1000 104 3000 105 3000 106 4000 107 2000 ; wanted to find id and salary which is 3rd max value using sql?? in this case result should be 102, 107 with 2000 salary which is 3rd maximum

vandhan · ‎01-28-2016

if i have max values 6 values like 4000 ... in that case this is not possible... ##- Please type your reply above this line. Simple formatting, no attachments. -##

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

Re: See default variable names rather than labels in SAS dataset

Re: See default variable names rather than labels in SAS dataset

See default variable names rather than labels in SAS dataset

Re: Proc Gchart Raxis error : Order= clause on the axis statement is n...

Proc Gchart Raxis error : Order= clause on the axis statement is not v...

Re: intck day365

intck day365

Re: tagsets ods and excel file creation

tagsets ods and excel file creation

ODS EXCELXP tagset and indentation fix

Re: Dates when using EXCEPT comparison

Re: proc sql

Proc sql finding Max value

proc sql

Re: Proc sql finding maximum values