hi, good answer. can you help me the similar as below Empid   year    salary 1         2011    11 1         2012    13 1         2013     20 2         2011     44       2         2012     22 2         2013     88 Requirement:    Need a 4th column representing percentage of salary change for an empid  by years.                                              datastep->lag function-> we can do                                               proc sql-> how to do this? thanks in advance. ... View more

hi, thanks a lot. ... View more

hi, As per my understand, if we are not mentioning type column it will create format default(numeric/character name depnds on the fmtname ) But if we mention (i,j) as types then it will create informats. if my assumption is wrong,let me know. ... View more

thanks for the reply. I understood. the interviewer asked me this question ... View more

hi, thanks for the reply. I know  for creating a format from a dataset ,3 varibles are enough(fmtname,start,label). suppose my dataset not having a type column and I am using cntlin option for creating the format/informat. then how sas is creating the formats/informats. I tried with your example only, used the cntlout option to create a dataset from the format and after that I deleted the formats in catalog and dropped the type column in dataset and again used the option cntlin option to create a format/informat from the dataset. then you can find the log here. 9290  proc format cntlin=dataset   fmtlib ; NOTE: Format A has been output. NOTE: Format B has been output. NOTE: Format C has been output. NOTE: Format D could not be written because it has the same name as an Institute-supplied format. what is  error here? ... View more

hi, could u please answer this one.  question:  sas has to create a value/invalue statements for the given dataset (cntlin option for dataset2format convertion).based on what, it is creating value/invalue statements or sas creating both value/invalue statements for the given dataset? thanks in advance ... View more

sorry. could u pls provide me the logic ... View more

thanks a lot. you understood my problem. several times I executed that code,sometimes it is hanging but sometimes it is  not. I ran separately those statements also(dm and proc). then also can't identify when sas is hanging or when command is working fine. anyhow I wont use those commands from now onwards and thanks again. ... View more

sorry for the trouble. first program:                   for the  input dataset, sas created a informat with the given values. second program:              for the input dataset, sas created a format  with the given values. in both the cases I have given fmtname,start and label only,but one time sas created a format another time sas created informat first program proc format cntlin=exposure fmtlib; * here sas created a informat from the varibles( fmtname,start and end values) run; proc format;   select @exp1944fmt @exp1945fmt;  run; second program proc format cntlin=control fmtlib; * here sas created a format from the varibles (fmtname,start and end values) run; proc format;   select $ICDFMT; run; ... View more

Hi , I am using 9.2 pc SAS. I  ran the program to make sure that sas hangs with mentioned code(only that code) .yes, it is . I need: I need the commands to clear the graph window ,if you can ,please(like Ctrl E for clearing the logs). when running the programs,sas always appending the results to my graph window. which is really annoying me. Even closing the graph window and running my program again is not solving my problem. code: dm "graph;end" ; proc catalog c=work.gseg kill ;   run;  quit; ... View more