cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ghosh
‎08-07-2025
  • 442 Posts
  • 185 Likes Given
  • 38 Solutions
  • 112 Likes Received

Re: Can I reduce length of character variables?

by Barite | Level 11 in SAS Programming
‎10-15-2019 05:31 PM
‎10-15-2019 05:31 PM
proc sql; alter table tochange modify varname char(10) format=$10.; quit; ... View more

Re: import excel file from sharepoint site

by Barite | Level 11 in SAS Programming
‎09-28-2019 10:41 AM
‎09-28-2019 10:41 AM
you have a comma in the URL.   change the portion to tset.com ... View more

Re: importing a Json file into sas

by Barite | Level 11 in SAS Programming
‎09-23-2019 09:07 AM
‎09-23-2019 09:07 AM
filename rept "\\cagv22\QuoteData\Archive\classificationHS.JSON"; proc http method = "get" url = "https://comtrade.un.org/data/cache/classificationHS.json" out = rept; run; libname mydata JSON fileref=rept; well then change your filename ref to point to this location.  If have SAS running from a server, it would not be able to read the c drive ... View more

Re: importing a Json file into sas

by Barite | Level 11 in SAS Programming
‎09-23-2019 08:54 AM
‎09-23-2019 08:54 AM
* This works for me. DAT is a folder ref off the root ; filename rept "~/dat/classificationHS.JSON"; proc http method = "get" url = "https://comtrade.un.org/data/cache/classificationHS.json" out = rept; run; libname mydata JSON fileref=rept; proc contents data=mydata._all_; run; ... View more

Re: Does VitualBox need to make changes to my hard drive in order to w...

by Barite | Level 11 in New SAS User
‎09-09-2019 09:14 AM
‎09-09-2019 09:14 AM
Yes, it's safe allow to give the installer permission to make changes.  All software installation require this.  In case you are not comfortable doing this, you could use the online free SAS SODA  ... View more

Re: Create a new variable based on a frequency

by Barite | Level 11 in New SAS User
‎09-03-2019 10:43 AM
1 Like
‎09-03-2019 10:43 AM
1 Like
proc sql noprint; select count(age) into :newvar from table where age eq "029"; quit; data want; set table; newvar=&newvar; RUN; ... View more

Re: assigning value from another dataset

by Barite | Level 11 in SAS Procedures
‎09-03-2019 10:23 AM
‎09-03-2019 10:23 AM
data want;   merge set1(in=a) set2;   by source;   if a; run; ... View more

Re: Fit table on single slide Proc Report ODS Powerpoint

by Barite | Level 11 in ODS and Base Reporting
‎08-24-2019 02:59 PM
‎08-24-2019 02:59 PM
try:   ods powerpoint file='test.pptx' layout=TitleAndContent;   ref: http://support.sas.com/kb/50/486.html ... View more

Re: converting character variable to numeric AND preserving its place ...

by Barite | Level 11 in SAS Programming
‎08-21-2019 03:12 PM
‎08-21-2019 03:12 PM
put in a length statement before input, as in: data file1; infile='file name string' dsd; length v1 v2 v3 v4 5 v5 v6 $5 a1-a5 b1-b20 c1-c34 5; input v1 v2 $ v3 v4 v5 v6 $ a1-a5 b1-b20 c1-c34; run; ... View more

Re: converting character variable to numeric AND preserving its place ...

by Barite | Level 11 in SAS Programming
‎08-21-2019 10:03 AM
‎08-21-2019 10:03 AM
you are thinking of the length function. You could define a numeric variable (say 11n) in the length statement as a placeholder which will hold the converted value of x11. in a subsequent data step drop x11 and rename x11n to x11. Just an idea, have not tested it ... View more

Re: converting character variable to numeric AND preserving its place ...

by Barite | Level 11 in SAS Programming
‎08-21-2019 09:39 AM
‎08-21-2019 09:39 AM
data x; length x1-x10 5 x11 x11a $5 x12-x20 5 ; run; proc contents; run; ... View more

Re: How to search my own bookmarks

by Barite | Level 11 in All Things Community
‎08-04-2019 11:23 AM
‎08-04-2019 11:23 AM
Thanks! Perhaps even an addition in the dropdown search box where there could be "My Bookmarks" and "My Subscriptions" choices. ... View more

Re: How to search my own bookmarks

by Barite | Level 11 in All Things Community
‎08-04-2019 09:20 AM
‎08-04-2019 09:20 AM
I came upon this thread searching for the same information.  I would like to be able to search my bookmarked and subscribed posts/threads (have more than 10 pages), or else be able to export the list in html format (with working links)   Thanks   ... View more

Re: SGplot suppress missing bars

by Barite | Level 11 in Graphics Programming
‎07-26-2019 10:03 PM
‎07-26-2019 10:03 PM
Hi Dan,   Thank you so much.  Works perfectly!   Regards Aroop  ... View more

SGplot suppress missing bars

by Barite | Level 11 in Graphics Programming
‎07-26-2019 11:38 AM
‎07-26-2019 11:38 AM
ods graphics on / reset=all; ods graphics on / width=4in; proc sgpanel data=sashelp.class; panelby sex / noheader noborder skipemptycells; vbar age / response=height group=sex; run; I am creating a graph similar to example from the documentation "SAS® 9.4 ODS Graphics: Procedures Guide, Sixth Edition".  I have only added the  skipemptycells option.     I would like to suppress missing bars (female age 16) , however, the  skipemptycells option does not suppress it.  In my own example I am using year and quarter as the panelby and vbar variables respectively. Would appreciate a solution. Thanks   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-07-2025 04:33 PM
Likes given to
View All
Likes from
Quick links