About JohnSAScom

JohnSAScom · ‎08-22-2017

Can you tell me if the program is embedded or not? To find out: Right-click on the program Left-click on Properties Under the General tab, check the Embed button. If it's not greyed-out, then it's not embedded, and there is a physical file location in the File path text box. That means your program is stored separately from your EG project. If it was moved, renamed or deleted, your EG project won't have access to it anymore.

JohnSAScom · ‎08-14-2017

A possible solution: data disease; input ID INTERVAL INFECT_X INFECT_Y; datalines; 1 1.1 1 0 1 1.4 0 0 1 1.5 0 1 2 2.4 0 1 2 2.6 1 0 3 1.6 0 1 3 1.9 1 0 3 2.0 0 1 4 2.2 0 0 4 2.4 0 0 ; data disease1 (drop=INT); set disease; by ID; retain INT 8; length NEWVAR 8; if first.ID then do; INT = INTERVAL; NEWVAR = 0; end; if INFECT_X = 1 then INT=INTERVAL; if INFECT_Y = 1 and INTERVAL > INT then NEWVAR = 1; else NEWVAR = 0; run; proc sql; create table NEWVARS as select distinct(ID), NEWVAR from disease1 where NEWVAR = 1; create table disease2 as select a.ID, a.INTERVAL, a.INFECT_X, a.INFECT_Y, b.NEWVAR from disease1 a left join NEWVARS b on a.ID = b.ID order by ID, INTERVAL; update disease2 set NEWVAR = 0 where NEWVAR = .; quit;

JohnSAScom · ‎08-11-2017

Another option would be to open your file, save it under a different name and perform 2 search and replacements: replace the double-quotation marks with nothing, and replace all tabs with a space. To replace the tabs with a space, you would first have to copy a tab character from your data, and then paste it into the search and replace window as the item to search for. Then do a "Replace All". After that, this would work: data one; infile 'C:\MyPath\SASHelpExample.txt' firstobs=2; input Revenue_Amount Priority_Line $ Revenue_Year Revenue_Month Legacy_Customer_Numer SAP_Customer_Number; run;

JohnSAScom · ‎08-09-2017

Glad I could help Have a great day,

JohnSAScom · ‎08-08-2017

Hi @metadata, Would something like this work? data local; row_id = 1; x=1;y=2;z=3;a=4; output; row_id = 2; x=6;y=7;z=1;a=7; output; run; data cloud; row_id = 1; x=1;y=2;z=3;a=5; output; row_id = 2; x=6;y=7;z=1;a=7; output; run; proc sql; create table diff as select f1.x, f2.x as x_cloud, f1.y, f2.y as y_cloud, f1.z, f2.z as z_cloud, f1.a, f2.a as a_cloud from local f1 inner join cloud f2 on f1.row_id = f2.row_id where f1.x <> f2.x or f1.y <> f2.y or f1.z <> f2.z or f1.a <> f2.a ; quit;

JohnSAScom · ‎08-03-2017

Hi Linda, You can't really "disable" the short-cut keys per say, but you can re-program them to do nothing: From the list of pull-down menus across the top, start with Program, then Editor Macros -> Record New -> hit the space bar once and then hit the backspace key once to delete the space you just typed -> Program - > Editor Macros - > Stop Recording -> enter a name for your new "do-nothing" macro in the Keyboard macro name text box -> click on the Assign keys button -> place your cursor in the Press new shortcut key text box -> press the F8 key -> click on the Assign button -> click Ok Note that if you delete this "do-nothing" macro that you just created, the F8 key will go back to doing what it did before. A bit of a round-about approach, but if you really want the F8 key to do nothing when you hit it, this will work. John

JohnSAScom · ‎06-16-2017

The "Concurrent Sessions" part makes me speculate that maybe you are running more than one instance of EG at the same time. Is that true?

JohnSAScom · ‎06-15-2017

Another possibility that may be simpler and does not rely on dropping variables: data new; set old; length repdate 8; retain repdate; if _n_ = 1 then do; if date2 ne . then repdate = date2; end; else do; if date2 = . then date2 = repdate; else repdate = date2; end; run;

JohnSAScom · ‎06-15-2017

Hi, Is there a SAS function to verify if a given SAS date literal value is a valid date? For example, if I had the date literal "35feb95", is there a function I could pass it to and have it tell me that it is not a valid date?

JohnSAScom · ‎06-14-2017

Hi, I should have specified PCFILES as the engine, not EXCEL: This works: LIBNAME MyLibRef PCFILES "C:\MYPATH\MYEXCEL.XLS" ; Thank you, I appreciate your help.

JohnSAScom · ‎06-14-2017

Hi, LIBNAME MyLibRef EXCEL "C:\MYPATH\MYEXCEL.XLS" ; gives me errors. Any ideas on what's wrong? I'm using SAS 9.3 and Excel 2013.

JohnSAScom · ‎10-24-2016

Here's a version that doesn't rely on dropping or re-naming data set variables: A couple of notes: Missing values for character variables are represented by a blank. Data set variable names can only contain letters, numbers and underscores. This is one solution: data question; ID = 1; Cycle = 1; Date = '1/01/2016'; output; ID = 1; Cycle = 2; Date = '2/02/2016'; output; ID = 1; Cycle = 3; Date = ''; output; ID = 2; Cycle = 1; Date = ''; output; ID = 2; Cycle = 2; Date = ''; output; ID = 2; Cycle = 3; Date = ''; output; ID = 3; Cycle = 1; Date = '3/04/2016'; output; ID = 3; Cycle = 2; Date = '4/12/2016'; output; ID = 3; Cycle = 3; Date = '5/06/2016'; output; ID = 3; Cycle = 4; Date = ''; output; ID = 4; Cycle = 1; Date = ''; output; ID = 5; Cycle = 1; Date = '8/16/2015'; output; ID = 5; Cycle = 2; Date = '9/01/2016'; output; run; %macro a; proc sort data=question; by ID Cycle; run; proc sql noprint; select count(distinct(ID)) into:distinct_IDs from question; quit; %do i = 1 %to &distinct_IDs.; proc sql noprint; create table unique_id as select * from question where ID = &i.; select count(*) into:TOTAL from unique_id; select count(*) into:MISSING from unique_id where Date = ''; quit; %if &MISSING. gt 0 and &TOTAL. ne &MISSING. %then %do; data _null_; set unique_id; if Date ne '' then call symput('last_date', Date); run; proc sql noprint; update question set Date = "&last_date." where Date = '' and ID = &i.; quit; %end; %end; %mend a; %a; Thank you, John

JohnSAScom · ‎07-20-2016

Hi Tim and Cynthia, Sorry for the long delay. When I visited the user I asked them to try it again, and it worked without error. They could not explain why and neither could I. I checked RSASUSER in the config file and it looked ok. I also checked to see if they were able to write to the directory that the SASUSER.TEMPLAT library is mapped to, and they are were. The fact that the issue "resolved itself" is not very satisfying from a technical standpoint, and I suspect it may arise again. I'll keep posting updates if the issue resurfaces. Thank you, John

JohnSAScom · ‎07-14-2016

Hi Tim, Great questions! I'll get the answers and get back to you... Thank you, John

JohnSAScom · ‎07-14-2016

Hi Cynthia, The ODS PATH for the "non-working" person looks ok: Current ODS PATH list is: 1. SASUSER.TEMPLAT(UPDATE) 2. SASHELP.TMPLMST(READ) I assume it's ok for the "working" person as well. They both have SAS locally-installed on their workstations. Could this have something to do with their user profiles? I'll try your suggestion... Thank you, John

Online Status	Offline
Date Last Visited	‎01-23-2020 06:31 PM

Re: SAS logs

SAS logs

Remote session ID

Re: Character to Numeric conversion issues

Re: Character to Numeric conversion issues

Re: Character to Numeric conversion issues

Character to Numeric conversion issues

Re: Dropping a variable from a SAS dataset

Re: Dropping a variable from a SAS dataset

Re: Renaming variables in a SAS dataset

Re: PROC FORMAT, font weight and ODS

Re: Changing a wide dataset to a long dataset

Re: Sequential variable problem, please help!

Re: Sequential variable problem, please help!

Re: Proc Transpose help - "Name of Former Variable" column not recogni...

Re: List all differences between two datasets in another dataset

Re: How to disable Enterprise Guide Short-cut keys

Re: How do I replace missing value with previous value, but leave dupl...

Re: Defining macro variable by cases

Re: The file associated with this view could not be located.

Re: Sequential variable problem, please help!

Re: Code To Import Non-delimited file when first variable contains val...

Re: How to disable Enterprise Guide Short-cut keys

Re: List all differences between two datasets in another dataset

Re: How to disable Enterprise Guide Short-cut keys

Re: Different connections to databases

Re: How to repeat value until the next value and then repeat that

Verifying the validity of a SAS date literal.

Re: Opening an Excel workbook using LIBNAME

Opening an Excel workbook using LIBNAME

Re: How do I replace missing value with previous value, but leave dupl...

Re: PROC TEMPLATE: Unable to write to template store

Re: PROC TEMPLATE: Unable to write to template store

Re: PROC TEMPLATE: Unable to write to template store