Hi, Can you post desire output. I am guessing..... proc summary data=test noprint;      class subject;        var visit;      output out=avg(drop=_type_) sum=Sum mean=Mean ;             run; Thanks, Shiva ... View more

Hi, Try this... data one; input id time timestamp; cards; 1 1 123 1 1 124 1 1 125 1 2 126 1 2 127 1 2 128 1 3 129 1 3 130 1 3 131 2 1 132 2 1 133 2 1 134 2 2 135 2 2 136 2 2 137 2 3 138 2 3 139 2 3 140 ; run; data want; set one; by id time; if first.id or first.time then   first_time =1; else first_time =0; run; Thanks, Shiva ... View more

Hi, Try this...Hope it helps data lookup; infile cards dlm=','; input code $ description $ 30.; cards; 1,Broadway 2,Lindell 3,Chouteau 4a,Peachtree 5,Del Rey 6,Grand 7,Pershing B8,Adobe 9,Revillo 10,Menard ; run; data fmt (keep=FMTNAME START END LABEL TYPE); length FMTNAME $30. START END $256.; set WORK.lookup;       FMTNAME = 'desc' ;       START   = code;       END     = START;       LABEL   = description;       TYPE    = 'C' ; run; proc format cntlin=fmt lib=work; run; data want; infile cards dsd dlm=','; length name addr city st zip $ 20.; input custid name $ addr $ city $st $ zip $ code1 $ code2 $ code3 $ code4 $; codedesc1=put(code1,$desc.); codedesc2=put(code2,$desc.); codedesc3=put(code3,$desc.); codedesc4=put(code4,$desc.); cards; 29348,Frands,101 Main,Centerville,AZ,85522,1,5,, 29074,Frenchs,108 South,Midvale,CA,92141,5,6,7, 23947,Alberts,52 Grant,Jefferson,MI,50852,4a,5,3,4a 92347,Ralphs,786 Hanley,Lewis,KS,60503,4a,2,2,1 32047,Kroger,567 Frost,Scottsdale,TX,45221,6,4a,7,6 29347,AP,678 Barton,Phoenix,AZ,84502,9,B8,4a, 94594,Aldi,901 Wilson,Mesa,AZ,86522,2,1,5,4a 93475,Meijer,345 12th,San Dimas,CA,92622,3,3,, 93479,Bass,354 Appletree,Bernard,WA,90255,1,6,6, 47349,Culvers,987 Peartree,Manzanita,NV,81511,1,5,7, 34978,Mr B,498 Figtree,Leonard,PA,20611,5,4a,, ; run; Thanks, Shiva ... View more

Hi, Try this links... http://www.sascommunity.org/wiki/Quiet_Install SAS 9.2 Silent Install [Success] @ The Decoder Wheel Thanks, Shiva ... View more

Hi Raja, Try this... proc sql noprint;     select rate     into :alp1 - :alp%left(&nob.)     from mydata; quit; Thanks, Shiva ... View more

Hi, You can assign you libname to SASINTRO like Libname SASINTRO 'F:\test'; proc print data=sasintro.pilotdata; run; Thanks, Shiva ... View more

Hi, You can get in touch with Customer advocacy team or tech support team.If you are in India please find the mail id. incustomer.advocacy@sas.com. SAS does Webinar training's for the Partner customers.Recently they have done webinars on SAS DI/BI certifications courses as well. Hope it helps. Thanks, Shiva ... View more

Hi, In DI Studio, the column names cannot be named dynamically. Alternative method: Use transpose transformation: inside the transpose transformation properties, in the options tab where you assign your ID and VAR values, click on the "Additional options" on the left and set the "Update the metadata for the target tables" to yes But, each time you run your job you will get a prompt that asks if you want to update the metadata, click yes , your ID values that you want to transpose will be in the output table. Hope this helps. Thanks, Shiva ... View more