About smilingmelbourne

smilingmelbourne · ‎11-12-2017

I reinstalled Win 10 Pro several last week and had a serious issue with installing SAS 9.4. I've been using SAS 9.4 on Win 10 Pro on this laptop for 2 years without a problem. Now, in SAS Deployment Wizard, in Stage 1 with 388 items to install, it took 3 full days to finish just the first 7 items [namely, SAS Private Jave Runtime Enviornment; SAS Deployment Manager; SAS Deployment Support Components; SAS/SECURE Java Component; SAS/SECURE Java Component (Update); SAS Providers for OLE DB (64-bit, English); SAS Providers for OLE DB (32-bit, English) ]. I thought there was some problem with my laptop, so I tried installing it in another PC. Still the same issue. I reinstalled SAS several times in the past on the same laptop and OS without any issue. It ran smoothly, taking about several hours to complete. How to overcome this issue? Thanks much

smilingmelbourne · ‎10-23-2016

Thank you. Looks like I have to downgrade my Windows 10 to Windows 8 in order to install this SAS version.

smilingmelbourne · ‎10-21-2016

Thank you. When I ran the code as you suggested, the following is all the log shows. What does this mean? For Base SAS Software ... Custom version information: 9.4 Image version information: 9.04.01M0P061913

smilingmelbourne · ‎10-20-2016

After upgrading to Windows 10 Pro from Windows 8.1, I no longer can use PROC REG/MODEL, etc., even though I can do all the data manipulation tasks without problems. The log file always shows the error as below: 11 proc reg data = temp; ERROR: Procedure REG not found. 12 model y x; 13 run; When I ran PROC SETINIT, I saw that SAS/STAT has been installed (see the following). ---Base SAS Software 30DEC2016 ---SAS/STAT 30DEC2016 Is there a way to fix this problem? Thank you very much.

smilingmelbourne · ‎11-25-2013

Thanks, but unfortunately it didn't work. The SAS program file icon on my desktop doesn't change.

smilingmelbourne · ‎11-22-2013

Hi, I somehow messed up with the default SAS file/program icon, i.e., the default one looking like this http://www.google.com/imgres?imgurl=https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/images/regicon.gif&imgrefurl=https://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/a000104288.htm&h=36&w=32&sz=1&tbnid=a2BLZerEzjgF-M:&tbnh=36&tbnw=32&zoom=1&usg=__xvGJ4WsGYYD_u3Dk15QGbKKo5bY=&docid=5dqdhkGjkqKqXM&sa=X&ei=H5KPUpvXB-aRiQfk0oDwCg&ved=0CEYQ9QEwAw How can I get back this icon? Thank you

smilingmelbourne · ‎10-15-2012

Hi, I would like to have only the rows that match (by Cusip) across the two tables. I read this one http://www2.sas.com/proceedings/forum2008/178-2008.pdf Sorry I'm still a bit lost. The paper above says that the following codes are exactly 100% the same. And I know that Proc SQL with INNER JOIN statement is the same as the WHERE statement. proc sql; create table inner_sql as select b.transaction , b.item_id , b.qty , b.date , a.sales_id , a.name from sales b, salesperson a where a.sales_id = b.sales_id order by sales_id; quit; data inner_join; merge sales ( in = s ) salesperson ( in = p ); by sales_id; if s and p; run; My codes in the original post return different matches, no matter whether I use INNER JOIN or WHERE statement in the Proc SQL. data merged; 588 merge y1999_ (in=a) cusip (in=b); 589 by cusip; 590 if a & b; 591 run; NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 4857105 observations read from the data set WORK.Y1999_. NOTE: There were 88319 observations read from the data set WORK.CUSIP. NOTE: The data set WORK.MERGED has 3789859 observations and 14 variables. proc sql feedback; 593 create table merged as 594 select a.* 595 from y1999_ as a, cusip as b 596 where a.cusip=b.cusip 597 ; NOTE: Table WORK.MERGED created, with 17955067 rows and 14 columns. Sorry for this inconvenience but I'm a bit lost actually.

smilingmelbourne · ‎10-15-2012

Hi everyone, I guess these codes should be exactly the same; however, the SAS log tells otherwise! It doesn't really make sense to me how the error arises. /* CODES */ data merged; merge y1999_ (in=a) cusip (in=b); by cusip; if a & b; run; proc sql feedback; create table merged as select a.* from y1999_ as a INNER JOIN cusip as b on a.cusip=b.cusip ; quit; /* SAS LOGS Tell Otherwise */ /* For 1st code */ 565 data merged; 566 merge y1999_ (in=a) cusip (in=b); 567 by cusip; 568 if a & b; 569 run; NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 4857105 observations read from the data set WORK.Y1999_. NOTE: There were 88319 observations read from the data set WORK.CUSIP. NOTE: The data set WORK.MERGED has 3789859 observations and 14 variables. /* For 2nd code */ 570 proc sql feedback; 571 create table merged as 572 select a.* 573 from y1999_ as a INNER JOIN cusip as b 574 on a.cusip=b.cusip 575 ; NOTE: Statement transforms to: select .... from WORK.Y1999_ A inner join WORK.CUSIP B on A.cusip = B.CUSIP; NOTE: Table WORK.MERGED created, with 17955067 rows and 14 columns. I guess they should be the same, right? It's an inner join that keep only observations that share the same BY variable from both data sets. I find this a mystery, and just can't figure out why. Can you please help? Thanks a lot

smilingmelbourne · ‎10-01-2012

Thank you for your reply. I couldn't repair the file using your code, but I found your repair statement very useful. I've never known that before. I have re-imported that data set using Proc Dataset rather than the usual copy and paste, and it works. So it leads me to wonder if we should always avoid the usual copy and paste as people often do when copying files among folders, especially with large data sets. We should always use Proc Datasets??? Thanks

smilingmelbourne · ‎10-01-2012

Hi everyone, I have a SAS data set read in from an original .BCP data file. It has over 400,000 observations. When I tried to do something with this data, such as Proc Means or Proc Sort, etc..., I received the following error message. ERROR: Expecting page 8560, got page -1 instead. ERROR: Page validation error while reading Y1999.TRADES199901.DATA. ERROR: File Y1999.TRADES199901.DATA is damaged. I/O processing did not complete. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 162607 observations read from the data set Y1999.TRADES199901. I have Googled for the solution, and found one but that is not really helpful, as I don't really understand what it means. Could you please help?

smilingmelbourne · ‎09-27-2012

I cannot use an array because I don't know which column is sure to be character- /numeric-type. They all are supposed to have corresponding columns of identical types, but because many first observations of a column in a data set may be missing, it is set to character-type. Should I make a macro for converting a column of all data set to its correct type?

smilingmelbourne · ‎09-22-2012

Hi, I have a data set that has 200 columns, named VAR1, VAR2, ..., VAR200, say. I need to rename all these in a data step, something like this. %let realname=A B C D E; /*200 different names*/ ***Create a list of 200 fake vars VAR1, VAR2, ...., VAR200; %macro create_200_vars; %global fakevars; %do i=1 %to 200 %by 1; %let fakevars=&fakevars. VAR&i.; %end; %put &fakevars; %mend create_200_vars; data renamed; set unnamed; /*Dataset with unnamed vars VAR1, VAR2, ..., VAR200*/ do i=1 to 200 by 1; rename VAR&i.=scan(&fakevars., &i.); ***WRONG HERE, but don't know how to fix it in this datastep; end; run; Could you please help? Thanks

smilingmelbourne · ‎09-02-2012

Thank you, Ksharp and DanielSantos! Very helpful!

smilingmelbourne · ‎08-30-2012

Hi, I received from a data vendor a bunch of data files with .bcp file extensions and a little application 'gzip'. They told me to unzip the files and rename them as .txt files before importing into SAS in the usual way. After unzipping these .bcp files, however, I found out that they remain .bcp files. So I came up with a solution myself by opening those unzipped files with Notepad++ and Save Aa them as .txt files. For these files, I was able to import them all into SAS. However, many of the unzipped files are too large to be clicked open in Notepad++, so I could not import them into SAS. Could you please show me how to fix this issue? Each of the files are in several GBs and cannot be openned in Notepad++ or anything to save them as .txt files. I don't know how to read them into SAS. Thanks so much

smilingmelbourne · ‎03-20-2012

Hi, I have a series of data sets of equal size, each one of which has over 100 columns containing numbers. Due to data downloads into Excel, each data set often differs from the others in the data type of the column. For example, column 2 of data set 1 is numeric but column 2 of data set 2 is character. This poses a problem to me because later on I will need to stack up all these data sets vertically. I wrote the following code to convert any columns which are of character types to numeric, so that all data sets will have numeric that will be joined vertically. I don't know why the code doesn't work. Errors occur, and if not, then character columns remain of character types and no conversion at all. *Convert any column of char types to numeric; data sheet1_1; set sheet1 (drop=ISIN); array vars{*}$ _CHARACTER_; *** work on all those columns in the data set that are of character type and ignore those which already are numeric; do i=1 to dim(vars) by 1; vars{i}=input(vars{i},BEST12.); *** convert from char to num; end; run; Can you please help? Thanks a lot

Online Status	Offline
Date Last Visited	‎11-20-2017 08:02 PM

Why it takes forever to install SAS 9.4 on Windows Pro?

Re: proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

Re: proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

Re: How to get back the default SAS file icon?

How to get back the default SAS file icon?

Re: Proc SQL & Data Step INNER JOIN...

Proc SQL & Data Step INNER JOIN...

Re: ERROR: Expecting page 8560, got page -1 instead...

ERROR: Expecting page 8560, got page -1 instead...

Re: Why it takes forever to install SAS 9.4 on Windows Pro?

Re: proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

Re: Proc SQL & Data Step INNER JOIN...

DOW loop vs Proc SQL summary function

Why it takes forever to install SAS 9.4 on Windows Pro?

Re: proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

Re: proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

proc reg, etc. not run in SAS 9.4 TS1M0 on Windows 10

Re: How to get back the default SAS file icon?

How to get back the default SAS file icon?

Re: Proc SQL & Data Step INNER JOIN...

Proc SQL & Data Step INNER JOIN...

Re: ERROR: Expecting page 8560, got page -1 instead...

ERROR: Expecting page 8560, got page -1 instead...

Re: How to write a macro for renaming lots of variables?

How to write a macro for renaming lots of variables?

Re: How to import a .bcp files?

How to import a .bcp files?

convert char to num for all _CHARACTER_