adspace


The below code we are using for creating more than one
macro variables in proc sql using into clause. How we
can use same code to create macro variables vara, varb,
varc instead of var1, var2, var3.?
proc sql noprint;
select count(distinct(patient)) into :var1 - :var3
from dataset1
group by trtreg1c
;
quit;

Answer Posted / gk

ONly Var1 will be assigned based on the distinct patient
count. Var2 & Var3 macro variables will not be created .

We can not use :Vara - :Varc in into clause of select
statement for creating macro variables .Sinxe it is not a
array format.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3674


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2184


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2161


how to generate the test data in sas without input data? : Sas-administrator

1213


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2132


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2322


Hi, If anyone has base SAS certification dumps, please share.

1951


Are you involved in writing the inferential analysis plan? Tables specifications?

4027