SAS Support Communities

I want to do: %DO i = 1 %to 100; but I want to skip some numbers, e.g. let said 9, and 50; My code is: %DO i = 1 %TO 8; %FUNC; %END; %DO i = 10 %TO 49; %FUNC; %END; %DO i = 51 %TO 100; %FUNC; %END; Is there any way to make it more efficient? Thanks!! ... View more

I tried to do: data test; test1; Var1 = Column_&col1.; run; But if the "&col" is empty then I would get a error warning in the log file. Is there a way to check whether my macro variable "&col" is empty? I tried : %if %length(&col.) = 0 %then %let col=blank; but it turned out the %length(&col) = 4; Any suggestions? Thanks! ... View more

I keep getting this message after using %SYSFUNC: ERROR: You cannot open WORK.OUT_14.DATA for output access with member-level control because WORK.TEMP_DATA.DATA is in use by you in resource environment DMS Process. I tried to make a macro variable to show how many columns in my SAS dataset. I used the code: %let nvar=%sysfunc(attrn(%sysfunc(open(work.temp_data,i)),nvars)); but after using this code, I cannot modify TEMP_DATA any more. Any suggestions? Thanks!! ... View more

I cannot write my own %do %until code to do what I wanted to do. I have a dataset (please see the first table. I want to convert the first table into the second table. Any missing status in between two "1"s should be marked as "1". Any help? Thanks!! ----- ID Status 1 Status 2 Status 3 Status 4 Status 5 Status 6 1 1 . . 1 . . 2 . 1 . 1 . . 3 1 . . . . 1 4 . 1 . . . . o, neeStatus 1 ID Status 1 Status 2 Status 3 Status 4 Status 5 Status 6 1 1 1 1 1 . . 2 . 1 1 1 . . 3 1 1 1. 1. 1. 1 4 . 1 . . . . Status 1 ... View more

I want to drop/delete F1_flag, F2_flag, F3_flag, .... F99_flag from my dataset. How can I do this efficiently? Thanks ... View more

I want to add a group number to the first dataset (see the second one). Does anyone know how? I cannot use sort because some categories have the same name. I can only determine the group by the existing data order. Thanks! dataset 1: a a b b b c c d d d b b dataset 2: a 1 a 1 b 2 b 2 b 2 c 3 c 3 d 4 d 4 d 4 b 5 b 5 ... View more

In the original SAS program, I could use "ods output" to export some of the results from some Proc procedures, I could make those p-values from t-tests, or means or SDs into a new data sets For example: ods output "Summary statistics"=means; proc means data=meg1 mean stderr q1 q3; class num velocity; var p; run; ods output close; In this step I can export the Proc means result in to dataset "means". I could see "Summary statistics" was listed on the left side for the SAS program "Result" window, so I could use the ODS OUTPUT statement to export it into a new data set. But in SAS enterprise guide there is no such "result" window, how can I do it? How to export procedure results into new datasets? Thanks! ... View more