About Ken_oy

Ken_oy · ‎06-27-2013

Hi everyone, I have a large dataset which contains more than 150 variables. I want to drop some of those variables which have a "flag" in the variable name, for example: Q15_flag. I try to use (:), like drop :flag. but it did not work that way. Any help? Thanks!

Ken_oy · ‎05-29-2013

, I am running a local PC with SAS 9.3 installed. I do use Windows Task Manager. Actually, have to say, I need to keep Task Manager open while I am using EG 4.3, because I have to use it to force-close my always frozen EG. The stop function in EG does not work at all. In the task manager, I also have to force-close all running sas.exe after force-closing EG. Otherwise, my pc would run out of memories. I just find that if I zoom in/out my "Process Flow" window while the EG is running the programs, I will definitely make my EG frozen. If I do not touch anything after clicking "run branch from XXX" then I will probably, not 100%, have my EG successfully run. By the way, where/how can I upgrade to EG 5.1? Thanks SASKiwi!

Ken_oy · ‎05-29-2013

I tried the following options: in tab "tools": result -> results generral, I left the following boxes empty: [ ] replace without prompting [ ] show generated wrapper code [ ] automatically open data or results [ ] link handcoded ods result then, set report to 'text' only and data -> data generral [ ] automatically open data when added to project. then I did have high probability to run my enterprise successfully without getting the "collecting" message. (from 0% before to now 10%, roughly, lol). I have SAS 9.3 installed, can I upgrade my SAS enterprise guide from 4.3 to 5.1? It seems there is no way to fix this "collecting status" issue in 4.3.

Ken_oy · ‎05-28-2013

, thanks for the addvice. I tried what you suggested, but still, I got the same "collecting" status. I also tried to set the maximum to 100, it did not work either.

Ken_oy · ‎05-28-2013

I just started using Enterprise Guide for a couple weeks. I noticed that my SAS enterprise guide 4.3 was frozen several times with a "collecting" status at the bottom of the enterprise guide windows. I tested my programs on SAS 9.3, and they run correctly. And I also tested all the same programs on SAS enterprise 4.3 step by step separately, and they run just fine. But if I tried to run from step1 to the last step by choosing "run from step1" then the whole Enterprise Guide 4.3 would be frozen somewhere for ever with a "collecting" status. I installed "Integration Technologies Client 9.3", as SAS help suggested, but I don't know how to configure the Integration Technologies Client 9.3. 44627 - Performance is slow when SAS® Enterprise Guide® is collecting results Any easier way to fix this? Thanks!

Ken_oy · ‎04-12-2013

@data_null and @ballardw, thanks for the quick reply! Just one more question. If I want to put "0.050" in a string, for example I may try to use "call symput" to make a &pvalue=0.050, then how can I do? Thanks again!

Ken_oy · ‎04-12-2013

Hi everyone, I was creating a statistical report and wanted to have a p-value with 3 digits. I got p=0.0501, but if I rounded it to 0.001 then I would have a p=0.05. How can I keep the last zero? I used compress or compbl to make it into a string, but they did not work. Any suggestions? Thanks.

Ken_oy · ‎03-18-2013

Thanks for the quick reply. your code works great. it makes me recall how I looked for the "where notin (xxx)" statement. :smileylaugh:

Ken_oy · ‎03-18-2013

Hello I am looking for a command (not missing?) that I can do the following: if string1 'NOTMISSING' then test_string=1; I tried: if string1 then test_string=1; but it did not work correctly. Any suggestions? Thanks.

Ken_oy · ‎03-15-2013

, I added the new WORK location to MS essentials, and till now no more such kind of errors. It seems like a MS essential authorization related issue. Thanks for the suggestion!

Ken_oy · ‎03-12-2013

I started getting this error after I switched to Windows7 with SAS 9.3. This error happens randomly, especially after running long programs or macro do loops. If I delete everything in the "results" window, or run macros one by one instead using loops, I would rarely see this errors. I am not sure if it is a memory related issue. I got a intel i7 3.4Ghz 64bit windows7 machine with 16G of RAM. I did a search on google, I redirected my WORK folder to the root of my C:\ as someone suggested, but it does not help. I also tried to direct my log file, output file to other directory, but it did not help either. Anyone encounters the same issue? Any suggestions? I would appreciate your help. errors in log windows: " NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 57:93 57:120 60:93 60:120 63:69 NOTE: There were 15 observations read from the data set WORK._COUNTS. NOTE: The data set WORK.FLAG_TOTAL_STUDY_COORDINATOR_ has 3 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: User does not have appropriate authorization level for library WORK. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds "

Ken_oy · ‎03-05-2013

Hi, everyone, I try to use "call symput" do the following step, I want to do: data test; call symput("test_name", "Kid's First Test"); run; %put &test1; but I don't think in my code the "call symput" can deal with a string with a " ' ". Any help? thanks.

Ken_oy · ‎02-20-2013

Cythia, thank you so much for your work! I read your code carefully, and found out I copy/paste an unnecessary command "asis=on" to my ODS coding. I made the following change in PROC REPORT and my problem solved: from: define Variablename /display "Yes" STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=0.91 in just=c}; to: define Variablename /display "Yes" STYLE(COLUMN)={ PROTECTSPECIALCHARS=off cellwidth=0.91 in just=c};

Ken_oy · ‎02-19-2013

Please see attached picture. In the "Question" Column, words was splitted to the next line. How to fix this? Thanks!

Ken_oy · ‎11-20-2012

I just install my SAS 9.3 this morning. I found the 9.3 was generating plots while I run proc glm or reg. How to let it stop making those plots? Thanks.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

how to use "do loop" with skips?

Re: How to check if a macro variable is blank

How to check if a macro variable is blank

Re: Cannot modify a dataset after using %SYSFUNC

Re: Cannot modify a dataset after using %SYSFUNC

Cannot modify a dataset after using %SYSFUNC

Re: Fill missing data points in table, need help

Fill missing data points in table, need help

Re: how to drop a series of variables in SAS

how to drop a series of variables in SAS

Re: How to check if a macro variable is blank

Re: Cannot modify a dataset after using %SYSFUNC

Re: Fill missing data points in table, need help

Re: how to drop a series of variables in SAS

Re: how to drop a series of variables in SAS

Re: how to avoid forever "collecting" status?

How to drop a series of variables?

Re: how to avoid forever "collecting" status?

Re: how to avoid forever "collecting" status?

Re: how to avoid forever "collecting" status?

how to avoid forever "collecting" status?

Re: How to keep the last "0" in a string?

How to keep the last "0" in a string?

Re: how to search a "not missing" string in data step?

how to search a "not missing" string in data step?

Re: Error: User does not have appropriate authorization level for libr...

Error: User does not have appropriate authorization level for library ...

"call symput" for a string with " ' "?

Re: splitted words in ODS pdf output

splitted words in ODS pdf output

In SAS 9.3 how to tell GLM/REG to stop generating plot in my program f...