created on Aug. 9, 2019, 9:20 a.m.
1) Write a SAS program to import Excel file
%macro import(dtf,name);
%let path =/home/khanhpham0/RangeTech/Project/;
%let filename = &dtf;
proc import datafile= "&path&filename"
out=work.&name
dbms=xlsx replace;
getnames= yes;
sheet = "&namesheet";
%mend;
/*run test*/
%import(dtf =Transactional data,name=khanh);
The H-1B visas are for temporary workers in a specialty occupation in the USA. These types of temporary workers who have applied for H-1B visas are essentially foreign professionals. Each year, employers will file H-1B applications in order to sponsor their foreign employees who need a work visa in order to stay in the country. Since 2014, the H-1B applications have reached their acceptance cap within just five days after the application period opens each April. A H-1B visa is key for foreign employees seeking to work and reside in the United States following their use of OPT and OPT extensions. Each year, there are 65,000 applications that are approved, plus twenty thousand additional applicants—these are foreigners who have earned either a Master’s degree or PhD from a US-based university. For people who would like to be considered for the H-1B visa worker program, knowing which employers are the most willing to file for sponsorship (and which ones have done so successfully and frequently), as well as which types of work fields will pay the best salary, would greatly help them in their job searches.
