BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phamhhm
Fluorite | Level 6

Hi

1) I download the Apple daily stock market from Yahoo Finance.

2) Import the data into SAS, work perfect.

PROC IMPORT DATAFILE="\AAPL.csv"

OUT=Apple DBMS=CSV REPLACE;

GETNAMES=YES;

RUN;

 

 

3)I set the trading day, work perfect.

DATA APPLETD;

SET Apple;

IF weekday(Date)=2 or weekday(Date)=3 or weekday(Date)=4 or weekday(Date)=5 or weekday(Date)=6;

RUN;

4) Try to use X12, but there is error :

ERROR: Time ID variable Date contains gaps.

 

PROC X12 DATA=APPLETD Date=Date;

VAR AdjClose;

x11;

output out=out a1 d10 d11 d12 d13;

RUN;

TITLE;

 

Thanks for the answers

Minh

1 ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 823 views
  • 0 likes
  • 2 in conversation