About QLi

QLi · ‎02-19-2020

Chris, I tested it before using your way. in our data link, provider=NZOLEDB which is Netezza server, not among providers.

QLi · ‎02-18-2020

I am trying to create library through oledb. below is the code i submitted : LIBNAME ntz oledb init_string="provider=NZOLEDB; User ID=&myID ; password=&PW; Initial Catalog=MKTPRD; Data Source=MKTPRD-EEE-NTZ" schema=TRX; run; There was error: 35 LIBNAME ntz oledb 36 init_string="provider=NZOLEDB; 37 User ID=&myID ; 38 password=&PW; 39 XXXXXXXXXXXXXXXXXXXXXXXXXX 40 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 41 schema=TRX; ERROR: Error trying to establish connection: Unable to Initialize: Client unable to establish connection ERROR: Error in the LIBNAME statement. Could you help me point it out where is wrong? Thank you very much

QLi · ‎11-07-2019

I am using EG7.1, which should with SAS9.4. I wrote the following codes. it can not export the same sheet, each data set automatically generated different sheet. options noxwait xsync; x copy "temp_v0.xlsx" &excel_out; libname xls excel &excel_out ; run; proc datasets lib = xls nolist; delete Summary Rejected1 Rejected2 Point_O_New Point_overall_Existed ; quit; data xls.Summary; set RDP_Sum_t ; run; data xls.Rejected1; set RDP_Sum_Reject ;run; data xls.Rejected2; set RDP_Sum_Reject2 ; run; data xls.Point_overall_Existed ; set Point_1(where=( EXISTINGCUSTOMER='true')); run; libname xls clear; I will try your approach. Thank you very much

QLi · ‎11-07-2019

Thanks for your quick response. ODS is one way. However its generated file size so big. I need to export sas datasets in one template sheet which has specific position for each data set. Thanks

QLi · ‎11-07-2019

I have multiple sas small datasets and need to export the same sheet in Excel workbook. I defined different range cells for each data set in the same sheet. Anyone know how to do this ? Thanks in advance

QLi · ‎10-12-2017

Chris, thanks. based on your codes, i fix it out. By using multiple INPUT statements.

QLi · ‎10-12-2017

hello, I need to import non-standard text file into SAS. anyone know how to do it? below is one data sample Have : ID Name_addess RLT MGR_NM 1882 DONNA O ABBOTT 29791 JONATHAN D COLLINS 105 WINDWARD PSGE KNIGHTDALE NC 27545-9406 Want: ID Name_addess_1 Name_addess_2 Name_addess_3 RLT MGR_NM 1882 DONNA O ABBOTT 105 WINDWARD PSGE KNIGHTDALE NC 27545-9406 29791 JONATHAN D COLLINS

QLi · ‎04-02-2015

It worked. thanks,

QLi · ‎04-02-2015

I tried Last.mon and can't get what i want. Could you give some detail? Thanks,

QLi · ‎04-02-2015

Hello, I have a problem to find first n and last n obs for each month. I figured out how to find first n obs. Could anybody have an efficient way to get last n obs based on each month? Thanks in advance. The below is the code for the question. data have; length MOn $ 7 ; informat opendate yymmdd10. ; format opendate yymmdd10.; input Mon Opendate acctNum; datalines; 2014-01 2014-01-02 2384 2014-01 2014-01-02 4723 2014-01 2014-01-02 5954 2014-01 2014-01-06 2947 2014-01 2014-01-06 4349 2014-01 2014-01-06 4478 2014-01 2014-01-09 6139 2014-01 2014-01-09 7655 2014-01 2014-01-27 2065 2014-01 2014-01-28 7038 2014-02 2014-02-06 3120 2014-02 2014-02-07 2864 2014-02 2014-02-10 1409 2014-02 2014-02-11 0456 2014-02 2014-02-11 2704 2014-02 2014-02-11 5842 2014-02 2014-02-18 0934 2014-02 2014-02-18 7630 2014-02 2014-02-27 3931 2014-03 2014-03-04 4751 2014-03 2014-03-04 8732 2014-03 2014-03-13 4792 2014-03 2014-03-17 8868 2014-03 2014-03-25 8168 2014-04 2014-04-08 6910 2014-04 2014-04-09 4496 2014-04 2014-04-15 3525 2014-04 2014-04-17 6023 2014-04 2014-04-18 7453 2014-04 2014-04-23 3930 2014-04 2014-04-24 4925 2014-04 2014-04-28 3405 2014-04 2014-04-28 4038 2014-04 2014-04-28 8540 2014-04 2014-04-29 3964 2014-04 2014-04-30 2561 2014-04 2014-04-30 8133 2014-05 2014-05-05 6331 2014-05 2014-05-05 9796 2014-05 2014-05-09 5393 2014-05 2014-05-12 2715 2014-05 2014-05-19 0007 2014-05 2014-05-19 2741 2014-05 2014-05-19 5780 2014-05 2014-05-21 1717 2014-05 2014-05-21 5595 2014-05 2014-05-21 7656 2014-05 2014-05-28 1779 2014-05 2014-05-30 2382 2014-05 2014-05-30 5113 2014-05 2014-05-30 9139 2014-06 2014-06-12 2133 2014-06 2014-06-13 4578 2014-06 2014-06-16 7189 2014-06 2014-06-18 3996 2014-06 2014-06-23 7799 2014-06 2014-06-24 9880 2014-06 2014-06-30 8321 2014-07 2014-07-01 1332 2014-07 2014-07-08 4770 2014-07 2014-07-09 0097 2014-07 2014-07-10 7365 2014-07 2014-07-15 5766 2014-07 2014-07-15 8149 2014-07 2014-07-17 8945 2014-07 2014-07-18 9757 2014-07 2014-07-21 4171 2014-07 2014-07-21 4569 2014-07 2014-07-22 8733 2014-07 2014-07-23 9421 2014-07 2014-07-24 6270 2014-07 2014-07-30 6779 2014-08 2014-08-01 4313 2014-08 2014-08-05 6366 2014-08 2014-08-08 7315 2014-08 2014-08-11 7244 2014-08 2014-08-11 8788 2014-08 2014-08-12 2978 2014-08 2014-08-13 0967 2014-08 2014-08-13 4598 2014-08 2014-08-14 1587 2014-08 2014-08-14 6579 2014-08 2014-08-14 9235 2014-08 2014-08-19 6960 2014-08 2014-08-19 7424 2014-08 2014-08-21 4643 2014-08 2014-08-22 8183 2014-08 2014-08-25 6993 2014-08 2014-08-26 5970 2014-08 2014-08-26 7337 2014-08 2014-08-28 1918 2014-08 2014-08-28 2548 2014-08 2014-08-28 9709 2014-08 2014-08-28 9821 2014-09 2014-09-01 0401 2014-09 2014-09-03 5498 2014-09 2014-09-04 4562 2014-09 2014-09-08 3869 2014-09 2014-09-11 3966 2014-09 2014-09-11 5163 2014-09 2014-09-15 3879 2014-09 2014-09-15 6084 2014-09 2014-09-16 6347 2014-09 2014-09-18 7511 2014-09 2014-09-22 6510 2014-09 2014-09-29 2145 2014-09 2014-09-30 3317 2014-10 2014-10-01 4439 2014-10 2014-10-03 4036 2014-10 2014-10-08 4278 2014-10 2014-10-17 6996 2014-10 2014-10-28 1506 2014-11 2014-11-06 4125 2014-11 2014-11-07 5094 2014-11 2014-11-13 5534 2014-11 2014-11-17 4154 2014-11 2014-11-18 8332 2014-11 2014-11-18 9681 2014-11 2014-11-21 5800 2014-11 2014-11-24 0591 2014-11 2014-11-24 9726 2014-12 2014-12-01 9144 2014-12 2014-12-03 4830 2014-12 2014-12-03 7171 2014-12 2014-12-04 7629 2014-12 2014-12-12 0703 2014-12 2014-12-15 3130 2014-12 2014-12-29 0229 ; run; proc sort data=have out=have_s; by Opendate acctNum; run; data want; set have_s; count+1; by Mon; if first.mon then count=1; run; ** to find first 2 obs for each month **; data first2obs (drop=count); set want; if count le 2; run;

QLi · ‎08-07-2014

I have SAS/Graph package. the hard part is how to combine the bar chart and the numbers together the sample data code: data plot1_data; input digital_channels $ 1-25 ActiveClients PctOfBank pct_new_YoY; cards; Total Banking Clients 4600000 1 0.3 Total Digital Banking 2255300 0.490282609 0.5 Retail 2031084 0.526249733 0.19 Retail Bill Pay 376458 0.097539502 -1.77 Business 224167 0.294097119 0.06 Business Bill Pay 50299 0.493896127 -3.45 Mobile 1051132 0.228506957 -0.04 App 707607 0.153827609 0.24 Mobile Web 442856 0.096273043 -0.004067451 SMS 71008 0.015436522 0.015437697 ; run; data plot1_data; set plot1_data; sortorder=_n_; PCT_Bank2=int(PctOfBank*100); pct_new_YoY2=int(pct_new_YoY*100); run; I tried to use annotate macros and SAS/GRAPH's annotate facility to create the following part except 12-month spike line.

QLi · ‎08-07-2014

I have a project need to build SAS dashboard. We only have PC SAS 9.3 and Enterprise Guide 5.1. I tried the dashboard sample codes on the SAS website.http://robslink.com/SAS/democd19/sfew.sas I can’t seem to get customized codes. .By altering the codes, it doesn’t work out I get stuck at the annotation part. Anyone has some experience or reference for SAS dashboard? Thanks

QLi · ‎04-26-2013

I tried it from the link and worked it out. Thank you very much , Keith.

QLi · ‎04-26-2013

I use SAS 9.1. I want to get the order week of the month. such as 1st , 2nd , 3rd week of the month. Could anyone can help me ? For example: Date Month need : WeeK_num_ of Month 15-Mar Mar 3 16-Mar Apr 3 17-Mar May 4 18-Mar Jun 4 19-Mar Jul 4 20-Mar Aug 4 21-Mar Sep 4 22-Mar Oct 4 23-Mar Nov 4 24-Mar Dec 5 25-Mar Jan 5 26-Mar Feb 5 27-Mar Mar 5 28-Mar Apr 5 29-Mar May 5 30-Mar Jun 5 31-Mar Jul 6 1-Apr Apr 1 2-Apr May 1 3-Apr Jun 2 4-Apr Jul 2 5-Apr Aug 2 6-Apr Sep 2 7-Apr Oct 2 8-Apr Nov 2 9-Apr Dec 2 10-Apr Jan 3 11-Apr Feb 3 12-Apr Mar 3 13-Apr Apr 3 Thanks in advance.

QLi · ‎06-29-2012

when I tried to connect remote server, I run the following code options comamid=tcp; options remote=SASLPAR.mf_spawn; signon noscript user=&XID password=&XPASS; Log window showed the error message: NOTE: Remote signon to SASLPAR.MF_SPAWN commencing (SAS Release 9.01.01M3P020206). ERROR: A communication subsystem partner link setup request failure has occurred. ERROR: Communication request rejected by partner: security verification failure. ERROR: Remote signon to SASLPAR.MF_SPAWN cancelled. What's wrong with these? Any suggestions ? Thanks,

Online Status	Offline
Date Last Visited	‎09-10-2020 09:36 AM

Re: Libname oledb connection

Libname oledb connection

Re: How to export multiple SAS Datasets into the same sheet in Excel w...

Re: How to export multiple SAS Datasets into the same sheet in Excel w...

How to export multiple SAS Datasets into the same sheet in Excel workb...

Re: importing non-standard text file

importing non-standard text file

Re: How to find first N and last N obs with By variable?

Re: How to find first N and last N obs with By variable?

How to find first N and last N obs with By variable?

Determining the number of observations in a SAS data set efficiently

Re: extract a substring from a string

Re: extract a substring from a string

Re: extract a substring from a string

Re: joining on a computed column in eg

Re: Help with simple (I thought) merge statement

predict procedure?

Re: Working with Delimit in SAS EG

Re: How to add column average on the end of table (proc tabulate)?

Re: Libname oledb connection

Libname oledb connection

Re: How to export multiple SAS Datasets into the same sheet in Excel w...

Re: How to export multiple SAS Datasets into the same sheet in Excel w...

How to export multiple SAS Datasets into the same sheet in Excel workb...

Re: importing non-standard text file

importing non-standard text file

Re: How to find first N and last N obs with By variable?

Re: How to find first N and last N obs with By variable?

How to find first N and last N obs with By variable?

Re: SAS Dashboard

SAS Dashboard

Re: the order week of the Month

the order week of the Month

Remote Signon