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 9765In 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 7766There 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 12313how 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 7732my 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 5939how 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 11589%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 19217Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 6695
What can be the size of largest dataset in SAS?
What is data _null_?
what are the benefits of data integration? : Sas-di
What are the default statistics for means procedure?
describe about metadata object? : Sas-di
How do you delete duplicate observations in sas?
What is the difference between where and if statement?
What are pdv and it functions?
What is the purpose of trailing @ and @@? How do you use them?
What is the function of output statement in a SAS Program?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
How can sas program be validated?
What is the difference between nodupkey and nodup options?
how to generate the test data in sas without input data? : Sas-administrator
what does the run statement do? : Sas programming
