Hi I have a table of labtesting where i have the columns cardio ,Repiratory ,abdomen etc.How to find the frequncy and percent of values in those columns(under cardio i have NAD NS S1S2N).My resulting table shud look like the below. N Percent Cardio NAD 5 25 Ns 10 30 S1S2N 5 25 Respiratory Clear NVBS 5 25 NAD 10 30 Central Nervous System Clinically N 12 45 NAD 5 35 ... View more

Hi I have to tabulate the N,mean,stddev of acess data set. My code for that is below proc means data=Sasuser.ClinicalExam nonobs n mean stddev maxdec=2; label pulse = 'pulse' Bpsytolic = 'Systolic BP' BpDiastolic = 'Diastolic BP'; Var pulse bpsys bpdias; run; My result is having 5 columns : variable label N mean stddev but i shud have only the below in result : Label N Mean Stddev how to ignore Variable column fro the result ? ... View more

I have a text file test.txt like this : This is class room 1 ID STUDENTNAME AGE WEIGHT(pounds) 1 Robert 13 70 2 Mary 12 75 3 Nicole 11 79 This is class room 2 ID STUDENTNAME AGE WEIGHT(pounds) 4 charles 15 80 5 Kathy 14 85 6 Jen 10 70 The above is test.txt file.I have to import it as data set given below: ID STUDENTNAME AGE WEIGHT(pounds) 1 Robert 13 70 2 Mary 12 75 3 Nicole 11 79 4 charles 15 80 5 Kathy 14 85 6 Jen 10 70 ... View more

I have to export a data set to text file.But the values should not be separated by any delimiter including the default delimiter.I mean the text file values should not be separated by space or comma or any thing.Can any one please help me out how to do this? ... View more