Hi Everyone,   I have 2 SAS code. Code 1 is to process data. At the end of Code 1. I get the final/clean data named CLEAN_DATA. For analysis purpose (say Proc means...), I put them all in Code 2.   This will make my code easy to follow.   At the end of code 1, I call "code 2.sas" using the few line below;   ---------------------------------------------------------------------------------------------------------------- filename w3 temp; data _null_; file w3; put '%let ' datafile="CLEAN_DATA" ';'                                 *when I use datafile=CLEAN_DATA without quote, still not work; / '%include "C:\Users\HPNEW\Dropbox\SAS\CODE 2.sas" ;' ; run; %include w3 / source2 ; ----------------------------------------------------------------------------------------------------------------   Code 2 is    proc sort data=&datafile;by date;run; proc means data=&datafile noprint; by date ; var var1 var2..... ---------------------------------------------------------------------------------------------------------------------   It doesnt works.    Could you help me to fix it or suggest a method that works?   Thank you for your help.   HHC     The error notice is:   NOTE: Line generated by the macro variable "DATAFILE". 1 . CLEAN_DATA - 22 200 ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored.   **************************************************************SOLUTION***************************************** %let datafile1=Buy_signal; %let datafile2=Sell_signal; %include "C:\Users\HPNEW\Dropbox\SAS\return_report_1.sas" /lrecl=500; run; ... View more

Hi Everyone,   Could you please help me to add a row of blank at the end of my file?   Thank you,   HHC ... View more

Hi Everyone,   I have a simple question. When I merge data A and data B and want to take a number of variables in B. Yes, I will list all variables needed but Is there any way I dont have to repeated by type "B." B.var1, B.var2...   Thank you,   HC   proc sql; create table sys1 as select a.*, var1, var2 var3 var4 from sys as a left join Ret_Buy_fix_TP_notrail_H4 as b on a.key=b.key;quit;   ... View more

Hi,   I have a data of 100+ variables.  I want to apply the simple operation to all variable: If variable_value >10000 then variable_value=.; I dont want to repeat this line for 100+ line.   So is there any way to array all variables without listing their name so I can get it done?   Also, if I have the first 3 variable that should be excluded from the rule , how can I array all except for them. I can list their 3 name for excluding.    Thank you for your help.   HC   data have; input var1 a b c; cards; 1 10 2 1000000 2 10 3 1 3 10 4 0 4 . 100000 1000000 5 100000 1 2 6 10 2 300000 run; ... View more

Hi Everyone,   I am importing the attached file into SAS. All the Date Time are correctly imported. Somehow, Sas cannot import number. It skips records of data as well, say the tradetime of 8:00:00 , 16:00:00 and 0:00:00.    Could you please help me to correct my code below? Thank you so much for your help.   HHC   data mt4; infile "\book3.txt" firstobs=2 dsd dlm=';' ; informat date yymmdd10. tradetime time11. ; input Rate $ TimeFrame $ date tradetime Open Close High Low adx_main adx_plus adx_minus cci ma50 ma15 ma5 ma25 sar stddev atr demarker force macd_5_15 macd_5_50 macd_15_50 macd_long_main macd_long_signal macd_medium_main macd_medium_signal macd_short_main macd_short_signal rsi_short rsi_long sto_long_fast sto_long_slow sto_short_fast sto_short_slow mfi_14 mfi_24 fractal_up fractal_down Bband130_main Bband130_upper1 Bband130_lower1 Bband130_upper2 Bband130_lower2 Bband130_upper3 Bband130_lower3 ; format date date9. tradetime time8. ; run;   ... View more

Hi Everyone,   I have 2 dataset that have similar variables. One file is for daily and the other file is for monthly. I want to add a term say "_daily" after all variables in daily file and "_monthly" for those in monthly file. Is there any way to do so instead of using the rename one by one?   Thank you.   HC   data have; input time var1x var3; datalines; 1 1 1 2 3 5 1 2 3 ; run;   ... View more

Hi Everyone,   I have a data with variable nameID as below. I want to create separate file for each name AND the NameID colum is deleted from the final file. Then export each file into CSV. So the CSV file only contain var1 var2 (in the below dataset) There are thousand names and I haven't found a way to do it yet. Any help is very much appreciated.   HHC   data have; input name_ID var1 var2; datalines; 1111 2 111 3 6 111 6 9 555 2 2 555 4 5 555 5 4 563 2 2 563 1 1 ; ... View more

Hi Everyone,   I have a start variable having value 1. When value =1, I want to run the below 2 data steps. Of course, I can run the whole process on every single record but it is not optimal. I appreciate it if you could help me. HHC     data have; input start order value; datalines; 0 1 5 0 2 2 0 3 4 0 4 4 0 5 5 0 6 2 0 7 7 0 8 1 0 9 13 0 1 10 5 0 1 56 0 2 26 0 3 46 0 4 46 0 5 18 0 6 58 0 7 8 0 8 2 0 9 100 1 10 5 ; run;     IF START=1 THEN DO THE FOLLOWING PROCESS   data want;     set have; drop aa1-aa10; array a{0:9} aa1-aa10; retain aa:; pct_60=largest((10-10*60/100+1),of a{*}); pct_70=largest((10-10*70/100+1),of a{*}); pct_80=largest((10-10*80/100+1),of a{*}); pct_90=largest((10-10*90/100+1),of a{*}); a{mod(_n_,10)}=value; run; data want; set want; drop pct_25-pct_100 ; if value>=pct_90 then ROC_rank=5; else if value>=pct_80 then ROC_rank=4; else if value>=pct_70 then ROC_rank=3; else if value>=pct_60 then ROC_rank=1.5; else ROC_rank=0.1; run; ... View more