How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
3 9379In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
6 7221There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
D&B,
8 11672how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
CMC,
3 7393my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
2 5700how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?
8 10939%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help
2 18691Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 6436
Describe a time when you were really stuck on a problem and how you solved it?
for what purpose would you use the retain statement? : Sas programming
In sas, what are the areas that you are most interested in? : sas-grid-administration
Describe a time when you were really stuck on a problem and how you solved it?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What are SAS/ACCESS and SAS/CONNECT?
Define run-group processing?
Mention the validation tools used in SAS?
What is the maximum and minimum length of macro variable
What are the functions which are used for character handling functions?
What would you change about your job?
State the difference between INFORMAT and FORMAT ?
What is by-group processing?
What are the ways in which macro variables can be created in sas programming?
what is sas data set?