Hello,
I want to make the difference between date in year ( date format is mmddyy10.)
I write this program but it does not work
data ageyear;
set inception;
Age = yrdif(Inception_date, sas_date, 'AGEYear');
run;
... View more
hello,
I have date format yymmn6. I want to change it to MMDDYY10.
by adding the last day of the month
have : 198605
want 05/31/1986
thanks
... View more
hello,
I have date format yymmn6. I want to change it to MMDDYY10.
by adding the last day of the month
have : 198605
want 05/31/1986
thanks
... View more
hello
I want to transform date format to year
data _7_Morningstar_Data2_expense; set _7_Morningstar_Data_expense; sas_date = input(put(date, 40.), YEAR.); format sas_date YEAR.; run;
... View more
Hello,
Can you help me for the if statement of this program. my date format is yymmn6.
data data_IMF_PCSS;
set data_IMF_PCSS;
if sas_date between '202001' and '202112'D then ID=1 else ID=0 ;
run;
... View more
the log give this
Physical Name: C:\MaRecherche\IPO\data_full_sample
38 proc import datafile = 'C:\MaRecherche\IPO\data_full_sample\PMS_data_MS_Global.xlsx' DBMS = xlsx
38 ! OUT = Global_MS ; options msglevel=i; sheet="Monthly_equity_style_box";
39
NOTE: VARCHAR data type is not supported by the V9 engine. Variable SecId has been converted to CHAR
data type.
NOTE: VARCHAR data type is not supported by the V9 engine. Variable 19840101 has been converted to
CHAR data type.
NOTE: VARCHAR data type is not supported by the V9 engine. Variable 19840201 has been converted to
CHAR data type.
NOTE: VARCHAR data type is not supported by the V9 engine. Variable 19840301 has been converted to
CHAR data type.
NOTE: VARCHAR data type is not supported by the V9 engine. Variable 19840401 has been converted to
CHAR data type.
NOTE: VARCHAR data type is not supported by the V9 engine. Variable 19840501 has been converted to
proc transpose does not give any error in the log just the file is empty
proc transpose data=Global_MS out=_7_Morningstar_Data ;
by Secid;
run;
91 /****** TRANSPOSER LA TABLE **********/
92 proc transpose data=Global_MS out=_7_Morningstar_Data ;
93 by Secid;
94 run;
NOTE: No variables to transpose.
NOTE: There were 27177 observations read from the data set WORK.GLOBAL_MS.
NOTE: The data set WORK._7_MORNINGSTAR_DATA has 0 observations and 3 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.11 seconds
cpu time 0.06 seconds
when I run proc contents I have
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
2 30682 Char 1 $1. $1. 30682
3 30713 Char 1 $1. $1. 30713
4 30742 Char 1 $1. $1. 30742
5 30773 Char 9 $9. $9. 30773
6 30803 Char 9 $9. $9. 30803
7 30834 Char 11 $11. $11. 30834
8 30864 Char 1 $1. $1. 30864
9 30895 Char 1 $1. $1. 30895
10 30926 Char 11 $11. $11. 30926
11 30956 Char 11 $11. $11. 30956
12 30987 Char 9 $9. $9. 30987
13 31017 Char 11 $11. $11. 31017
... View more
I have this error in the log when importing
OTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I.
... View more
the problem is importing from excel
when I import the date will be a text $1.
I have this error from you program
ERROR: "20" is not a valid name.
thanks for your help
... View more
hello
I try to run proc transpose but it does not work. there is no erro in log but the data generated is empty.
my data looks like. the problem is that the date format is $12. as I import it as text from excel
/****** TRANSPOSER LA TABLE **********/
proc transpose data=Global_MS out=style_box ;
by SecId;
run;
have
secid 20020201 20020301 20020401
1 Large small large
2 small small large
want
secid date style
1 20020201 Large
1 20020301 small
1 20020401 large
2 20020201 small
2 20020301 small
2 20020401 large
... View more
Hello,
I want to select the N first observations by id. I tried these programs but they did not work
/*****select 1200 first observations by id*/
proc sql outobs=1200;
create table US_Stock_IPO_1200 as
select *
from US_stock
group by GVKEY;
run;
data US_Stock_IPO_1200;
set US_stock;
if _N_<=1200 then output;
by GVKEY;
run;
... View more
Hi Reeza,
Thanks for your help
it doses not work. is there any way to put date in excel in the good format. I put date in excel in date format so date is like 1 january 1999?
... View more
