Hi everyone, I'm learning usage of arrays and with your comments i would like to take my learning to the next level. I have written a code below to check datatype of variables present in the array. but it is throwing below mentioned errors.     ERROR: There were 1 unclosed %DO statements. The macro DESCRIPTIVE will not be compiled. ERROR: A dummy macro will be compiled.   can anyone suggest how to solve the error and suggest if there is a way to loop over columns. i have tried %do_over but it also started throwing errors. Please guide how to move forward with the issue.   data dummy; input subjid AGE SEX BMI SODIUM INFECTION; cards; 01001 56 F 22.3 34.5 Y 01001 60 M 29.3 41.5 N 01001 35 F 26.3 22.5 Y; 01001 23 M 19.3 34.5 Y; 01001 34 F 18.3 41.5 Y; ; run;   %macro descriptive(dataset,first,last,newcol ); data _null_; set &dataset.; array variables{*} &first. -- &last.; array types{*} &newcol.; %do i=1 %to 7 ; %if %datatyp(variables) eq CHARACTER %then %do; %put variables=; %end; run; %mend descriptive; %descriptive(dataset=dummy, first=AGE ,last=Inefection,newcol=type); ... View more

Hi everyone, i have a data set similar to below with 60 columns(both numeric and character). I'm planning to take then in to loop one by one and perform descriptive analysis. before they enter into the loop they must undergo a checking for their datatype. This is an interesting task which i'm planning to perform by the help of using arrays(as I've heard of the power of using arrays and used before).   After going through several white papers i have came up with a sample untested code and it would be great to have your help to take my array learning to a next level.     Kindly do comment.   data temp; input subjid AGE SEX BMI SODIUM INFECTION; cards; 01001 56 F 22.3 34.5 Y 01001 60 M 29.3 41.5 N 01001 35 F 26.3 22.5 Y; 01001 23 M 19.3 34.5 Y; 01001 34 F 18.3 41.5 Y; ; run;   %macro descriptive(first=, last= ); data _null_; set temp; array variables AGE--INFECTION; %do over variables; %if datatyp(variables[i] eq CHARACTER) %then %do; proc freq data=temp; var variables[i]; run; %end; %else %if datatyp(variables[i] eq NUMERIC) %then %do; proc means data =temp; var variables[i]; run; %end; %mend descriptive;   ... View more

I have  data var; input symptoms; cards; 1. Over the past 1 months, I have coughed 2. Over the past 1 months, I have brought up phlegm (sputum): 3. Over the past 1 months, I have had shortness of breath: 4. Over the past 1 months, I have had attacks of wheezing: 5. During the past 1 months how many severe or very unpleasant attacks of chest trouble have you had? 6 How long did the worst attack of chest trouble last? (Go to question 7 if you had no severe attacks) 7. Over the past 1 months, in an average week, how many good days (with little chest trouble) have you had? 8. If you have a wheeze, is it worse in the morning? ;run;   i would like to extract the character part of the string by supressing 1. 2. 3. ......8. from the beginning of the string. it has to be removed in such a way that the 2nd or 3rd numeric value occurrences shouldn't be affected.     Any ideas how to solve this by using prxchange() would be very helpful . ... View more

data a; input subjid visitc sodium potassium bicarbonate glucose bloodureanitrogen creatinine SGPT SGOT GGT; cards; 01001 3th_visit 12.2 34.2 33.2 33 22 123 90 89 89.3 01001 6th_visit 22.3 41.6 56.1 89 12 133 80 49 39.3 01001 9th_visit 20.2 40.2 23.2 23 12 230 30 99 19.3 01002 3th_visit 13.2 41.2 12.2 13 43 634 65 14 23.2 01002 6th_visit 90.2 21.2 33.2 33 22 123 90 89 89.3 01002 9th_visit 29.2 34.2 30.2 13 12 126 30 29 99.3 ; run;    when i transpose this by below code: proc transpose data=a out=t_a name=variables ; by subjid visit; var sodium--ggt; run;   i have an output similar to below where COL1 is getting a length of 5000 and the values which i can't use for any of the derivation , neither i can use any function to extract the value. example if i use a cat function or compress function to reduce the length or even i tried by assigning a lesser length by mentioning it before set statement so that PDV get the shorter length but it's not working. i have tried to apped the value to nother variable, but its putting missing value there as well.   subjid  visit variables _Label_ COL1 01001 3th_visit sodium 3rdweekvisit  12.2     ANyone who has ever faced this issue kindly do shoot a reply.  ... View more