Hi, I found a question in the SAS base certification that I didn't undestand:   input @45 name $10; Which input technique is used in the above statement? a)column input b)formatted input c)list input   Why the correct answer is a? What does it mean insert the column pointer control @45 and tell sas to read the tenth column?   Thanks, Alessandro ... View more

Hi, I use SAS Studio. I made a mistake and I wrote a number instaed of an informat in the input statement. The program is this:   data ex.dat1; input@1 dep 2. @4 num 2; datalines; 34 10 ; run;   Why does the output dataset is this?   34      4   Thanks, Alessandro ... View more

Hi guys, I'm a new SAS programmer so I'm sorry if I ask you an easy question and I use SAS studio. I have a dataset made of 3 variables (qtr code id), I want obtain a dataset with id variable that contains every observations of the input dataset but repeated only once and a number of variables that correspond to the maximum frequency of the id in the input dataset. I ask you if there is a way to get this output with only one proc transpose and not by using two proc transpose and then merge the output. This is my code but it doesn't produce the desired output. data ex.data; input id qtr code $; datalines; 1 2 A 2 3 C 2 1 B 3 2 A 4 3 C 5 1 D 5 1 A 6 3 A ; run; proc transpose data=ex.data out=ex.out; by id; var qtr code; run;   Thanks, Alessandro ... View more