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: 
kimmygzc
‎04-20-2022
  • 30 Posts
  • 2 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: what R stands for in SAS(R) 9.3 ?

by Obsidian | Level 7 in SAS Programming
‎04-19-2022 02:50 AM
1 Like
‎04-19-2022 02:50 AM
1 Like
Yeah, kind of frustrating, since it's not easy for me to persuade the C-suites to update. Anyway, I admire how SAS crew manage to refresh this massive powerful and aged set of software. Thanks for the information, Sir. ... View more

what R stands for in SAS(R) 9.3 ?

by Obsidian | Level 7 in SAS Programming
‎04-18-2022 11:45 PM
‎04-18-2022 11:45 PM
what R stands for in SAS(R) 9.3 ?   and is there a integrated documents like 9.4 SAS Help Center    It's just unfair for 9.3 and earlier users, tons of docs distributed all over...  ... View more

How to check if a location(latitude, longitude) in a map area(district...

by Obsidian | Level 7 in SAS Procedures
‎04-14-2022 04:35 AM
‎04-14-2022 04:35 AM
How to check if a location(latitude, longitude) in a map area(district/city/province)?   Have mapsgfk.china   input (lat, long)   want city name   Since proc gmap choro illustrates the map with color pretty nice, I guess there's a way to check if a point is in that color set, which refers to an area.   Thanks in advance!  ... View more

Re: Connect to metadata server with options

by Obsidian | Level 7 in Administration and Deployment
‎11-30-2021 01:53 AM
‎11-30-2021 01:53 AM
The code in EG goes like this: [libname]statement: libname CON greenplm server= port= database= authdomain=; pro sql outobs=30; select * from CON.table_nm run; or pass-through: proc sql; connect to greenplm as gpconn(server= port= database= authdomain=); select * from connection to gpconn( select * from ap1.table_nm limit 30 ); disconnect from gpconn; run; these would work in EG, but failed in sas.exe. the difference is EG connect to SVC with user&password every time it initiates. ... View more

Re: Connect to metadata server with options

by Obsidian | Level 7 in Administration and Deployment
‎11-30-2021 01:36 AM
‎11-30-2021 01:36 AM
Thanks Sir, But I can't copy anything down from the internal network... I scripted proc sql to select from sashlep.cars and it works out fine. But the other proc sql connected to GP just won't make it, I tried both [libname] statement and [connect to greenplum], which I normally build connections to the GP server in EG, but it failed in only sas.exe. Are there more information about the "pre-assign" and about "SAS Management Console" you mentioned? Thanks for your time, Sir. ... View more

Re: Connect to metadata server with options

by Obsidian | Level 7 in Administration and Deployment
‎11-30-2021 01:27 AM
‎11-30-2021 01:27 AM
Thanks! I have SAS EG 7.1 and sas 9.3 installed, I'm not sure if the EG works standalone or through another computing node, where do I check this? I have EG connections configured [remote machine], I think this offers access to the SVC(switched virtual circuit), where the GP user id and password is stored. And via the SVC I can finally commit my SQLs to the Greenplum Server. I'm trying to plug in the SVC in sas.exe without EG's help, I guess you're right about ODBC, is there anything I might have ignored? ... View more

Re: Connect to metadata server with options

by Obsidian | Level 7 in Administration and Deployment
‎11-29-2021 02:15 AM
‎11-29-2021 02:15 AM
I'd love to, but the SAS is on Cloud environment... Basically, Connect to greenplum server with [server, port, databse, authdomain] when use EG connection. I guess EG works with the authomain option, to log in the Greenplum server. I need to get the same credential without EG before actually connect to Greenplum, I tried options [matauser, metapass, metaport, metaprotocol(bridge), metaserver], but it doesn't work... ... View more

Connect to metadata server with options

by Obsidian | Level 7 in Administration and Deployment
‎11-29-2021 01:46 AM
‎11-29-2021 01:46 AM
I'm using SAS EG 7.1 with sasfoundation 9.3; I connect to a greenplum server via a metadata server(log in a remote SVC in connection setup with user&pwd). And I could commit SQLs to GreenPlum server with libname statement, or pass-through machanisim. It works fine, and for some reason, I need to run without EG, just on sas.exe. So the trouble is, when I tried to connect to setup metadata server connection with [options], under this instruction: https://support.sas.com/kb/38/204.html The log reported error: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. I believe it hasn't made the right connection to GreenPlum yet, Why would sas bother with MS ODBS? What should I do to adjust this? It's just a tricky trouble to shoot, any reply would be greatly appreciated! Kim Tse ... View more

how to pass runtime of procs into macro variable?

by Obsidian | Level 7 in SAS Programming
‎11-24-2021 04:59 AM
‎11-24-2021 04:59 AM
how to get runtime and pass value to macro var? thanks. ... View more

Re: how to hide class level information

by Obsidian | Level 7 in Statistical Procedures
‎11-19-2021 05:17 AM
‎11-19-2021 05:17 AM
I'll try, the proj file is collecting features and locked up. ODS, good, do you happen to have a option list for different procs? I have also other procs needed to select output, like proc univariate, etc. Thank you, Koen. have a good day, end of Fri work hour from Guangzhou, China. ... View more

Re: how to hide class level information

by Obsidian | Level 7 in Statistical Procedures
‎11-19-2021 03:49 AM
‎11-19-2021 03:49 AM
Thanks for your reply! Koen. im using proc logistic, it's annoying to see stepwise mid results, too long to review, I'm looking for a way to filter the results. ... View more

how to hide class level information

by Obsidian | Level 7 in Statistical Procedures
‎11-19-2021 01:23 AM
‎11-19-2021 01:23 AM
one of the coding variables is of hundreds kinds, and the class level information table is too wide to display, how to hide it?     and how to order the parameters by estimator (in abs would be better)? can select top-n wanted only?   ... View more

Re: proc logistic with only categorial var

by Obsidian | Level 7 in Statistical Procedures
‎11-18-2021 11:04 PM
‎11-18-2021 11:04 PM
or hide class level infomation would work, but I dont see any opt to turn it off.. ... View more

Re: proc logistic with only categorial var

by Obsidian | Level 7 in Statistical Procedures
‎11-18-2021 10:47 PM
‎11-18-2021 10:47 PM
One more question Sir, I have a cat of hundreds values, and it makes the result too large to display, can I select the predictors of top-n significant estimators, and how? ... View more

Re: proc logistic with only categorial var

by Obsidian | Level 7 in Statistical Procedures
‎11-18-2021 10:37 PM
‎11-18-2021 10:37 PM
Thanks Sir! you saved my day! I thought class and model are mutually exclusive... try to put cats in model, error says should be numeric try to put cats in class, didn't even calc them in model that make all the senses now. Thank you very much. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-20-2022 05:12 AM
Likes given to
View All
Likes from
View All
Quick links