About QLi

QLi · ‎04-26-2011

Ksharp, I tried your method. It worked great. Thank for your help.

QLi · ‎04-26-2011

Art297, It works great. Thank you very much!!

QLi · ‎04-25-2011

Thanks for your response. according to the code; proc transpose data=web out=T_web (drop=_name_ _label_) ; var count; id week_beginning ; by Search_methods; run; the result is the following. Search_methods 03/28/11 04/11/11 04/18/11 04/04/11 Online Banking 1 9 28 0 Search by Name 0 1 4 1 Search by Reservation 0 8 42 0 The week beginning can not be ordered. I want to them in the order of 03/28/11,04/04/11, 04/11/11,04/18/11. I want to transpose by search methods at the same time week beginnings in order. Thanks,,

QLi · ‎04-25-2011

All, I have data foramt such as: Search_methods week_beginning count Online Banking 03/28/11 1 Online Banking 04/11/11 9 Online Banking 04/18/11 28 Search by Name 04/04/11 1 Search by Name 04/11/11 1 Search by Name 04/18/11 4 Search by Reservation 04/11/11 8 Search by Reservation04/18/11 42 need to transpose to the following format: Offer Search Methods 3/28/2011 4/4/2011 4/11/2011 04/18/11 Online Banking 1 0 9 28 Search by Name 0 1 1 4 Search by ReservatioN 0 0 8 42 Thanks in advance.

QLi · ‎02-11-2011

Hi, All, When I run the macro in the EG, it wasn't be successful. It showed that NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support. 9 OPTIONS DEV=ACTIVEX; 10 FILENAME EGSR TEMP; NOTE: Writing TAGSETS.SASREPORT11(EGSR) Body file: EGSR Does anyone have this kind of situation? Could you help me figure it out? Thanks,

QLi · ‎04-28-2010

I have this kind data in txt format. I need urgent help to import into SAS data set. ------------------------------------------------------------------------------------ | 193100 | 20100331 | 97 | 3 | ------------------------------------------------------------------------------------- | 200998 | 20100331 | 97 | 4 | ------------------------------------------------------------------------------------- | 201707 | 20100331 | 97 | 2 | ------------------------------------------------------------------------------------- | 215848 | 20100331 | 97 | 1 | ------------------------------------------------------------------------------------- | 233171 | 20100331 | 97 | 3 | ------------------------------------------------------------------------------------- | 250530 | 20100331 | 97 | 16 | ------------------------------------------------------------------------------------- Thanks

QLi · ‎04-08-2010

According to your help, I tried these codes and finally it out. data new (drop=i diff); set try; retain i 400; do ; diff=fico_score - i; if diff le 5 then band= i; retain i; else do ; if ( diff gt 5 and diff le 10) then i=i +5 ; else i=i+10; band =i; retain i; * retain band; end; end; run;

QLi · ‎04-08-2010

Thanks very much. I try it right now.

QLi · ‎04-08-2010

Scott, Could you please teach me how to assign the group variable? The Fico Score value in the dataset likes this Fico Score 412 412 413 413 413 414 414 415 416 How can I assign the variable to make, every 5 point as one group? What I expect the result likes this Fico Score Group 412 1 412 1 413 1 413 1 413 1 414 1 414 1 415 1 416 1

QLi · ‎04-08-2010

Thanks very much.

QLi · ‎04-07-2010

Thanks Duke, I will try it.

QLi · ‎04-07-2010

I have a big dataset A. The main variables in Data A are fico_score, account_number, charge_off. I need to analysis these three variables. In every 5 score points range from min to max, to calculate the frequency of account_number, total balance of charge_off and also to show the range in the output. The Dataset A I have like this kind: Fico_Score Account_number Charge_off 450 123 2.5 450 456 2.1 451 213 . ..... The result I expect to get likes this: Score_band Freq_acct Total_CO 450-455 45 21.1 456- 460 23 31.1 ....... I tried these codes, but it didn’t work. Data test; set a; retain Score_band Freq_amt Total_co; do i = 450 to 830 by 5; proc means data = a noprint; var account_number charge_off; where fico_score >= i and Fico_score < i+5; output n = Freq_acct sum = Total_Co; end; run; Could someone tell me some clues to code these?

QLi · ‎03-31-2010

Thanks for your response. The original data like this: input code score ss $; 1944 . 1944 . 412 959 548 417 959 . 170 665 408 170 659 171 581 171 580 183 176 665 176 . 414 I want to get dataset like this 959 548 417 170 659 408 171 580 183 176 665 414 1st column code is doubled, I want to keep one unique code, 2nd column is score, there are two scores for doubled code, and I want to pick the smaller one. 3rd column is ss, there are one value and one missing for doubled code, and I want to pick non-missing value. Could you please help fix it out? Thanks very much! Qing

QLi · ‎03-31-2010

How can I create this kind dataset from data a? the reqirement is the unique code with smaller score vale and alos non-missing ss. data a; input code score ss $; cards; 1944 . 1944 . 412 959 548 417 959 . 170 665 408 170 659 171 581 171 580 183 176 665 176 . 414 ; run; Thanks,

QLi · ‎03-23-2010

Thanks for your feedback. I know it is easy to calculate for single date variable. How to use intck function in Data Step to calculate many date vairables. mage=INTCK(’MONTH’,’date’D,’30Oct2009’D) many 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: 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: joining on a computed column in eg

Re: transpose data

Re: transpose data

Re: transpose data

transpose data

Error Macro message

Urgent help for importing txt format data into SAS

Re: Can Proc Means be used in DO Loops ?

Re: Can Proc Means be used in DO Loops ?

Re: Can Proc Means be used in DO Loops ?

Re: Can Proc Means be used in DO Loops ?

Re: Can Proc Means be used in DO Loops ?

Can Proc Means be used in DO Loops ?

Re: create new dataset

create new dataset

Re: intck or month functions