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 9031There 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 13869how 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 8627my 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 6740how 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 13479%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 20345Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 7566
What are the ways to do a “table lookup” in sas?
What Proc glm does?
which date function advances a date, time or datetime value by a given interval? : Sas programming
How can you create a macro variable with in data step? : sas-macro
Explain translate function?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What are the 3 components in sas programming?
How do you debug and test your SAS programs?
What are types of transport files?
what is null hypothesis? why do you consider that?
To what type of programms have you used scratch macros?
How long can a macro variable be? A token? : sas-macro
what is the difference between nodup and nodupkey options? : Sas programming
Mention what is the difference between nodupkey and nodup options?
How to specify variables to be processed by the freq procedure?