topic Re: SAS macro to import different type of file in SAS Programming

SAS macro to import different type of file

pallab — Wed, 14 Feb 2018 07:26:05 GMT

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”)

Re: SAS macro to import different type of file

andreas_lds — Wed, 14 Feb 2018 08:03:05 GMT

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.

Re: SAS macro to import different type of file

pallab — Wed, 14 Feb 2018 08:18:58 GMT

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.)

Re: SAS macro to import different type of file

Reeza — Wed, 14 Feb 2018 16:26:54 GMT

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

Re: SAS macro to import different type of file

lrn1 — Sat, 22 Jun 2019 06:53:11 GMT

did u get answer.. reply me fast