proc sql noprint;           select name into :firstvar from dictionary.columns where libname='SASHELP' and memname='CLASS'           and varnum=1; quit; proc print data=sashelp.class (obs=1);           var &firstvar; run; ... View more

It would help if you can post your sample data and code. ... View more

You can use input function to convert Character values to Numeric values. You may change the informat based on your data. For e.g. numvar = input(charvar,best.); ... View more

data test;           length Account Milestone_Period $20;           account = 'SDI';           milestone_period = '2011 Q2';           output;           account = 'SDII';           milestone_period = '2011 Q3';           output; run; data final;           length Measurement $50;           set test;           array test {5} $50 _temporary_ ('Approval Rate','Days to Approval','Fulfillment Rate','Days to Ship','Compliance');           do i = 1 to 5;                     measurement = test(i);                     output;           end;           drop i; run; proc print; var account milestone_period measurement; run; ... View more

You can use 'mod' option to append the text. data test; name1 = 'Dan'; name2 = 'Tom'; name3 = 'Randy'; run; data _null_; file "test.txt" dsd dlm='' mod; set test; put (_all_) (+(-1)); run; ... View more

Ahh...you're right. I thought 'test' was a folder and we need to get the list of .txt files in that folder. ... View more

I guess you need to add a back slash in between 'test' and '*' filename txt pipe 'dir c:\temp\test\*.txt /od'; ... View more

When multiple SET statements are used, number of observations in the new data set is the number of observations in the smallest original data set. If the data sets contain common variables, the values that are read in from the last data set replace those read in from earlier ones. During the third iteration, when the record is read using SET statement from FIRST dataset, the value of 'Common' in PDV is A. However, when the second SET statement is executed, the value of 'Common' (A) in PDV is replaced by 'B' from SECOND dataset. ... View more

Using proc sql: proc sql; create table orig2 as select id,sum(activity) as activity from orig group by id order by id; quit; ... View more

_N_ is the count of observation read from the input dataset and not the observation written to output dataset. In your case, you are subsetting the data and then assigning the value of _N_ to class variable. How about replacing the statement "class=_n_;" with "class+1;" ... View more

data one; input School $ Month $ StudentName $ Subject $ Test1 Test2 Test3 Test4 Total; datalines; ABC July-10 John Math 90 79 86 99 354 ABC July-10 John Science 92 89 99 91 371 ABC July-10 John History 78 69 82 79 308 ABC July-10 John English 81 79 83 82 325 ABC July-10 Becky Math 92 77 76 88 333 ABC July-10 Becky Science 67 76 65 83 291 ABC July-10 Becky History 78 69 76 79 302 ABC July-10 Becky English 90 79 80 81 330 ABC Dec-10 John Math 97 93 89 99 378 ABC Dec-10 John Science 80 89 92 91 352 ABC Dec-10 John History 70 77 76 80 303 ABC Dec-10 John English 80 69 78 81 308 ABC Dec-10 Becky Math 80 70 67 82 299 ABC Dec-10 Becky Science 78 73 66 76 293 ABC Dec-10 Becky History 87 77 79 74 317 ABC Dec-10 Becky English 79 72 84 81 316 ; run; proc sort data=one; by subject studentname; run; proc transpose data=one out=two; id month; var test1 test2 test3 test4 total; by subject studentname; run; proc print; run; *partial output; Subject Name _NAME_ July_10 Dec_10 Math Becky Test1 92 80 Math John Test1 90 97 ... View more