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: 
xinjian
‎01-08-2018
  • 87 Posts
  • 0 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: sas 9.4 won't read some variables in excel file

by Calcite | Level 5 in SAS Programming
‎08-22-2014 04:07 PM
‎08-22-2014 04:07 PM
I tried everything suggested by you guys, it did not work. I have total 812 variables, but SAS 9.4 only read 255. Other variables identified by SAS as  ERROR: Variable xx  not found. Is there a way to let SAS 9.4 to read more variables? Thanks ... View more

Re: sas 9.4 won't read some variables in excel file

by Calcite | Level 5 in SAS Programming
‎08-21-2014 07:10 PM
‎08-21-2014 07:10 PM
HI Reeza, do you have better solutions? I rather use excel file to do analysis. Thanks, ... View more

Re: sas 9.4 won't read some variables in excel file

by Calcite | Level 5 in SAS Programming
‎08-21-2014 06:57 PM
‎08-21-2014 06:57 PM
All columns have headers. Those variables won't read by SAS 9.4, looks like similar for those variables can be read by SAS. but I will try to export to csv to check. Thanks. ... View more

Re: sas 9.4 won't read some variables in excel file

by Calcite | Level 5 in SAS Programming
‎08-21-2014 06:36 PM
‎08-21-2014 06:36 PM
The text file database using unix  is not working. I have to enter some data using exported excel file from SAS. now I use: IMPORT OUT= WORK.A DATAFILE= "c:\B.xlsx" DBMS=EXCEL REPLACE; SHEET="sheet1$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Then run analysis. Thanks, ... View more

sas 9.4 won't read some variables in excel file

by Calcite | Level 5 in SAS Programming
‎08-21-2014 06:09 PM
‎08-21-2014 06:09 PM
I have text file database. I export it to an excel file.  I run SAS 9.4 using excel file. Then, SAS 9.4 won't read some variables in excel file with ERROR: Variable xx  not found. Thanks in advance for your help. ... View more

How to import an Excel file with rows as variables in SAS 9.4?

by Calcite | Level 5 in SAS Programming
‎08-13-2014 03:57 PM
‎08-13-2014 03:57 PM
I have an excel file with rows as variables. Is it possible to import and programed it just like column as variable? Thanks, Xinjian ... View more

Re: Installing SAS 9.4 on windows 8.1

by Calcite | Level 5 in Administration and Deployment
‎07-14-2014 03:49 PM
‎07-14-2014 03:49 PM
Hi Jaap, I checked 52767 - Windows 8.1 Update 1 or Windows Server 2012 R2 Update 1 might cause a SAS® installation to fail and installed SAS® Java clients to not open. It seems  I have to get SAS 9.4 (TS1M1) revision 14w19 for solving this problem. Thanks, Xinjian ... View more

Re: Installing SAS 9.4 on windows 8.1

by Calcite | Level 5 in Administration and Deployment
‎07-14-2014 02:17 PM
‎07-14-2014 02:17 PM
I checked sid file. My OS is OK. ... View more

Re: Installing SAS 9.4 on windows 8.1

by Calcite | Level 5 in Administration and Deployment
‎07-14-2014 01:46 PM
‎07-14-2014 01:46 PM
My SAS 9.4 is for 64 bit. My pc is 64 bit with windows 8.1 pro. ... View more

Installing SAS 9.4 on windows 8.1

by Calcite | Level 5 in Administration and Deployment
‎07-14-2014 01:00 PM
‎07-14-2014 01:00 PM
I tried to install SAS 9.4 on window 8.1, clicked set up application, then I got this error window: ''You’ve attempted to install software intended for one operating system on a machine using a different operating system. You should either install on a machine using the operating system you downloaded for or return to the download site and download the appropriate software for your operating system.'' is someone know how to solve this problem? THanks ... View more

Re: SAS 9.3 proc means problem

by Calcite | Level 5 in SAS Procedures
‎06-10-2014 12:02 PM
‎06-10-2014 12:02 PM
Thanks so much. ... View more

Re: SAS 9.3 proc means problem

by Calcite | Level 5 in SAS Procedures
‎06-09-2014 04:31 PM
‎06-09-2014 04:31 PM
data set showed 75 subjects. it is really strange. thanks ... View more

Re: SAS 9.3 proc means problem

by Calcite | Level 5 in SAS Procedures
‎06-09-2014 04:12 PM
‎06-09-2014 04:12 PM
It is an excel file. Here is the code to access data sheet: PROCIMPORT OUT= WORK.BASELINE      DATAFILE="f:\V.xls"      DBMS=EXCEL REPLACE   SHEET="Sheet11$";   GETNAMES=YES;   MIXED=NO;    SCANTEXT=YES;   SEDATE=YES; SCANTIME=YES; RUN; ... View more

Re: SAS 9.3 proc means problem

by Calcite | Level 5 in SAS Procedures
‎06-09-2014 03:51 PM
‎06-09-2014 03:51 PM
it is a simple categorical variable,  n=75, 3 classes. Results showed Frequency missing =10. The FREQ Procedure flowblr1 flowblr1 Frequency Percent Cumulative Cumulative Frequency Percent borderline 15 20 15 20 low 9 12 24 32 normal 51 68 75 100 Frequency   Missing = 10 ... View more

SAS 9.3 proc means problem

by Calcite | Level 5 in SAS Procedures
‎06-09-2014 03:16 PM
‎06-09-2014 03:16 PM
roblem problemproc I have a variable with 3 classes and n = 75. Proc means and proc freq all count n=85. What is the problem. Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-08-2018 06:22 PM
Likes from
View All
Quick links