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 10867In 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 9043There 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 13885how 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 8634my 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 6748how 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 13497%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 20356Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 7590
Give an example where SAS fails to convert character value to numeric value automatically?
how many display types available in sas bi dashboard? : Sas-bi
What is the difference between reading data from an external file and reading data from an existing data set?
Can you explain the process of calendar?
What do you understand by the term Normal Distribution?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Mention what is PROC in SAS?
what are informats in sas? : Sas-administrator
How would you include common or reuse to be processed along with your statements?
Mention the difference between ceil and floor functions in sas?
What is run-group processing?
What function CATX syntax does?
What are the implications?
how to remove duplicates using proc sql?
Explain bmdp procedure?