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 10841In 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 9007There 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 13850how 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 8608my 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 6725how 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 13450%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 20320Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 7550
name several ways to achieve efficiency in your program? : Sas programming
How do you test for missing values?
What are the parameters of scan function?
Differentiate between format and informat? : sas-grid-administration
What is the maximum length of the macro variable? : sas-macro
Name and describe few sas character functions that are used for data cleaning in brief.
Mention the category in which sas informats are placed?
what is hash files in sas and why we are using this one in sas?
How sas treats the dsd delimiters?
what is the Population you used in your project, is it ITT or PP?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
which features do you use to check the data validations and errors? : Sas-administrator
What are the difference between ceil and floor functions in sas?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
Have you ever used the SAS Debugger?