About QLi

QLi · ‎08-08-2011

I have datasets whoes library name exceeds 8 characters. ButI don't have authourization to change it. proc contents does't work. Anyboby have solution for this case? Thanks in Advance.

QLi · ‎07-28-2011

I very appreciated your response. I have the indepent variables such as, customer's age, gender, credit score, income, martial status... . These are assumed to affect the customer future behavior patterns. Since I don't have history depent vairable data which is Y/N binary vairable, I don't how to restrict or define depent vaiable.

QLi · ‎07-28-2011

There is the new service in the industry. I need to price it. First I think I need to predict which client will used it. Which procedure should I use to do it? I don't have SAS ® Enterprise Miner. Thanks in advance.

QLi · ‎07-06-2011

I think Proc Sql maybe easy to do it. Try this code. data a; input n zip boship $ ; datalines ; 1 40219 02TK 2 40219 02TJ 3 40219 02TM 4 40219 02TV 5 40219 02TU 6 40219 02TR 7 40219 02TE ; data b; input n zip order_num $ ; datalines ; 1 40219 B401632K 2 40219 R765534K ; run; porc sql; select a.*, order_num from a as a, b; ; Quit;

QLi · ‎07-05-2011

the option: (drop=_: ) is able to drop the columns (_freq_ , _type_) in the proc means.

QLi · ‎06-30-2011

I think you can use Data step to deal with it. data dummy; length name address1 address2 $ 20; input name $ address1 $ address2 $ @@; cards; Name_Person_1 Address_Person_1 Address 2_Person_1 Name_Person_2 Address_Person_2 Address_2 Person_2 Name_Person_3 Address_Person_3 Address_2_Person_3 ; run;

QLi · ‎06-30-2011

try this one: proc means data= noprint; var employment; output out=want ( drop=_: ) sum=employment_subset; where naics in (21, 22, 23); run; Hopefully,it works out.

QLi · ‎06-30-2011

another way to change Character variable to numeric variable, Char_Var *1; or Char_Var+0;

QLi · ‎06-24-2011

According these suggestions, I worked it out. Thanks all.

QLi · ‎06-23-2011

Hi, I have this kind data: Full_Name City State H_RCl P_RC1 S_RC1 T_R1 Rice Brown Raleigh NC $167 0 0 0 Rice Brown Raleigh NC 0 0 $123 0 Rice Brown Raleigh NC 0 124 0 0 Rice Brwon Raleihg NC 0 0 0 $125 I want get this one row data: Full_Name City State h_RC1 P_RC1 S_RC1 T_RC1 Rice Brown Raleigh NC $167 $124 $123 $125 Thanks in advance

QLi · ‎06-13-2011

I need count each obs non zero column, data like this: data a; input m1-m12 @@; cards; 0 1 4 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 6 0 ; run; How can I get non zeros fro each obs? Thanks in advance.

QLi · ‎05-27-2011

Thanks all, I worked it out. Since DBMS type EXCEL not valid for import for Enterprise Guide, after changed to CSV file and worked well.

QLi · ‎05-26-2011

I use Enterprise Guide 4.1. I want to read Exel to SAS. But I don't have DDE and SAS Access for Pc files. So I cann't use PROC IMPORT or PROC ACCESS. Anyone know how to use INFILE statement to read? Thanks in advance. Qli

QLi · ‎05-13-2011

It worked well. Thank you very much.

QLi · ‎05-13-2011

I want to run the following code: data _null_; a='August 24, 2010'; format b date9.; b=input(a, worddate20.); put a= b=; run; It showed the message in the Log window: NOTE 485-185: Informat WORDDATE was not found or could not be loaded. Could you help me out this? Thanks in Advance.

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

Library name exceeds 8 characters

predict procedure?

predict procedure?

Re: Help with simple (I thought) merge statement

Proc Means, new variable, collapse across conditional category

help with transposing data

Proc Means, new variable, collapse across conditional category

converting variable type fron character to numeric

collapse data

collapse data

Do loop or array?

Re: How to read Excel to SAS without DDE or SAS /Access Interface to ...

How to read Excel to SAS without DDE or SAS /Access Interface to PC f...

Re: Date Format

Date Format