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: 
ovonel
‎08-27-2016
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Blanks in first few columns

by Calcite | Level 5 in SAS Programming
‎08-20-2016 06:32 AM
‎08-20-2016 06:32 AM
Hi. Thanks.   I am aware of column input, however M10 becomes the ID and the rest moves to the left.   ID in 2nd row is supposed to be blank.   The MISSOVER in infile does not help. ... View more

Blanks in first few columns

by Calcite | Level 5 in SAS Programming
‎08-20-2016 04:31 AM
‎08-20-2016 04:31 AM
Hi   I have 2 lines of data below. The 1st three characters are for ID, however 2nd row is missing the ID.   How can I read this file properly with the INFILE statement? MISSOVER doesn't work in this case.   193F1010790815950407011206811      M1015950215960408009805410   Thank you ... View more

Re: Error when loading external file

by Calcite | Level 5 in SAS Enterprise Guide
‎08-18-2016 09:29 AM
‎08-18-2016 09:29 AM
Hi Kurt,   I am not too sure.   I need to connect to VPN in order to see my network drive and also allow my EG (Installed on my PC) to run on the server.   I suppose that is remote with EG as front end.   Regards   ... View more

Error when loading external file

by Calcite | Level 5 in SAS Enterprise Guide
‎08-18-2016 09:08 AM
‎08-18-2016 09:08 AM
Hi,   I have a .dat file hosted in a network drive, V. EG is installed in my computer but connects to a server via VPN.   FILENAME QNS2 "V:\Data Library\ABC_X.dat"; DATA HELLO; INFILE QNS2; INPUT @1 ID $3. @4 VISIT $6. @10 DX $2; RUN;   I have the error below. I am at my wits end.   May I know how to solve this?   ERROR: Physical file does not exist, V:\Data Library\ABC_X.dat. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.ABC_X may be incomplete. When this step was stopped there were 0 observations and 8 variables. WARNING: Data set WORK,ABC_X was not replaced because this step was stopped. ... View more

Re: NODUPKEY with PROC SORT

by Calcite | Level 5 in SAS Programming
‎08-14-2016 08:57 AM
‎08-14-2016 08:57 AM
Thank you. Appreciated.   I had thought of NODUPKEY as a quick solution as I assumed there is no 2 or more IDs with the same date. ... View more

NODUPKEY with PROC SORT

by Calcite | Level 5 in SAS Programming
‎08-14-2016 06:45 AM
‎08-14-2016 06:45 AM
Hi, i have the table PROC SORT by ID then Descending Date.   However ID 033 has 2 instances with the same date and NODUPKEY only picks up the 1st instance.   Is it possible to pick up ID 033's 2 instances? My idea is to pick up each ID's latest date.   Thank you.   ID DATE CODE 009 123195 03 009 101595 01 009 090995 07 033 101095 07 033 101095 03 033 090995 02 033 051894 01 033 010594 07 045 122195 06 045 103195 05 045 102195 05 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-27-2016 12:09 PM
Quick links