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 10856In 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 9028There 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 13868how 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 8624my 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 6738how 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 13475%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 20343Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 7565
What is the use of the %include statement?
Describe the function and untility of the most difficult SAS macro that you have written.
What is the difference between %local and %global? : sas-macro
Explain data_null_?
name some data transformation used in sas di? : Sas-di
What are types of transport files?
explain about data integrator metadata reports? : Sas-di
Name types of category in which SAS Informats are placed?
What is the basic syntax of a sas program?
Mention some common errors that are usually committed in sas programming.
what is star schema? : Sas-di
What is the work of tranwrd function?
why is sas data integration studio important? : Sas-di
how to do user inputs and command line arguments in sas?
What is the difference between proportion and average?