what are all the ways to define macro variable??
Answers were Sorted based on User's Feedback
Answer / rahul
%Let
Iterative %DO statement
%GLOBAL statement
%INPUT statement
INTO clause of the SELECT statement in SQL
%LOCAL statement
%MACRO statement
SYMPUT routine and SYMPUTN routine in SCL
%WINDOW statement
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / varun kumar
There are 5 ways to create a macro avriable.
1)using %LET statement.
2)Using %GLOBAL statement.
3)Using "CALL SYMPUT" routine.
4)Using Proc Sql.
5)Through parameters.
Is This Answer Correct ? | 2 Yes | 0 No |
what do the pad and dim functions do? : Sas programming
What is the length assigned to the target variable by the scan function?
How many missing values are available? When might you use them?
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
Name and describe three SAS functions that you have used, if any?
How can I remove header from output data set?
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
What is slibref?