Option validvarname=any; works. problem with second solution is, for different input data it will prefix 'n' which is not preferable. ... View more

Why this problem is coming, when I am trying to execute in SAS University Edition and SAS 9.4(desktop edition) but not in SAS Studio 3.8? ... View more

Tried following- proc contents data=new order=varnum out=new1(keep=Name); run; proc print data=new1;run; Not getting sequence in original form in data(new1). ... View more

Q1. Really not seeing the connection between your ABC1 data set an the output. ans- Values of abc1(data2) are calculated on the basis of abc(data1)  Q.2- How Stud3 and Stud4 variables are chosen for table T1?  ans- Because they are having similar credits. Q.3 Why only 3 output sets? ans- Because maximum credits assign is 3. Note- (Stud3 & Stud4) can put in any one of table(t1,t2,t3). ... View more

Having similar credits. ... View more

Expected output is tables which in above case I have created manually(t1,t2,t3) Creation of tables should be in dynamic way. ... View more

data abc; input label$ stud1 stud2 stud3 stud4 stud5; datalines; Sub1 10 20 30 65 12 Sub1 45 12 45 12 23 Sub1 45 12 14 75 32 Sub1 23 45 65 42 32 ; proc print data=abc;run; data abc1; input credit Tscore StudName$; datalines; 2 123 stud1 1 89 stud2 3 154 stud3 3 194 stud4 1 99 stud5 ; proc print data=abc1;run; proc sql; create table t1 as select stud3, stud4 from abc; run; proc sql; create table t2 as select stud2, stud5 from abc; run; proc sql; create table t3 as select stud1 from abc; run; This is how I created tables manually, which should be dynamically created. Also number of tables are equals to max(credit). This will be helpful... Tables are containing columns which are having similar credits. Maximum credit limit in above case is 3(which is user defined) therefore total number of tables will be equals to 3. ... View more

[len(obs) of data2]=[(len(column) of data1)-2]  This line is for reference purpose, which shows if we have 6 columns in data1 then there will be total 4 rows will be there in data2.   credit=K(in this case 5) Above line shows max(credit) for given data. In this case it 5 i.e. credit will not go above 5.   ... View more