if you have 365 no of data set and each one having different
variable from each other. how will you read by creating
macros and create a single data set.
Answers were Sorted based on User's Feedback
Answer / manoj mishra
Make a library where all data set resides. Use proc contect
and out option to create a data of proc contect from where
we get all data set name. Create Macro using Call Symput for
each dataset name into separate macro variable. We can not
merge them as they dont have common variable. We need set or
Append or SQL to merge them together.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / singh.naveen409
%macro naveen(xx,n);
data www;
merge
%do i=1 %to &n;
&xx&i
%end;
;
run;
%mend naveen;
%naveen (qq,2);
Is This Answer Correct ? | 1 Yes | 10 No |
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Mention what is SAS data set?
One way of creating a new variable in Macros is by % Let....What is the other way..?
How do you read in the variables that you need?
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
what is the use of LRECL option.
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
what is sas metadata server? : Sas-di
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
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What is the role of administrative users? : sas-grid-administration
how do you debug and test your sas programs? : Sas programming