About dkcundiffMD

dkcundiffMD · ‎02-11-2020

After about 700 lines of analysis code, below is the spot that i am getting error messages. I looked but could not find an absent 'run;" or absent ";". In this nutritional epidemiology data code with SAS 9.4 and SAS Studio, what might be the problem? Thanks. David Cundiff data source6; set source5; *total_mean=&total_mean.; data IHME2017.source; set source6; run; quit; /*Males final LDLc formula components*/ LDLc17mf1s= ERROR 180: Statement is not valid or it is used out of proper order. pmeat17KCLDLs*0.0027261 +rmeat17KCLDLs*0.0390959 +fish17KCLDLs*0.0020772 +milk17KCLDLs*0.0136106 +poultry16KCLDLs*0.0214094 +eggs16KCLDLs *0.0114435 ; *Worldwide plant foods with positive corr with LDLc; LDLc17mf2s= ERROR 180: Statement is not valid or it is used out of proper order. ALCOHOL17MKCLDLs *0.0247706 +sugar17mKCLDLs *0.0501347 +fruits17KCLDLs*0.0152342 +vegetables17KCLDLs *0.0358683 +nutsseeds17KCLDLs *0.0027299; *Negative corr with LDLc only; LDL17mf3s= ERROR 180: Statement is not valid or it is used out of proper order. - wgrains17KCLDLs *0.0063658 -corn17KCLDLs*0.0224283 -rice17KCLDLs*0.0086221 -legumes17KCLDLs *0.0347094 -potatoes17KCLDL*0.0071434 -swtpot16KCLDLs *0.0044873 ; run; quit;

dkcundiffMD · ‎01-17-2020

How do I download the image? Does the image get installed somewhere? I did contact SAS Tech support. Thanks. David Cundiff

dkcundiffMD · ‎01-17-2020

I uninstalled Oracle Virtual Box 6.0 and installed version 5.2. The same error message with a different interface #. I then uninstalled version 5.2 and installed 6.1. The same error message. What next? Thanks. David Cundiff Failed to open a session for the virtual machine SAS University Edition. The VM session was closed before any attempt to power it on. I Result Code: E_FAIL (0x80004005) Component: SessionMachine Interface: ISession {7844aa05-b02e-4cdd-a04f-ade4a762e6b7}

dkcundiffMD · ‎01-16-2020

Yesterday, I was prompted to download and install a later version of Virtual Box (6.0.16-135674-win). The Virtual Box worked earlier today. However, now it does not provide access to online SAS Studio. It gives this error message: Failed to open a session for the virtual machine SAS University Edition. The VM session was closed before any attempt to power it on. Result Code: E_FAIL (0x80004005) Component: SessionMachine Interface: ISession {c0447716-ff5a-4795-b57a-ecd5fffa18a4} Restarting the computer did not solve the problem. What is going on? What should I do? Thanks. David Cundiff

dkcundiffMD · ‎12-16-2019

When I used proc contents instead of proc print, the code imported the data successfully. Thanks to you all. David Cundiff

dkcundiffMD · ‎12-15-2019

I broke the Excel file into less than 1 MB and it would import. At > 3 MB it was hung up. So I have to break my files into < 1 MB sizes? How to do that best? Thanks. David Cundiff

dkcundiffMD · ‎12-15-2019

While the code was running, the log was recording that the data file was being imported. However, the code ran for minutes and never finished. I had to terminate the session. I had changed the file from Excel xls to xlsx. Could that have been the problem?

dkcundiffMD · ‎12-15-2019

I can't copy and paste the log because the submission of the code hangs up and the log never finishes. I can only screenshot it. David Cundiff

dkcundiffMD · ‎12-14-2019

Trying to import a 9.6 MB Excel file with a SAS Excel import snippet leads to hanging up and never completing the import. It got as far as reporting that I successfully created a data set. The same thing happened on my desktop computer as on my laptop with SAS Studio. Code: /** Import an XLSX file. **/ PROC IMPORT DATAFILE="/folders/myfolders/GBDWtedDataDKC2017.xlsx" OUT=WORK.GBDWtedDataDKC2017 DBMS=XLSX REPLACE; RUN; /** Print the results. **/ PROC PRINT DATA=WORK.GBDWtedDataDKC2017; RUN; The log screenshot is attached. Thanks. David Cundiff

dkcundiffMD · ‎12-07-2019

I reinstalled SAS studio. Now i'll know what to do short of reinstalling it if anything like that happens again. Thanks.

dkcundiffMD · ‎12-03-2019

Where is the Tasks and Utilities tab? Thanks.

dkcundiffMD · ‎12-03-2019

That led me to the solution. I worked back from the log to the code. Thanks. David

dkcundiffMD · ‎12-03-2019

Thanks. It's fixed. David

dkcundiffMD · ‎12-03-2019

Thanks, your post led me to find the answer. David

dkcundiffMD · ‎12-03-2019

Using SAS Studio University Edition, I imported a datafile in Excel worksheet, which had 3.1 mb. When printing the datafile the error was "no columns and no rows." The code and log files are attached. Thanks.

Online Status	Offline
Date Last Visited	‎02-04-2024 09:45 PM

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Risk factors combined variable in a multiple regression was not workin...

Re: ERROR: Libref PRODUCTS is not assigned.

ERROR: Libref PRODUCTS is not assigned.

Re: Lost variables between proc reg and proc corr

Re: Lost variables between proc reg and proc corr

Re: Lost variables between proc reg and proc corr

Lost variables between proc reg and proc corr

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: Risk factors combined variable in a multiple regression was not wo...

Re: ERROR: Libref PRODUCTS is not assigned.

Re: ERROR: Libref PRODUCTS is not assigned.

ERROR 180: Statement is not valid or it is used out of proper order.

Re: SAS Studio no longer loads from the Oracle VM VirtualBox

Re: SAS Studio no longer loads from the Oracle VM VirtualBox

SAS Studio no longer loads from the Oracle VM VirtualBox

Re: Excel data file with proc import hangs up without importing

Re: Excel data file with proc import hangs up without importing

Re: Excel data file with proc import hangs up without importing

Re: Excel data file with proc import hangs up without importing

Excel data file with proc import hangs up without importing

Re: Utilities and tasks in navigation pane not shown

Utilities and tasks in navigation pane not shown

Re: Datafile imported successfully then showed no data

Re: Datafile imported successfully then showed no data

Re: Datafile imported successfully then showed no data

Datafile imported successfully then showed no data

SAS Analytics Explorers