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 9341In 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 7163There 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 11611how 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 7358my 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 5682how 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 10861%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 18614Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 6398
Describe the ways in which you can create macro variables? : sas-macro
Do you know the features of sas?
What is the difference between reading data from an external file and reading data from an existing data set?
what does the run statement do? : Sas programming
Name few SAS functions?
why is sas data integration studio important? : Sas-di
what is the difference between unique key and primary key? : Sas-di
What are the implications?
Describe the ways in which you can create a macro variable?
Describe crosslist option in tables statement?
What is the difference between match merge and one to one merge?
How does the internal authentication work in sas? : sas-grid-administration
what are validation tools that are used in sas? : Sas-administrator
What is the role of sas grid administrator? : sas-grid-administration
Why double trailing @@ is used in input statement?