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: 
NickA1
‎07-25-2019
  • 20 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Refreshing Data

by Calcite | Level 5 in SAS Programming
‎07-18-2019 08:55 AM
‎07-18-2019 08:55 AM
So I can jus rerun the program and it will add the new data? This seems to not work ... View more

Re: Refreshing Data

by Calcite | Level 5 in SAS Programming
‎07-18-2019 08:23 AM
‎07-18-2019 08:23 AM
What is happening is every day, new data is being added to each variable. So I have stock prices and every day the closing price from the last day should be added in. I am using proc import and none of the names of the file or the sheets is changing. Neither is the number of variables , column names or anything like that. I am simply adding a row of new data at the end of the existing file. ... View more

Refreshing Data

by Calcite | Level 5 in SAS Programming
‎07-17-2019 06:20 PM
‎07-17-2019 06:20 PM
I am importing data from excel, and the file will update everyday. How do I refresh my program without having to create a new program? ... View more

Re: Merged on two variables

by Calcite | Level 5 in SAS Programming
‎07-16-2019 10:34 AM
‎07-16-2019 10:34 AM
proc sort data=Gts_7; by Date; run; proc sort data=Merged5; by Date; run; They were already sorted prior to that first code being run. Thanks. ... View more

Re: Merged on two variables

by Calcite | Level 5 in SAS Programming
‎07-16-2019 10:31 AM
‎07-16-2019 10:31 AM
ERROR: BY variables are not properly sorted on data set WORK.MERGED5. in1=0 Date=. Govt_Yield=. GT=30 Cusip=915217WX7 Yield=. FIRST.GT=0 LAST.GT=0 FIRST.Date=0 LAST.Date=0 _ERROR_=1 _N_=42 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 6 observations read from the data set WORK.GTS_7. NOTE: There were 38 observations read from the data set WORK.MERGED5. WARNING: The data set WORK.FINAL may be incomplete. When this step was stopped there were 5 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.04 seconds ... View more

Merged on two variables

by Calcite | Level 5 in SAS Programming
‎07-16-2019 10:30 AM
‎07-16-2019 10:30 AM
I am looking to merge on two variables, rather than just one. I want to match on both and ID number and a Date.   Thanks     data Final; merge Gts_7 (in=in1) Merged5; by ID Date; if in1; run; ... View more

Re: One to Many Merge

by Calcite | Level 5 in SAS Programming
‎07-15-2019 03:50 PM
‎07-15-2019 03:50 PM
proc sort data=Info2; by cusip; run; proc sort data=Yieldsrenamed; by cusip; run; data Merged; merge Info2 Yieldsrenamed; by cusip; run; ... View more

One to Many Merge

by Calcite | Level 5 in SAS Programming
‎07-15-2019 03:14 PM
‎07-15-2019 03:14 PM
Hi,   How can I do a one to many merge? I have included some sample data.   Data Set 1  ID     Code 1       10 2       10 3       15 4       15 5       30   Data Set 2 ID   Date        1     1/2/2019 1     1/3/2019 1     1/4/2019 3     1/2/2019 3     1/3/2019 3     1/4/2019 2     1/2/2019 2     1/3/2019 2     1/4/2019 4    1/2/2019 4    1/3/2019 4    1/4/2019 5    1/2/2019 5    1/3/2019 5    1/4/2019   Data Set I want: ID   Date          Code 1     1/2/2019   10 1     1/3/2019   10 1     1/4/2019   10 3     1/2/2019   15 3     1/3/2019   15 3     1/4/2019   15 2     1/2/2019   10 2     1/3/2019   10 2     1/4/2019   10 4    1/2/2019    15 4    1/3/2019    15 4    1/4/2019    15 5    1/2/2019    30 5    1/3/2019    30 5    1/4/2019    30         ... View more

Re: Renaming and Removing Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 01:35 PM
‎07-15-2019 01:35 PM
I already specified that this was indeed the case. ... View more

Re: Renaming and Removing Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 12:06 PM
‎07-15-2019 12:06 PM
yes, exactly ... View more

Re: Renaming and Removing Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 11:39 AM
‎07-15-2019 11:39 AM
no but another data set has a variable named cusip. I want to merge these two variables. is it possible to do it without making them the same name? ... View more

Re: Renaming Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 11:36 AM
‎07-15-2019 11:36 AM
but it  didn't rename my variable... ... View more

Re: Renaming Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 11:35 AM
‎07-15-2019 11:35 AM
  49 50 data YieldsRenamed1 (rename=(_LABEL_=cusip)); 51 set Yieldstransposed; 52 run; NOTE: There were 138390 observations read from the data set WORK.YIELDSTRANSPOSED. NOTE: The data set WORK.YIELDSRENAMED1 has 138390 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.07 seconds here is the code from the log  ... View more

Renaming Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 11:24 AM
‎07-15-2019 11:24 AM
I am trying to rename a column after transposing my data, but it wont let me... I keep getting a reference error...anyone know what I'm doing wrong? I ran proc contents and it looks like the variable name Is correct   data YieldsRenamed2 (rename=(_label_=cusip)); set Yieldstransposed; run; ... View more

Re: Renaming and Removing Variables

by Calcite | Level 5 in SAS Programming
‎07-15-2019 10:58 AM
‎07-15-2019 10:58 AM
the variable is called "_label_" but this still didn't work when I tried to rename it   data YieldsRenamed2 (rename=(_label_=cusip)); set Yieldstransposed; run;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-25-2019 12:57 PM
Quick links