SAS macro to import different type of file

[pallab]

Write a macro to import different type of files. Let’s say we have files that are tab delimited text files as well as csv files. (“Sample.csv” and “Scores.txt”)

[andreas_lds · Accepted solution]

Homework?

Have a look a proc import - not may preferred way to read text files - write one for each file type, compare the differences, create a macro with parameters.

[pallab]

Required help to convert the below SAS codes into macros.

a) proc gchart data=HTWT; vbar gender/sumvar=weight; Title "Average weight by Gender";
run;
b) proc plot data=HTWT; Title "Scatter plot"; plot &height*&weight;
run;
(Hint: Define two different macros.) 

[Reeza]

@pallab You should use PROC SGPLOT not GCHART or PLOT these days. The graphics quality is much better.

[lrn1]

did u get answer.. reply me fast